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