public static ResultEN Insert_Equip(EquiptmentEN en)
{
// SqlCommand sqlCmd = new SqlCommand();
// sqlCmd.CommandText = "insert into " + tb_name_type +" ()";
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("CreatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now));
ResultEN res = new ResultEN();
res = ClassMain.Insert(tb_name_master, fields);
return(res);
}
public static ResultEN Insert_Equipment_SET(ref Equipment_SET en)
{
ResultEN res = new ResultEN();
// int? _Id = GetID("Equipment_SET", "SET_ID");
List <ClassFieldValue> fields = new List <ClassFieldValue>();
//en.SET_ID = _Id.Value;
fields = SetField_SET(fields, en);
res = ClassMain.Insert("Equipment_SET", fields, "SET_ID");
return(res);
}
public static ResultEN InsertPosition_Emp(JobPosition_EmpEN en)
{
ResultEN res = new ResultEN();
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("Emp_id", en.empid));
fields.Add(new ClassFieldValue("Pos_id", en.posid));
fields.Add(new ClassFieldValue("cost", en.cost));
fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now));
fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name));
res = ClassMain.Insert(tb_name_jopEmp, fields);
return(res);
}
public static ResultEN Insert(CustomerEN en)
{
ResultEN res = new ResultEN();
// Gen Employee code
string C_ID = GetC_ID();
List <ClassFieldValue> fields = new List <ClassFieldValue>();
en.C_ID = C_ID;
//fields.Add(new ClassFieldValue("C_ID", C_ID));
fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now));
SetField(fields, en);
res = ClassMain.Insert(tb_name, fields);
return(res);
}
public static ResultEN Insert_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("CreatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now));
ResultEN res = new ResultEN();
// ClassMain cls = new ClassMain();
res = ClassMain.Insert(tb_name_type, fields);
return(res);
}
public static ResultEN Insert(EmployeeEN en)
{
ResultEN res = new ResultEN();
// Gen Employee code
System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US");
string code = "E" + DateTime.Now.Date.Year.ToString(cultureinfo);
string runno = GetRunno();
code += runno;
List <ClassFieldValue> fields = new List <ClassFieldValue>();
fields.Add(new ClassFieldValue("Emp_id", code));
fields.Add(new ClassFieldValue("CreatedBy", HttpContext.Current.User.Identity.Name));
fields.Add(new ClassFieldValue("CreatedDate", DateTime.Now));
SetField(fields, en);
res = ClassMain.Insert(tb_name, fields);
return(res);
}
