public void BindCustomerComboBox() { try { /***************** Bind the Customer Combo*******************/ clsCustomerMaster objLoad = new clsCustomerMaster(); objLoad.Mode = "SELECTALL"; objLoad.CompanyID = cId; var dsCustomer = objLoad.GetAllCustomer(); DataTable dtCustomer = dsCustomer.Tables[0]; DataRow dr = dtCustomer.NewRow(); dr["CustomerID"] = "0"; dr["CustomerName"] = "All"; dtCustomer.Rows.InsertAt(dr, 0); cmbCustomer.DataSource = dtCustomer; cmbCustomer.DisplayMember = "CustomerName"; cmbCustomer.ValueMember = "CustomerID"; cmbCustomer.Text = "All"; /***************** Bind the Customer Combo*******************/ } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "BindCustomerComboBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int DeleteCustomer(clsCustomerMaster obj) { SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand("spDeleteCustomer", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CustomerID", obj.CustomerID); cmd.Parameters.AddWithValue("@UserID", obj.UserID); con.Open(); int count = cmd.ExecuteNonQuery(); con.Close(); return(count); }
public void BindDataGrid() { try { clsCustomerMaster objLoad = new clsCustomerMaster(); objLoad.Mode = "SELECTALL"; objLoad.CompanyID = cId; dgvCustomerMaster.AutoGenerateColumns = false; var ds = objLoad.GetAllCustomer(); 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 int InsertUpdateCustomer(clsCustomerMaster obj) { SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand("spInsertUpdateCustomer", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("CustomerID", obj.CustomerID); cmd.Parameters.AddWithValue("Name", obj.Name); cmd.Parameters.AddWithValue("MobileNo", obj.MobileNo); cmd.Parameters.AddWithValue("Gender", obj.Gender); cmd.Parameters.AddWithValue("EmailID", obj.EmailID); cmd.Parameters.AddWithValue("UserID", obj.UserID); con.Open(); obj.CustomerID = Convert.ToInt32(cmd.ExecuteScalar()); con.Close(); return(obj.CustomerID); }
protected void btnEdit_Click(object sender, EventArgs e) { lblmsg.Text = string.Empty; GridViewRow gvr = ((Button)sender).Parent.Parent as GridViewRow; obj = new clsCustomerMaster(); DataTable dt = obj.SelectCustomer(Convert.ToInt32(gvCustomer.DataKeys[gvr.RowIndex]["CustomerID"].ToString())); if (dt.Rows.Count > 0) { (gvCustomer.FooterRow.FindControl("hdfCustomerIDft") as HiddenField).Value = dt.Rows[0]["CustomerID"].ToString(); (gvCustomer.FooterRow.FindControl("txtName") as TextBox).Text = dt.Rows[0]["Name"].ToString(); (gvCustomer.FooterRow.FindControl("txtMobileNo") as TextBox).Text = dt.Rows[0]["MobileNo"].ToString(); (gvCustomer.FooterRow.FindControl("txtEmailID") as TextBox).Text = dt.Rows[0]["EmailID"].ToString(); (gvCustomer.FooterRow.FindControl("rdbGender") as RadioButtonList).Items.FindByValue(dt.Rows[0]["Gender"].ToString()).Selected = true; } }
protected void btnDelete_Click(object sender, EventArgs e) { lblmsg.Text = string.Empty; GridViewRow gvr = ((Button)sender).Parent.Parent as GridViewRow; obj = new clsCustomerMaster(); obj.CustomerID = Convert.ToInt32(gvCustomer.DataKeys[gvr.RowIndex]["CustomerID"].ToString()); obj.UserID = Convert.ToInt32(Session["UserID"]); if (obj.DeleteCustomer(obj) > 0) { lblmsg.Text = "Record Deleted Successfully"; this.BindGridView(); } else { lblmsg.Text = "Opertation Failed!!!"; } }
public void SearchBindDataGrid() { try { dgvCustomerMaster.DataSource = null; clsCustomerMaster objLoad = new clsCustomerMaster(); objLoad.Mode = "SELECTALL"; objLoad.CompanyID = cId; objLoad.CustomerName = txtSearchCustomer.Text; objLoad.CustomerContactNo = txtSearchContactPerson.Text; objLoad.CustomerAddress = txtSearchAddress.Text; dgvCustomerMaster.AutoGenerateColumns = false; var ds = objLoad.GetSearchCustomer(); 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); } }
protected void btnSave_Click(object sender, EventArgs e) { lblmsg.Text = string.Empty; obj = new clsCustomerMaster(); GridViewRow gvr = ((Button)sender).Parent.Parent as GridViewRow; string hdf = (gvr.FindControl("hdfCustomerIDft") as HiddenField).Value; obj.CustomerID = (hdf == string.Empty || hdf == "0") ? 0 : Convert.ToInt32(hdf); obj.Name = (gvr.FindControl("txtName") as TextBox).Text.Trim(); obj.MobileNo = (gvr.FindControl("txtMobileNo") as TextBox).Text.Trim(); obj.EmailID = (gvr.FindControl("txtEmailID") as TextBox).Text.Trim(); obj.Gender = (gvr.FindControl("rdbGender") as RadioButtonList).SelectedItem.Text; obj.UserID = Convert.ToInt32(Session["UserID"]); if (obj.InsertUpdateCustomer(obj) > 0) { lblmsg.Text = "Record " + ((hdf == string.Empty || hdf == "0") ? "Inserted" : "Updated") + " Successfully"; Clear(gvr); this.BindGridView(); } else { lblmsg.Text = "Opertation Failed!!!"; } }
public void SaveFormData(String mode) { try { clsCustomerMaster objSave = new clsCustomerMaster(); objSave.CustomerID = Convert.ToInt32(txtKey.Text); objSave.CustomerName = txtCustomerName.Text; objSave.CustomerAddress = txtCustomerAddress.Text; objSave.CustomerContactPerson = txtContactPerson.Text; objSave.CustomerContactNo = txtContactNo.Text; objSave.CompanyID = cId; objSave.CustomerPanNo = txtCustomerPanNo.Text; String cstDate = dtpCstTinDate.Value.ToString("dd/MM/yyyy"); if (DateTime.Now.ToString("dd/MM/yyyy") != cstDate) { objSave.CustomerCSTDate = clsCommoan.GetDateInddMMYYYY(dtpCstTinDate.Value.ToString()); } String gstDate = dtpGstTinDate.Value.ToString("dd/MM/yyyy"); if (DateTime.Now.ToString("dd/MM/yyyy") != gstDate) { objSave.CustomerGSTDate = clsCommoan.GetDateInddMMYYYY(dtpGstTinDate.Value.ToString()); } objSave.Mode = mode.ToUpper(); if (mode.ToUpper().Equals("DELETE")) { var confirmation = MessageBox.Show("Are You Sure You Want to Delete " + " " + txtCustomerName.Text, "Customer Master Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (confirmation.ToString().Equals("Yes")) { objSave.AddUpdateDelete(); BindDataGrid(); ResetFormControl(); } } else { String msg = objSave.Validation(); //if (txtcstTinNo.Text.Length != 11 && txtcstTinNo.Text.Length>0) //{ // if (msg.Length.Equals(0)) // { // msg = "Please Enter the 11 Digit Cst Tin No: "; // } // else // { // msg = msg + "\n Please Enter the 11 Digit Valid Cst Tin No: "; // } //} //if (txtGstTinNo.Text.Length < 11 && txtGstTinNo.Text.Length > 0) //{ // if (txtGstTinNo.Text.Length!=11) // { // if (msg.Length.Equals(0)) // { // msg = "Please Enter the 11 Digit Valid Gst Tin No: "; // } // else // { // msg = msg + "\n Please Enter the 11 Digit Valid Gst Tin No: "; // } // } //} if (msg.Length > 0) { MessageBox.Show(msg, "Customer Master Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { objSave.CustomerCSTNo = txtcstTinNo.Text; if (txtGstTinNo.Text.Length > 0) { objSave.CustomerGSTNo = txtGstTinNo.Text; } objSave.AddUpdateDelete(); MessageBox.Show(txtCustomerName.Text + " " + mode + " Success Fully", "Customer Master Save", MessageBoxButtons.OK, MessageBoxIcon.Information); BindDataGrid(); ResetFormControl(); if (pageAction.Equals("Yes")) { this.Close(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "SaveFormData", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BindGridView() { obj = new clsCustomerMaster(); gvCustomer.DataSource = obj.SelectCustomer(0); gvCustomer.DataBind(); }
public string SaveCustomer(clsCustomerMaster CustomerData, clsCustomerContactMaster[] ContactData) { string msg = ""; /* Next Doc NO */ int nextDocNo = 0; int Link12 = 0; string FormattedNo = ""; // LOGIN COMPANY LINK(ID) clsCustomerMaster obj = CustomerData; obj.CompanyLink = HttpContext.Current.Request.Cookies["CompanyLink"].Value.ToString(); // CHECK DUPLICATE DataTable objdup = clsMethods.GetDuplicateCustomer(obj.Username, obj.CompanyLink); if (objdup.Rows.Count > 0) { if (obj.Link.ToString() == "0") { return("Customer is already in use, Please Enter another Name."); } else if (objdup.Rows.Count >= 2) { return("Customer is already in use, Please Enter another Name."); } else if (objdup.Rows[0]["Link"].ToString() != obj.Link.ToString()) { return("Customer is already in use, Please Enter another Name."); } } obj.IsDeactivate = false; // LINK 0 THEN INSERT ELSE UPDATE RECORD if (obj.Link.ToString() == "0") { DataTable dtNext = clsMethods.GetDocNo("QA"); if (dtNext.Rows.Count > 0) { // GET NEXT CUSTOMER NUMBER , NUMBER WILL BE LIKE THIS : QA00001 nextDocNo = Convert.ToInt32(dtNext.Rows[0]["Next_Doc_No"].ToString()); Link12 = Convert.ToInt32(dtNext.Rows[0]["Link"].ToString()); FormattedNo = clsMethods.FormatDocumentNo("QA", Convert.ToDecimal(nextDocNo)); } // CREATED BY , CREATED HOST NAME, DATE OF CREATION FOR ALL THE RECORD WHICH IS INSERT FOR ALL TABLE obj.CustomerNo = FormattedNo; obj.CreatedBy = Convert.ToInt32(HttpContext.Current.Request.Cookies["UserId"].Value); obj.CreatedHostName = HttpContext.Current.Request.UserHostName; obj.DateOfCreation = DateTime.Now; } else { // MODIFIED BY , MODIFIED HOST , MODIFIED DATE WHEN RECORD UPDATE. obj.LastModifiedBy = Convert.ToInt32(HttpContext.Current.Request.Cookies["UserId"].Value); obj.LastModifiedHost = HttpContext.Current.Request.UserHostName; obj.LastModifiedDate = DateTime.Now; } // THIS IS THE FUNCTION IN BAL PROJECT WHERE INSERT,UPDATE OR DELETE QUERY CREATE BASED ON THE OBJECT WHICH HAS DEFINE IN CLASS FILE. clsIFrameWork.SetIndependentTable(obj); // CREATE CONTACT for (int i = 0; i < ContactData.Length; i++) { clsCustomerContactMaster objM = ContactData[i]; objM.CustomerNo = obj.CustomerNo; objM.CompanyLink = HttpContext.Current.Request.Cookies["CompanyLink"].Value.ToString(); // LINK 0 THEN INSERT ELSE UPDATE RECORD if (objM.Link.ToString() == "0") { // CREATED BY , CREATED HOST NAME, DATE OF CREATION FOR ALL THE RECORD WHICH IS INSERT FOR ALL TABLE objM.CreatedBy = Convert.ToInt32(HttpContext.Current.Request.Cookies["UserId"].Value); objM.CreatedHostName = HttpContext.Current.Request.UserHostName; objM.DateOfCreation = DateTime.Now; } else { // MODIFIED BY , MODIFIED HOST , MODIFIED DATE WHEN RECORD UPDATE. objM.LastModifiedBy = Convert.ToInt32(HttpContext.Current.Request.Cookies["UserId"].Value); objM.LastModifiedHost = HttpContext.Current.Request.UserHostName; objM.LastModifiedDate = DateTime.Now; } // THIS IS THE FUNCTION IN BAL PROJECT WHERE INSERT,UPDATE OR DELETE QUERY CREATE BASED ON THE OBJECT WHICH HAS DEFINE IN CLASS FILE. clsIFrameWork.SetIndependentTable(objM); } bool issucc = false; try { // TRACACTION IS EXECUTE , SO ABOVE CREATED ALL QUERY WILL EXECUTE AT SAME TIME. issucc = clsIFrameWork.FireTransaction(); } catch (Exception ex) { // ERROR LOG FileStream fs = new FileStream(ServerLogFile, FileMode.Append, FileAccess.Write, FileShare.Write); fs.Close(); StreamWriter sw = new StreamWriter(ServerLogFile, true, Encoding.ASCII); sw.WriteLine(ex.ToString() + System.DateTime.Now.ToString()); sw.Close(); msg = ex.Message; } if (issucc) { return("Record Saved Successfully."); } else { return(msg); } }