private void btnSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtAddress.Text)) { MessageBox.Show("please enter your address"); } else { if (string.IsNullOrEmpty(txtTXTPHONE.Text) && string.IsNullOrEmpty(txtMOBILE.Text)) { MessageBox.Show("please enter your phone no and mo no"); } //else //{ // if (!this.txtEMAILADDRESS.Text.Contains('@') || !this.txtEMAILADDRESS.Text.Contains('.')) // { // MessageBox.Show("Please select your correct email address"); // } // else // { // if (!this.txtWEBSITE.Text.Contains('@') || !this.txtWEBSITE.Text.Contains('.') || !this.txtWEBSITE.Text.Contains('/')) // { // MessageBox.Show("plese select your corect website"); // } else { if (updateCounter == 0) { string saveCommand1 = "insert into CustomerDetails values ('" + txtCustCode.Text + "','" + txtName.Text + "','" + txtCompnyName.Text + "','" + txtAddress.Text + "','" + txtCity.Text + "','" + txtState.Text + "','" + txtZIP.Text + "','" + txtCustCountry.Text + "','" + txtEMAILADDRESS.Text + "','" + txtWEBSITE.Text + "','" + txtTXTPHONE.Text + "', '" + txtMOBILE.Text + "','" + txtFAX.Text + "','" + txtDESCRIPTION.Text + "','" + txtPanno.Text + "','" + txttanno.Text + "','" + txtothers.Text + "')"; string saveCommand2 = "insert into CustomerAccountDetails values ('" + txtCustCode.Text + "','" + txtCustCode.Text + "','" + txtOPENINGBALANCE.Text + "','" + txtCURRENTBALANCE.Text + "')"; int insertedRows = dbMainClass.saveDetails(saveCommand1, saveCommand2); if (insertedRows > 0) { btnList.Enabled = true; txtName.Focus(); MessageBox.Show("Details Saved Successfully"); } else { MessageBox.Show("Details Not Saved Successfully"); } } else if (updateCounter == 1) { string updateCommand1 = "update CustomerDetails set Custid='" + txtCustCode.Text + "', CustAddress='" + txtAddress.Text + "',CustPhone='" + txtTXTPHONE.Text + "', CustMobile='" + txtMOBILE.Text + "',PanNO='" + txtPanno.Text + "',TanNo='" + txttanno.Text + "',Others='" + txtothers.Text + "', CustName='" + txtName.Text + "', CustCompName= '" + txtCompnyName.Text + "',CustCity='" + txtCity.Text + "',CustState='" + txtState.Text + "',CustZip='" + txtZIP.Text + "',CustCountry='" + txtCustCountry.Text + "',CustEmail='" + txtEMAILADDRESS.Text + "',CustWebAddress='" + txtWEBSITE.Text + "',CustFax='" + txtFAX.Text + "',CustDesc='" + txtDESCRIPTION.Text + "' where Custid='" + txtCustCode.Text + "'"; string updateCommand2 = "update CustomerAccountDetails set CustOpeningBalance='" + txtOPENINGBALANCE.Text + "',CustCurrentBalance='" + txtCURRENTBALANCE.Text + "' where Custid='" + txtCustCode.Text + "'"; int updatedRows = dbMainClass.updateDetails(updateCommand1, updateCommand2); if (updatedRows > 0) { txtName.Focus(); MessageBox.Show("Details Updated Successfully"); } else { MessageBox.Show("Details Can not updated"); } updateCounter = 0; } makeblank(); blank1(); string Id = dbMainClass.getUniqueID("CUSTOMER"); txtCustCode.Text = Id; } } }
/// <summary> /// To Save Details /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnVenderSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtVenderName.Text)) { MessageBox.Show("please Enter the name"); } else { if (string.IsNullOrEmpty(txtCompanyName.Text)) { MessageBox.Show("please Enter the Company name"); } else { if (string.IsNullOrEmpty(txtVenderAddress.Text)) { MessageBox.Show("please Enter the Address"); } else { //if (string.IsNullOrEmpty(txtVenderPhone.Text) && string.IsNullOrEmpty(txtVenderMobile.Text)) //{ // MessageBox.Show("please Enter the Mobile No. ya Phone No."); //} //else //{ // if (!this.txtVenderEmailAddress.Text.Contains('@') || !this.txtVenderEmailAddress.Text.Contains('.')) // { // MessageBox.Show("Please Enter the Correct Email Address"); // } // else // { //if (!this.txtVenderWebSite.Text.Contains('@') || !this.txtVenderWebSite.Text.Contains('.') || !this.txtVenderWebSite.Text.Contains("http://")) //{ // MessageBox.Show("Please Enter the Correct Web Site Address"); ////} //else //{ if (updateCounter == 0) { string saveCommand1 = "insert into VendorDetails values ('" + txtVenderCode.Text + "','" + txtVenderName.Text + "','" + txtCompanyName.Text + "','" + txtVenderAddress.Text + "','" + txtVenderCity.Text + "','" + txtVenderState.Text + "','" + txtVenderZip.Text + "','" + txtVenderCountry.Text + "','" + txtVenderEmailAddress.Text + "','" + txtVenderWebSite.Text + "','" + txtVenderPhone.Text + "', '" + txtVenderMobile.Text + "','" + txtVenderFax.Text + "','" + txtVenderDesc.Text + "','" + txtPanNo.Text + "','" + txtTinNo.Text + "','" + txtOther.Text + "')"; string saveCommand2 = "insert into VendorAccountDetails values ('" + txtVenderCode.Text + "','" + txtVenderCode.Text + "','" + txtVenderOpeningBal.Text + "','" + txtVenderCurrentBal.Text + "')"; int insertedRows = dbMainClass.saveDetails(saveCommand1, saveCommand2); if (insertedRows > 0) { btnVenderList.Enabled = true; MessageBox.Show("Details Saved Successfully"); txtVenderName.Focus(); } else { MessageBox.Show("Details Not Saved Successfully"); } } else if (updateCounter == 1) { string updateCommand1 = "update VendorDetails set vName='" + txtVenderName.Text + "', vCompName= '" + txtCompanyName.Text + "',vAddress='" + txtVenderAddress.Text + "',vCity='" + txtVenderCity.Text + "',vState='" + txtVenderState.Text + "',vZip='" + txtVenderZip.Text + "',vCountry='" + txtVenderCountry.Text + "',vEmail='" + txtVenderEmailAddress.Text + "',vWebAddress='" + txtVenderWebSite.Text + "',vPhone='" + txtVenderPhone.Text + "', vMobile='" + txtVenderMobile.Text + "',vFax='" + txtVenderFax.Text + "',vPanNo='" + txtPanNo.Text + "',vTinNo='" + txtTinNo.Text + "',vDesc='" + txtVenderDesc.Text + "',vOther='" + txtOther.Text + "' where venderid='" + txtVenderCode.Text + "'"; string updateCommand2 = "update VendorAccountDetails set vOpeningBalance='" + txtVenderOpeningBal.Text + "',vCurrentBalance='" + txtVenderCurrentBal.Text + "' where venderId='" + txtVenderCode.Text + "'"; int updatedRows = dbMainClass.updateDetails(updateCommand1, updateCommand2); if (updatedRows > 0) { txtVenderName.Focus(); MessageBox.Show("Details Updated Successfully"); } else { MessageBox.Show("Details Can not updated"); } updateCounter = 0; } makeBlank(); Enabled2(); string Id = dbMainClass.getUniqueID("VENDOR"); txtVenderCode.Text = Id; //} //} } } } }