private void button1_Click(object sender, EventArgs e)
{
if (IsEditMode == false)
{
var insertBankentry = "insert into bankentry(BankId,BankName,BankAddress) values(" + txtbnkid.Text + ",'" + txtbnkname.Text + "','" + txtbnkaddrss.Text + "')";
DBconnection.ExecuteNonQuery(insertBankentry);
MessageBox.Show("Data save sucessfully",
"save bankentry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var updateBankentry = "update bankentry set BankName='" + txtbnkname.Text + "', BankAddress='" + txtbnkaddrss.Text + "' where BankId=" + txtbnkid.Text + "";
DBconnection.ExecuteNonQuery(updateBankentry);
MessageBox.Show("Data Updated sucessfully",
"update bankentry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Loadbankentry();
EnableDisableControl("Reset");
}
private void btnsave_Click(object sender, EventArgs e)
{
if (IsEditMode == false)
{
var insertchequeentry = "insert into chequeentry(ChequeId,BankID,PartyId,ChequeNo,ChequeBearer,EntryDate,DateOfCash,UserId) values('" + txtchequeid.Text + "','" + txtbnkid.Text + "','" + txtprtyid.Text + "','" + txtchqno.Text + "','" + txtchqbearer.Text + "','" + dateTimeentrydate.Value.Date.ToString("MM-dd-yyyy") + "','" + dateTimedateofcash.Value.Date.ToString("MM-dd-yyyy") + "','" + txtuserid.Text + "')";
DBconnection.ExecuteNonQuery(insertchequeentry);
MessageBox.Show("Data save sucessfully",
"save UserEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var updatchequeentry = "Update chequeentry set BankID='" + txtbnkid.Text + "',PartyId='" + txtprtyid.Text + "',ChequeNo='" + txtchqno.Text + "',ChequeBearer='" + txtchqbearer.Text + "',EntryDate='" + dateTimeentrydate.Value.Date.ToString("MM-dd-yyyy") + "',DateOfCash='" + dateTimedateofcash.Value.Date.ToString("MM-dd-yyyy") + "',UserId='" + txtuserid.Text + "' where chequeId='" + txtchequeid.Text + "'";
DBconnection.ExecuteNonQuery(updatchequeentry);
MessageBox.Show("Data Updated sucessfully",
"update chequeEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
loadchequeentry();
EnableDisableControl("Reset");
}
private void btnsave_Click(object sender, EventArgs e)
{
if (IsEditMode == false)
{
var insertpartyentry = "insert into partyentry(PartyId,PartyName,PartyAddress,MobileNo,Telephone,UserID) values('" + txtpartyid.Text + "','" + txtprtyname.Text + "','" + txtprtyadrs.Text + "','" + txtmblno.Text + "','" + txtphone.Text + "','" + txtuserid.Text + "')";
DBconnection.ExecuteNonQuery(insertpartyentry);
MessageBox.Show("Data save sucessfully",
"save UserEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var updatepartyentry = "update partyentry set PartyName='" + txtprtyname.Text + "', PartyAddress='" + txtprtyadrs.Text + "', MobileNo='" + txtmblno.Text + "',Telephone ='" + txtphone.Text + "', UserID='" + txtuserid.Text + "' where partyId='" + txtpartyid.Text + "'";
DBconnection.ExecuteNonQuery(updatepartyentry);
MessageBox.Show("Data Updated sucessfully",
"update PartyEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
loadpartyentry();
EnableDisableControl("Reset");
}
private void btnsave_Click(object sender, EventArgs e)
{
if (IsEditMode == false)
{
var insertUserEntry = "insert into Userid(UserID,StaffName,Email,UserName,Password,Telephone) " +
"values('" + txtuserid.Text + "','" + txtstaffname.Text + "','" + txtemail.Text + "','" + txtusername.Text + "','" + txtpswrd.Text + "','" + txtphone.Text + "')";
DBconnection.ExecuteNonQuery(insertUserEntry);
MessageBox.Show("Data save sucessfully",
"save UserEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var updateUserEntry = "update Userid set StaffName='" + txtstaffname.Text + "', Email='" + txtemail.Text + "', UserName='******'," +
"Password= '******', Telephone='" + txtphone.Text + "' where UserID='" + txtuserid.Text + "'";
DBconnection.ExecuteNonQuery(updateUserEntry);
MessageBox.Show("Data Updated sucessfully",
"update UserEntry", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
loadUserEntry();
EnableDisableControl("Reset");
}