TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
naga jyothi
NA
62
110.5k
Data was not updating the first time second time it is updating please rectify that problem
Aug 9 2012 1:25 AM
//Code for insert and update the data into database
private void btnAdvanceSave_Click(object sender, EventArgs e)
{
if (sanctiondateValidation() == false)
return;
try
{
string str = "Select SrlNo,EmpId,AdvanceType,AmountTaken,SanctionedDate,SanctionedBy from AdvancePaymentsMaster where EmpID='" + txtemployeeid.Text + "'and SanctionedDate=#"+dtpSanctionedDate.Value+"#";
dbConnection conn = new dbConnection();
OleDbDataReader dr = conn.OleDbReaderQuery(str);
if (dr.Read())
{
BOL.bolAdvancePaymentsMaster apm = new PayRoll.BOL.bolAdvancePaymentsMaster();
//apm.AdvanceType = cmbAdvanceType.Text;
apm.AdvanceType = cmbAdvanceType.Text;
apm.AmountTaken = Convert.ToDecimal(txtAmountTaken.Text);
apm.EmpID = txtemployeeid.Text;
apm.SanctionedBy = txtSanctionedBy.Text;
apm.SanctionedDate = Convert.ToDateTime(dtpSanctionedDate.Value);
apm.Update();
MessageBox.Show("Record updated sucessfully","Payroll",MessageBoxButtons.OK,MessageBoxIcon.Information );
}
else
{
BOL.bolAdvancePaymentsMaster apm1 = new PayRoll.BOL.bolAdvancePaymentsMaster();
apm1.AdvanceType = cmbAdvanceType.Text;
apm1.AmountTaken = Convert.ToDecimal(txtAmountTaken.Text);
apm1.EmpID = txtemployeeid.Text;
apm1.SanctionedBy = txtSanctionedBy.Text;
apm1.SanctionedDate = Convert.ToDateTime(dtpSanctionedDate.Value);
apm1.Insert();
MessageBox.Show("Record Successfully Saved","Payroll",MessageBoxButtons.OK,MessageBoxIcon.Information );
}
dr.Close();
loadAdvances();
clearAdvances();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"Payroll",MessageBoxButtons.OK,MessageBoxIcon.Information );
}
}
//Code for Load Advances into gridview
private void loadAdvances()
{
gvadvances.DataSource = null;
//string str = "select EmpId as [Employee ID],AdvanceType as [Advance Type],AmountTaken as [Amount],Format(SanctionedDate,"dd-mm-yyyy") as [SDate],SanctionedBy as [Sanctioned By] from [AdvancePaymentsMaster] where EmpID='" + txtemployeeid.Text + "'";
string str = "select EmpId as [Employee ID],AdvanceType as [Advance Type],AmountTaken as [Amount],Format(SanctionedDate,'dd-mm-yyyy') as [SDate],SanctionedBy as [Sanctioned By] from [AdvancePaymentsMaster] where EmpID='" + txtemployeeid.Text + "'";
DataTable dt = conn.executeSelectQueryNonParameter(str);
gvadvances.DataSource = dt;
}
//Code for Bol database
public bool Update(BOL.bolAdvancePaymentsMaster obj)
{
dbConnection conn =new dbConnection();
string sql = "update AdvancePaymentsMaster set AdvanceType=@AdvanceType,AmountTaken=@AmountTaken,SanctionedDate=@SanctionedDate,SanctionedBy=@SanctionedBy where EmpId=@EmpId and SanctionedDate=@SanctionedDate";
OleDbParameter[] oledbParameters = new OleDbParameter[5];
//sqlParameters[0] = new SqlParameter("@Srlno", SqlDbType.Int);
//sqlParameters[0].Value = obj.Srlno;
oledbParameters[0] = new OleDbParameter("@EmpId", OleDbType.VarChar);
oledbParameters[0].Value = obj.EmpID;
oledbParameters[1] = new OleDbParameter("@AdvanceType", OleDbType.VarChar);
oledbParameters[1].Value = obj.AdvanceType;
oledbParameters[2] = new OleDbParameter("@AmountTaken", OleDbType.Decimal);
oledbParameters[2].Value = obj.AmountTaken;
oledbParameters[3] = new OleDbParameter("#@SanctionedDate#", OleDbType.Date);
oledbParameters[3].Value = obj.SanctionedDate;
oledbParameters[4] = new OleDbParameter("@SanctionedBy", OleDbType.VarChar);
oledbParameters[4].Value = obj.SanctionedBy;
return conn.executeUpdateQuery(sql, oledbParameters);
}
//code for insert the database
public bool executeInsertQuery(String _query, OleDbParameter[] sqlParameter)
{
OleDbCommand myCommand = new OleDbCommand();
try
{
myCommand.Connection = openConnection();
myCommand.CommandText = _query;
myCommand.Parameters.AddRange(sqlParameter);
myAdapter.InsertCommand = myCommand;
myCommand.ExecuteNonQuery();
}
catch (OleDbException e)
{
Console.Write("Error - Connection.executeInsertQuery - Query: " + _query + " \nException: \n" + e.StackTrace.ToString());
return false;
}
finally
{
}
return true;
}
Reply
Answers (
1
)
Not updating the data so please rectify this error
how to add emoticon in RichTextBox in WPF