/// <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));
}
