public void SaveFormData()
{
try
{
clsCompanyBusiness objSave = new clsCompanyBusiness();
objSave.CompanyName = txtName.Text;
objSave.CompanyBusinessTitle = txttitle.Text;
objSave.CompanyBusinessDescription = txtDescription.Text;
objSave.CompanyBusinessAddress = txtAddress.Text;
objSave.CompanyBusinessContact1 = txtContact1.Text;
objSave.CompanyBusinessContact2 = txtContact2.Text;
objSave.CompanyBusinessGstTinNo = txtGstTinNo.Text;
objSave.CompanyBusinessBankName = txtBankName.Text;
objSave.CompanyBusinessBankAcctNo = txtActNo.Text;
objSave.CompanyBusinessBankIFSCCode = txtIFSCCode.Text;
objSave.CompanyBusinessBankBranch = txtBranch.Text;
objSave.CompanyBusinessKey = Convert.ToInt32(txtKey.Text);
objSave.Mode = "UPDATE";
objSave.AddUpdateDelete();
MessageBox.Show(txtName.Text + " " + "Update SuccessFully", "Company Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadFormData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SaveFormData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadFormData()
{
try
{
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTONE";
var lstUser = objLoad.GetCompanyBusiness().FirstOrDefault();
if (lstUser != null)
{
txtName.Text = lstUser.CompanyName;
txttitle.Text = lstUser.CompanyBusinessTitle;
txtDescription.Text = lstUser.CompanyBusinessDescription;
txtAddress.Text = lstUser.CompanyBusinessAddress;
txtContact1.Text = lstUser.CompanyBusinessContact1;
txtContact2.Text = lstUser.CompanyBusinessContact2;
txtGstTinNo.Text = lstUser.CompanyBusinessGstTinNo;
txtBankName.Text = lstUser.CompanyBusinessBankName;
txtActNo.Text = lstUser.CompanyBusinessBankAcctNo;
txtIFSCCode.Text = lstUser.CompanyBusinessBankIFSCCode;
txtBranch.Text = lstUser.CompanyBusinessBankBranch;
lblAccountHeader.Text = "Welcome To";
lblAccountHeader.Text = lblAccountHeader.Text + " " + txtName.Text;
txtKey.Text = lstUser.CompanyBusinessKey.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "LoadFormData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SaveFormData(string mode)
{
try
{
clsCompanyBusiness objSave = new clsCompanyBusiness();
objSave.CompanyName = txtName.Text;
objSave.CompanyBusinessTitle = txttitle.Text;
objSave.CompanyBusinessDescription = txtDescription.Text;
objSave.CompanyBusinessAddress = txtAddress.Text;
objSave.CompanyBusinessContact1 = txtContact1.Text;
objSave.CompanyBusinessContact2 = txtContact2.Text;
objSave.CompanyBusinessGstTinNo = txtGstTinNo.Text;
objSave.CompanyBusinessBankName = txtBankName.Text;
objSave.CompanyBusinessBankAcctNo = txtActNo.Text;
objSave.CompanyBusinessBankIFSCCode = txtIFSCCode.Text;
objSave.CompanyBusinessBankBranch = txtBranch.Text;
objSave.CompanyID = Convert.ToInt32(txtKey.Text);
objSave.CompanyStateName = txtState.Text;
objSave.CompanyStateCode = txtStateCode.Text;
objSave.Mode = mode;
if (mode.ToUpper().Equals("DELETE"))
{
var confirmation = MessageBox.Show("Are You Sure You Want to Delete " + " " + txtName.Text, "Company Master Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (confirmation.ToString().Equals("Yes"))
{
objSave.AddUpdateDelete();
BindDataGrid();
ResetFormControl();
}
}
else
{
String msg = objSave.Validation();
if (msg.Length > 0)
{
MessageBox.Show(msg, "Company Master Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
objSave.AddUpdateDelete();
MessageBox.Show(txtName.Text + " " + mode + " Success Fully", "Company Master Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindDataGrid();
ResetFormControl();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SaveFormData", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindDataGrid()
{
try
{
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTALL";
dgvCustomerMaster.AutoGenerateColumns = false;
var ds = objLoad.GetAllCompany();
dgvCustomerMaster.DataSource = ds.Tables[0];
lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindDataGrid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SearchBindDataGrid()
{
try
{
dgvCustomerMaster.DataSource = null;
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTALL";
objLoad.CompanyName = txtSearchCompany.Text;
objLoad.CompanyBusinessAddress = txtSearchAddress.Text;
dgvCustomerMaster.AutoGenerateColumns = false;
var ds = objLoad.SearchCompanyDetail();
dgvCustomerMaster.DataSource = ds.Tables[0];
lblRecordCount.Text = ds.Tables[0].Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "SearchBindDataGrid", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void BindCompanyCombo()
{
try
{
clsCompanyBusiness objLoad = new clsCompanyBusiness();
objLoad.Mode = "SELECTALL";
var ds = objLoad.GetAllCompany();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr["CompanyBusinessKey"] = "0";
dr["CompanyName"] = "Please Select Company";
dt.Rows.InsertAt(dr, 0);
//DataRow dr = dt.NewRow();
/* Bind the Item Group */
cmbCompany.DataSource = dt;
cmbCompany.DisplayMember = "CompanyName";
cmbCompany.ValueMember = "CompanyBusinessKey";
cmbCompany.Text = "Please Select Company";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "BindCompanyCombo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
