/// <summary> /// Insert a row /// </summary> /// <param name="entity"></param> /// <returns></returns> public int CustomerOfCompany_Insert(CustomerOfCompany entity) { using (SqlConnection conn = new SqlConnection(AppConfiguration.ConnectionString)) { SqlCommand command = new SqlCommand("CustomerOfCompany_Insert", conn); command.CommandType = CommandType.StoredProcedure; try { command.Parameters.Add(new SqlParameter("@Company_Id", SqlDbType.UniqueIdentifier)); command.Parameters["@Company_Id"].Value = entity.Company_Id; command.Parameters.Add(new SqlParameter("@Customer_Id", SqlDbType.UniqueIdentifier)); command.Parameters["@Customer_Id"].Value = entity.Customer_Id; conn.Open(); return command.ExecuteNonQuery(); } catch { throw; } finally { command.Dispose(); } } }
/// <summary> /// Update a row /// </summary> /// <param name="entity"></param> /// <returns></returns> public int CustomerOfCompany_Update(CustomerOfCompany entity) { return customer.CustomerOfCompany_Update(entity); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (GetDataForm() == null) { pnlRed.Visible = true; lblError.Text = "Please check data."; return; } Problem entity = GetDataForm(); if (problem.Problem_Insert(entity) == 0) { pnlRed.Visible = true; lblError.Text = "Do not success !!!"; return; } ProblemOfCustomer problemOfCustomer = new ProblemOfCustomer(); problemOfCustomer.Company_Id = new Guid(ddlCompany.SelectedValue); problemOfCustomer.Customer_Id = new Guid(ddlCustomer.SelectedValue); if (string.IsNullOrEmpty(txtDate.Text)) { problemOfCustomer.ProblemOfCustomer_Date = DateTime.Now; } else { problemOfCustomer.ProblemOfCustomer_Date = DateTime.Parse(txtDate.Text); } problemOfCustomer.Problem_Id = entity.Problem_Id; if (!problemOfCustomerBll.ProblemOfCustomer_Insert(problemOfCustomer)) { pnlRed.Visible = true; lblError.Text = "Do not success !!!"; return; } if (customerOfCompanyBll.CustomerOfCompany_Check(problemOfCustomer.Company_Id.ToString(), problemOfCustomer.Customer_Id.ToString())) { pnlRed.Visible = false; pnlGreen.Visible = true; lblSuccess.Text = "Create successfully!"; BindDataDropDownList(); } CustomerOfCompany customerOfCompany = new CustomerOfCompany(); customerOfCompany.Customer_Id = problemOfCustomer.Customer_Id; customerOfCompany.Company_Id = problemOfCustomer.Company_Id; if (customerOfCompanyBll.CustomerOfCompany_Check(customerOfCompany.Company_Id.ToString(), customerOfCompany.Customer_Id.ToString())) { pnlRed.Visible = true; lblError.Text = "Do not Insert CustomerOfCompany"; return; } customerOfCompanyBll.CustomerOfCompany_Insert(customerOfCompany); pnlRed.Visible = false; pnlGreen.Visible = true; lblSuccess.Text = "Create successfully!"; ResetForm(); BindDataDropDownList(); }
/// <summary> /// Insert a row /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool CustomerOfCompany_Insert(CustomerOfCompany entity) { return customer.CustomerOfCompany_Insert(entity) > 0; }