/// <summary> /// Insert receive place new of transport company /// </summary> /// <param name="company"></param> public static void InsertReceivePlace(tbl_TransportCompany company) { using (var connect = new inventorymanagementEntities()) { tbl_TransportCompany companyNew = new tbl_TransportCompany(); companyNew.ID = company.ID; companyNew.SubID = GetSubIDNew(company.ID); companyNew.CompanyName = company.CompanyName; companyNew.CompanyPhone = company.CompanyPhone; companyNew.CompanyAddress = company.CompanyAddress; companyNew.ShipTo = company.ShipTo; companyNew.Address = company.Address; companyNew.Prepay = company.Prepay; companyNew.COD = company.COD; companyNew.Note = company.Note; companyNew.CreatedDate = DateTime.Now; companyNew.CreatedBy = company.CreatedBy; companyNew.ModifiedDate = null; companyNew.ModifiedBy = null; connect.tbl_TransportCompany.Add(companyNew); connect.SaveChanges(); } }
/// <summary> /// update info of transport company /// </summary> /// <param name="company"></param> public static int UpdateTransportCompany(tbl_TransportCompany company) { using (var connect = new inventorymanagementEntities()) { tbl_TransportCompany target = connect.tbl_TransportCompany .Where(x => x.ID == company.ID && x.SubID == 0) .SingleOrDefault(); if (target != null) { target.CompanyName = company.CompanyName; target.CompanyPhone = company.CompanyPhone; target.CompanyAddress = company.CompanyAddress; target.Note = company.Note; target.Prepay = company.Prepay; target.COD = company.COD; target.ModifiedDate = DateTime.Now; target.ModifiedBy = company.ModifiedBy; target.Status = target.Status; connect.SaveChanges(); } } return(company.ID); }
protected void btnAdd_Click(object sender, EventArgs e) { string username = Request.Cookies["userLoginSystem"].Value; tbl_TransportCompany transportCompanyNew = new tbl_TransportCompany(); transportCompanyNew.CompanyName = this.txtCompanyName.Text; transportCompanyNew.CompanyPhone = this.txtCompanyPhone.Text; transportCompanyNew.CompanyAddress = this.txtCompanyAddress.Text; transportCompanyNew.Prepay = Convert.ToBoolean(this.rdbPrepay.SelectedValue); transportCompanyNew.COD = Convert.ToBoolean(this.rdbCOD.SelectedValue); transportCompanyNew.Note = this.pNote.Text; transportCompanyNew.CreatedBy = username; int ID = TransportCompanyController.InsertTransportCompany(transportCompanyNew); Response.Redirect(String.Format("/chi-tiet-nha-xe?id={0}", ID)); }
protected void btnUpdate_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; tbl_TransportCompany transportCompany = new tbl_TransportCompany(); transportCompany.ID = Convert.ToInt32(this.hdfID.Value); transportCompany.CompanyName = this.txtCompanyName.Text; transportCompany.CompanyPhone = this.txtCompanyPhone.Text; transportCompany.CompanyAddress = this.txtCompanyAddress.Text; transportCompany.Prepay = Convert.ToBoolean(this.rdbPrepay.SelectedValue); transportCompany.COD = Convert.ToBoolean(this.rdbCOD.SelectedValue); transportCompany.Note = this.pNote.Text; transportCompany.ModifiedBy = username; int ID = TransportCompanyController.UpdateTransportCompany(transportCompany); Response.Redirect(String.Format("/chi-tiet-nha-xe?id={0}", this.hdfID.Value)); }
public static string UpdateStatus(int ID, int SubID) { using (var connect = new inventorymanagementEntities()) { tbl_TransportCompany target = connect.tbl_TransportCompany .Where(x => x.ID == ID && x.SubID == SubID) .SingleOrDefault(); if (target != null) { target.Status = target.Status == 1 ? 0 : 1; target.ModifiedDate = DateTime.Now; connect.SaveChanges(); return("true"); } } return("false"); }
protected void btnUpdate_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; tbl_TransportCompany receivePlaceUpdate = new tbl_TransportCompany(); receivePlaceUpdate.ID = Convert.ToInt32(this.hdfID.Value); receivePlaceUpdate.SubID = Convert.ToInt32(this.hdfSubID.Value); receivePlaceUpdate.ShipTo = this.txtShipTo.Text; receivePlaceUpdate.Address = this.txtAddress.Text; receivePlaceUpdate.Prepay = Convert.ToBoolean(this.rdbPrepay.SelectedValue); receivePlaceUpdate.COD = Convert.ToBoolean(this.rdbCOD.SelectedValue); receivePlaceUpdate.Note = this.pNote.Text; receivePlaceUpdate.ModifiedBy = username; TransportCompanyController.UpdateReceivePlace(receivePlaceUpdate); Response.Redirect(String.Format("/chi-tiet-nha-xe/?id={0}", this.hdfID.Value)); }
public static List <tbl_TransportCompany> Filter(string TextSearch) { var list = new List <tbl_TransportCompany>(); var sql = new StringBuilder(); sql.AppendLine(String.Format("SELECT * ")); sql.AppendLine(String.Format("FROM tbl_TransportCompany")); sql.AppendLine(String.Format("WHERE SubID = 0")); if (TextSearch != "") { sql.AppendLine(String.Format(" AND ( (CompanyName LIKE N'%{0}%') OR (CompanyAddress LIKE N'%{0}%') OR (ShipTo LIKE N'%{0}%') OR (Address LIKE N'%{0}%') OR (CompanyPhone = '{0}') )", TextSearch)); } sql.AppendLine(String.Format("ORDER BY CompanyName")); var reader = (IDataReader)SqlHelper.ExecuteDataReader(sql.ToString()); while (reader.Read()) { var entity = new tbl_TransportCompany(); entity.ID = Convert.ToInt32(reader["ID"]); entity.SubID = Convert.ToInt32(reader["ID"]); entity.CompanyName = reader["CompanyName"].ToString(); entity.CompanyPhone = reader["CompanyPhone"].ToString(); entity.CompanyAddress = reader["CompanyAddress"].ToString(); entity.ShipTo = reader["ShipTo"].ToString(); entity.Address = reader["Address"].ToString(); entity.Prepay = Convert.ToBoolean(reader["Prepay"]); entity.COD = Convert.ToBoolean(reader["COD"]); entity.Note = reader["Note"].ToString(); entity.CreatedBy = reader["CreatedBy"].ToString(); entity.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); list.Add(entity); } reader.Close(); return(list); }
/// <summary> /// update receive place of transport company /// </summary> /// <param name="company"></param> public static void UpdateReceivePlace(tbl_TransportCompany company) { using (var connect = new inventorymanagementEntities()) { tbl_TransportCompany target = connect.tbl_TransportCompany .Where(x => x.ID == company.ID && x.SubID == company.SubID) .SingleOrDefault(); if (target != null) { target.ShipTo = company.ShipTo; target.Address = company.Address; target.Prepay = company.Prepay; target.COD = company.COD; target.Note = company.Note; target.ModifiedDate = DateTime.Now; target.ModifiedBy = company.ModifiedBy; connect.SaveChanges(); } } }
protected void btnAdd_Click(object sender, EventArgs e) { string username = Request.Cookies["usernameLoginSystem"].Value; tbl_TransportCompany receivePlaceNew = new tbl_TransportCompany(); receivePlaceNew.ID = Convert.ToInt32(this.hdfID.Value); receivePlaceNew.CompanyName = this.txtCompanyName.Text; receivePlaceNew.CompanyPhone = this.txtCompanyPhone.Text; receivePlaceNew.CompanyAddress = this.txtCompanyAddress.Text; receivePlaceNew.ShipTo = this.txtShipTo.Text; receivePlaceNew.Address = this.txtAddress.Text; receivePlaceNew.Prepay = Convert.ToBoolean(this.rdbPrepay.SelectedValue); receivePlaceNew.COD = Convert.ToBoolean(this.rdbCOD.SelectedValue); receivePlaceNew.Note = this.pNote.Text; receivePlaceNew.Status = 1; receivePlaceNew.CreatedBy = username; TransportCompanyController.InsertReceivePlace(receivePlaceNew); Response.Redirect(String.Format("/chi-tiet-nha-xe/?id={0}", this.hdfID.Value)); }