public static int Create(DTO.FIC_ShippingVolumeHeader item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderNo_", item.SVHeaderNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderDate", item.SVHeaderDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceNo_", item.InvoiceNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceSerialNo_", item.InvoiceSerialNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceFormNo_", item.InvoiceFormNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceDate", item.InvoiceDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@FromPartnerNo_", item.FromPartnerNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ToPartnerNo_", item.ToPartnerNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status)); result = conn.ExecuteNonQuery("sp_FIC_ShippingVolumeHeader_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.MAD_Transportation item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationName", item.TransportationName.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@RoMooc", item.RoMooc.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status)); result = conn.ExecuteNonQuery("sp_MAD_Transportation_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.SAM_DriverShipment item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentNo_", item.ShipmentNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", item.UserNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@IsDriver", item.IsDriver)); result = conn.ExecuteNonQuery("sp_SAM_DriverShipment_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Delete(int shipmentNo_, string transportationNo_, string userNo_) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentNo_", shipmentNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", transportationNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", userNo_)); result = conn.ExecuteNonQuery("sp_SAM_DriverShipment_Delete", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.SAM_Contract item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@CreatedUser", item.CreatedUser.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@CreatedDate", item.CreatedDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@PartnerNo_", item.PartnerNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractValue", item.ContractValue)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status)); result = conn.ExecuteNonQuery("sp_SAM_Contract_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.MAD_Employee item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeNo_", item.EmployeeNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeName", item.EmployeeName)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeType", item.EmployeeType)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@IdentityCard", item.IdentityCard)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Cellphone", item.Cellphone)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@BeginDate", item.BeginDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status)); result = conn.ExecuteNonQuery("sp_MAD_Employee_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.SYS_User item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", item.UserNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeNo_", item.EmployeeNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Password", item.Password.Trim())); result = conn.ExecuteNonQuery("sp_SYS_User_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.SAM_SalesPrice item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ID", item.ID)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", item.ContractNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@RouteNo_", item.RouteNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ItemNo_", item.ItemNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitOfMeasure", item.UnitOfMeasure.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@FromDate", item.FromDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ToDate", item.ToDate)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitPrice", item.UnitPrice)); result = conn.ExecuteNonQuery("sp_SAM_SalesPrice_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.FIC_ShippingVolumeLine item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@LineNo_", item.LineNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderNo_", item.SVHeaderNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Date", item.Date)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@RouteNo_", item.RouteNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ItemNo_", item.ItemNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitOfMeasureNo_", item.UnitOfMeasureNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Quantity", item.Quantity)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitPrice", item.UnitPrice)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Description", item.Description.Trim())); result = conn.ExecuteNonQuery("sp_FIC_ShippingVolumeLine_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.FIC_Inc_Exp_Document item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Inc_Exp_DocumentNo_", item.Inc_Exp_DocumentNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ReferenceNo_", item.ReferenceNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Inc_Exp_FormNo_", item.Inc_Exp_FormNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Inc_Exp_Value", item.Inc_Exp_Value)); result = conn.ExecuteNonQuery("sp_FIC_Inc_Exp_Document_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Delete(string id) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", id)); result = conn.ExecuteNonQuery("sp_MAD_Transportation_Delete", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Delete(string menuNo_) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@MenuNo_", menuNo_)); result = conn.ExecuteNonQuery("sp_SYS_Role_Delete_By_Employee", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(DTO.SAM_Shipment item) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentNo_", item.ShipmentNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@OrderNo_", item.OrderNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", item.TransportationNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentTypeNo_", item.ShipmentTypeNo_)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentPriority", item.ShipmentPriority)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@ItemNo_", item.ItemNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitOfMeasure", item.UnitOfMeasure.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@KmFrom", item.KmFrom)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@KmTo", item.KmTo)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Quantity", item.Quantity)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitPrice", item.UnitPrice)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@KgActual", item.KgActual)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@KgPartner", item.KgPartner)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Payment", item.Payment)); lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", item.Status)); result = conn.ExecuteNonQuery("sp_SAM_Shipment_Create", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }
public static int Create(string transportationNo_, string employeeNo_) { int result = 0; DataProvider.ConnectionVanTai conn = null; try { conn = new DataProvider.ConnectionVanTai(); conn.Open(); List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>(); lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", transportationNo_.Trim())); lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeNo_", employeeNo_.Trim())); result = conn.ExecuteNonQuery("sp_MAD_Driver_Create_By_Employee", lsInput); } catch (Exception ex) { result = -1; } finally { conn.Close(); } return result; }