public static ResultEN Update_Equip(EquiptmentEN en)
{
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("Name", en.Name));
fields.Add(new ClassFieldValue("Fullname", en.Fullname));
fields.Add(new ClassFieldValue("Equip_type_id", en.Equip_type_id));
fields.Add(new ClassFieldValue("Number", en.EquipNo));
fields.Add(new ClassFieldValue("SN", en.SN));
fields.Add(new ClassFieldValue("SupplierName", en.SupplierName));
fields.Add(new ClassFieldValue("ReceiptTax", en.ReceiptTax));
fields.Add(new ClassFieldValue("BuyDate", en.BuyDate));
fields.Add(new ClassFieldValue("CostBuy", en.CostBuy));
fields.Add(new ClassFieldValue("CostRent", en.CostRent));
fields.Add(new ClassFieldValue("ExpireDate", en.ExpireDate));
fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now));
ResultEN res = new ResultEN();
List <ClassFieldValue> fieldWhere = new List <ClassFieldValue>();
fieldWhere.Add(new ClassFieldValue("ID", en.ID));
res = ClassMain.Update(tb_name_master, fields, fieldWhere);
return(res);
}
public static ResultEN Update(CustomerEN en)
{
ResultEN res = new ResultEN();
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now));
SetField(fields, en);
List <ClassFieldValue> fieldscon = new List <ClassFieldValue>();
fieldscon.Add(new ClassFieldValue("C_ID", en.C_ID));
res = ClassMain.Update(tb_name, fields, fieldscon);
return(res);
}
public static ResultEN UpdatePosition_Emp(JobPosition_EmpEN en)
{
ResultEN res = new ResultEN();
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("cost", en.cost));
fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now));
fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name));
List <ClassFieldValue> fieldscon = new List <ClassFieldValue>();
fieldscon.Add(new ClassFieldValue("Emp_id", en.empid));
fieldscon.Add(new ClassFieldValue("Pos_id", en.posid));
res = ClassMain.Update(tb_name_jopEmp, fields, fieldscon);
return(res);
}
public static ResultEN Update_Type(EquipmentTypeEN en)
{
// SqlCommand sqlCmd = new SqlCommand();
// sqlCmd.CommandText = "insert into " + tb_name_type +" ()";
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("TypeName", en.TypeName));
fields.Add(new ClassFieldValue("ParentID", en.ParentID));
fields.Add(new ClassFieldValue("UpdatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("UpdatedDate", DateTime.Now));
ResultEN res = new ResultEN();
// ClassMain cls = new ClassMain();
List <ClassFieldValue> fieldWhere = new List <ClassFieldValue>();
fieldWhere.Add(new ClassFieldValue("ID", en.ID));
res = ClassMain.Update(tb_name_type, fields, fieldWhere);
return(res);
}
