/// <summary>
/// Saves a record to the u_UserRoles table.
/// </summary>
public Boolean Saveu_UserRoleSP(u_UserRolex u_UserRole, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "U_UserRoleSave";
scom.Parameters.Add("@roleId", SqlDbType.VarChar, 10).Value = u_UserRole.roleId;
scom.Parameters.Add("@description", SqlDbType.VarChar, 50).Value = u_UserRole.description;
scom.Parameters.Add("@userCreated", SqlDbType.VarChar, 10).Value = u_UserRole.userCreated;
scom.Parameters.Add("@dateCreated", SqlDbType.DateTime, 8).Value = u_UserRole.dateCreated;
scom.Parameters.Add("@userModified", SqlDbType.VarChar, 10).Value = u_UserRole.userModified;
scom.Parameters.Add("@dateModified", SqlDbType.DateTime, 8).Value = u_UserRole.dateModified;
scom.Parameters.Add("@activate", SqlDbType.Int, 4).Value = u_UserRole.activate;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_PayModeDetails table.
/// </summary>
public Boolean Savem_PayModeDetailSP(M_PayModeDetails m_PayModeDetail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_PayModeDetailsSave";
scom.Parameters.Add("@pay_modeId", SqlDbType.VarChar, 10).Value = m_PayModeDetail.pay_modeId;
scom.Parameters.Add("@sub_payModeCode", SqlDbType.VarChar, 20).Value = m_PayModeDetail.sub_payModeCode;
scom.Parameters.Add("@sub_payDes", SqlDbType.VarChar, 30).Value = m_PayModeDetail.sub_payDes;
scom.Parameters.Add("@format", SqlDbType.Int, 4).Value = m_PayModeDetail.format;
scom.Parameters.Add("@exchangeRate", SqlDbType.Decimal, 9).Value = m_PayModeDetail.exchangeRate;
scom.Parameters.Add("@accountCode", SqlDbType.VarChar, 15).Value = m_PayModeDetail.accountCode;
scom.Parameters.Add("@CommissionAccCode", SqlDbType.VarChar, 15).Value = m_PayModeDetail.CommissionAccCode;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_PayModeDetail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_Settlement table.
/// </summary>
public Boolean Savet_SettlementSP(T_Settlement t_Settlement, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_SettlementSave";
scom.Parameters.Add("@Reciptno", SqlDbType.VarChar, 20).Value = t_Settlement.Reciptno;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_Settlement.InvNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_Settlement.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_Settlement.LocaCode;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_Settlement.Customer;
scom.Parameters.Add("@InvAmt", SqlDbType.Decimal, 9).Value = t_Settlement.InvAmt;
scom.Parameters.Add("@PaidAmt", SqlDbType.Decimal, 9).Value = t_Settlement.PaidAmt;
scom.Parameters.Add("@DueAmt", SqlDbType.Decimal, 9).Value = t_Settlement.DueAmt;
scom.Parameters.Add("@Settlement", SqlDbType.Decimal, 9).Value = t_Settlement.Settlement;
scom.Parameters.Add("@Iscancelled", SqlDbType.Bit, 1).Value = t_Settlement.Iscancelled;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_adjustment_details table.
/// </summary>
public Boolean Savet_adjustment_detailSP(t_adjustment_details t_adjustment_detail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_adjustment_detailsSave";
scom.Parameters.Add("@adju_no", SqlDbType.VarChar, 20).Value = t_adjustment_detail.adju_no;
scom.Parameters.Add("@location_id", SqlDbType.VarChar, 20).Value = t_adjustment_detail.location_id;
scom.Parameters.Add("@line_no", SqlDbType.Int, 4).Value = t_adjustment_detail.line_no;
scom.Parameters.Add("@item_code", SqlDbType.VarChar, 20).Value = t_adjustment_detail.item_code;
scom.Parameters.Add("@cost", SqlDbType.Decimal, 9).Value = t_adjustment_detail.cost;
scom.Parameters.Add("@stock", SqlDbType.Decimal, 9).Value = t_adjustment_detail.stock;
scom.Parameters.Add("@physical_quantity", SqlDbType.Decimal, 9).Value = t_adjustment_detail.physical_quantity;
scom.Parameters.Add("@variance", SqlDbType.Decimal, 9).Value = t_adjustment_detail.variance;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_adjustment_detail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_Territory table.
/// </summary>
public Boolean SaveM_TerritorySP(M_Territory m_Territory, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_TerritorySave";
scom.Parameters.Add("@TerritoryCode", SqlDbType.VarChar, 20).Value = m_Territory.TerritoryCode;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_Territory.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Territory.Locacode;
scom.Parameters.Add("@AreaCode", SqlDbType.VarChar, 20).Value = m_Territory.AreaCode;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 50).Value = m_Territory.Descr;
scom.Parameters.Add("@UserNamex", SqlDbType.VarChar, 20).Value = m_Territory.UserNamex;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Territory.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_CustomerCategory table.
/// </summary>
public Boolean Savem_CustomerCategorySP(M_CustomerCategory m_CustomerCategory, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_CustomerCategorySave";
scom.Parameters.Add("@CusCateID", SqlDbType.VarChar, 20).Value = m_CustomerCategory.CusCateID;
scom.Parameters.Add("@Description", SqlDbType.VarChar, 120).Value = m_CustomerCategory.Description;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_CustomerCategory.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_CustomerCategory.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_DIliveryAudit table.
/// </summary>
public Boolean Savet_DIliveryAuditSP(T_DIliveryAudit t_DIliveryAudit, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_DIliveryAuditSave";
scom.Parameters.Add("@Dono", SqlDbType.VarChar, 20).Value = t_DIliveryAudit.Dono;
scom.Parameters.Add("@Item", SqlDbType.VarChar, 20).Value = t_DIliveryAudit.Item;
scom.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = t_DIliveryAudit.Name;
scom.Parameters.Add("@DoQty", SqlDbType.Decimal, 9).Value = t_DIliveryAudit.DoQty;
scom.Parameters.Add("@ActualQTY", SqlDbType.Decimal, 9).Value = t_DIliveryAudit.ActualQTY;
scom.Parameters.Add("@Variance", SqlDbType.Decimal, 9).Value = t_DIliveryAudit.Variance;
scom.Parameters.Add("@Pass", SqlDbType.Int, 4).Value = t_DIliveryAudit.Pass;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_InvoiceDet table.
/// </summary>
public Boolean Savet_InvoiceDetSP(T_InvoiceDet t_InvoiceDet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_InvoiceDetSave";
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_InvoiceDet.InvNo;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_InvoiceDet.ItemCode;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_InvoiceDet.CostPrice;
scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_InvoiceDet.SellingPrice;
scom.Parameters.Add("@Qty", SqlDbType.Decimal, 9).Value = t_InvoiceDet.Qty;
scom.Parameters.Add("@Unitx", SqlDbType.VarChar, 10).Value = t_InvoiceDet.Unitx;
scom.Parameters.Add("@DiscountPer", SqlDbType.Decimal, 9).Value = t_InvoiceDet.DiscountPer;
scom.Parameters.Add("@Discount", SqlDbType.Decimal, 9).Value = t_InvoiceDet.Discount;
scom.Parameters.Add("@Total", SqlDbType.Decimal, 9).Value = t_InvoiceDet.Total;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_Alloc table.
/// </summary>
public Boolean Savet_AllocSP(T_Alloc t_Alloc, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_AllocSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_Alloc.DocNo;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_Alloc.locationId;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_Alloc.Datex;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_Alloc.Customer;
scom.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = t_Alloc.Type;
scom.Parameters.Add("@RefNo", SqlDbType.VarChar, 20).Value = t_Alloc.RefNo;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_Alloc.InvNo;
scom.Parameters.Add("@NetAmt", SqlDbType.Decimal, 9).Value = t_Alloc.NetAmt;
scom.Parameters.Add("@PaidAmt", SqlDbType.Decimal, 9).Value = t_Alloc.PaidAmt;
scom.Parameters.Add("@Dueamt", SqlDbType.Decimal, 9).Value = t_Alloc.Dueamt;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_adjustment_head table.
/// </summary>
public Boolean Savet_adjustment_headSP(t_adjustment_head t_adjustment_head, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_adjustment_headSave";
scom.Parameters.Add("@adju_no", SqlDbType.VarChar, 20).Value = t_adjustment_head.adju_no;
scom.Parameters.Add("@location_id", SqlDbType.VarChar, 20).Value = t_adjustment_head.location_id;
scom.Parameters.Add("@adjsment_date", SqlDbType.DateTime, 8).Value = t_adjustment_head.adjsment_date;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 150).Value = t_adjustment_head.remarks;
scom.Parameters.Add("@user_id", SqlDbType.VarChar, 20).Value = t_adjustment_head.user_id;
scom.Parameters.Add("@batch_no", SqlDbType.VarChar, 20).Value = t_adjustment_head.batch_no;
scom.Parameters.Add("@process", SqlDbType.Bit, 1).Value = t_adjustment_head.process;
scom.Parameters.Add("@process_user", SqlDbType.VarChar, 20).Value = t_adjustment_head.process_user;
scom.Parameters.Add("@process_date", SqlDbType.DateTime, 8).Value = t_adjustment_head.process_date;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_adjustment_head.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_transferIn_detail table.
/// </summary>
public Boolean Savet_transferIn_detailSP(t_transferIn_detail t_transferIn_detail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_transferIn_detailSave";
scom.Parameters.Add("@transinrNo", SqlDbType.VarChar, 20).Value = t_transferIn_detail.transinrNo;
scom.Parameters.Add("@sourceLocId", SqlDbType.VarChar, 20).Value = t_transferIn_detail.sourceLocId;
scom.Parameters.Add("@destinationLocId", SqlDbType.VarChar, 20).Value = t_transferIn_detail.destinationLocId;
scom.Parameters.Add("@transferDate", SqlDbType.DateTime, 8).Value = t_transferIn_detail.transferDate;
scom.Parameters.Add("@stockCode", SqlDbType.VarChar, 20).Value = t_transferIn_detail.stockCode;
scom.Parameters.Add("@description", SqlDbType.VarChar, 150).Value = t_transferIn_detail.description;
scom.Parameters.Add("@quantity", SqlDbType.Decimal, 9).Value = t_transferIn_detail.quantity;
scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_transferIn_detail.costPrice;
scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_transferIn_detail.amount;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_transferIn_detail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_packingdet table.
/// </summary>
public Boolean Savet_packingdetSP(T_packingdet t_packingdet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_packingdetSave";
scom.Parameters.Add("@PackingNo", SqlDbType.VarChar, 20).Value = t_packingdet.PackingNo;
scom.Parameters.Add("@Dono", SqlDbType.VarChar, 20).Value = t_packingdet.Dono;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_packingdet.Customer;
scom.Parameters.Add("@Agent", SqlDbType.VarChar, 20).Value = t_packingdet.Agent;
scom.Parameters.Add("@datex", SqlDbType.DateTime, 8).Value = t_packingdet.datex;
scom.Parameters.Add("@TTLCartons", SqlDbType.Decimal, 9).Value = t_packingdet.TTLCartons;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_invoice_payment table.
/// </summary>
public Boolean Savet_invoice_paymentSP(t_invoice_payment t_invoice_payment, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_invoice_paymentSave";
scom.Parameters.Add("@invNo", SqlDbType.VarChar, 10).Value = t_invoice_payment.invNo;
scom.Parameters.Add("@location", SqlDbType.VarChar, 3).Value = t_invoice_payment.location;
scom.Parameters.Add("@teminalId", SqlDbType.VarChar, 3).Value = t_invoice_payment.teminalId;
scom.Parameters.Add("@paymodeId", SqlDbType.VarChar, 10).Value = t_invoice_payment.paymodeId;
scom.Parameters.Add("@subPayMode", SqlDbType.VarChar, 20).Value = t_invoice_payment.subPayMode;
scom.Parameters.Add("@rate", SqlDbType.Decimal, 9).Value = t_invoice_payment.rate;
scom.Parameters.Add("@number", SqlDbType.VarChar, 50).Value = t_invoice_payment.number;
scom.Parameters.Add("@subPayAmount", SqlDbType.Decimal, 9).Value = t_invoice_payment.subPayAmount;
scom.Parameters.Add("@datex", SqlDbType.DateTime, 8).Value = t_invoice_payment.datex;
scom.Parameters.Add("@voucherNumber", SqlDbType.VarChar, 50).Value = t_invoice_payment.voucherNumber;
scom.Parameters.Add("@totalAmount", SqlDbType.Decimal, 9).Value = t_invoice_payment.totalAmount;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_invoice_payment.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the P_AutoNumber table.
/// </summary>
public Boolean SaveP_AutoNumberSP(P_AutoNumber p_AutoNumber, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "P_AutoNumberSave";
scom.Parameters.Add("@Screen", SqlDbType.VarChar, 50).Value = p_AutoNumber.Screen;
scom.Parameters.Add("@ID", SqlDbType.VarChar, 50).Value = p_AutoNumber.ID;
scom.Parameters.Add("@Serial", SqlDbType.Int, 4).Value = p_AutoNumber.Serial;
scom.Parameters.Add("@Mode", SqlDbType.Int, 4).Value = p_AutoNumber.Mode;
scom.Parameters.Add("@Prefix", SqlDbType.VarChar, 5).Value = p_AutoNumber.Prefix;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_BankBranch table.
/// </summary>
public Boolean Savem_BankBranchSP(M_BankBranch m_BankBranch, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_BankBranchSave";
scom.Parameters.Add("@BBRANCH_BANK", SqlDbType.VarChar, 10).Value = m_BankBranch.BBRANCH_BANK;
scom.Parameters.Add("@BBRANCH_CODE", SqlDbType.VarChar, 4).Value = m_BankBranch.BBRANCH_CODE;
scom.Parameters.Add("@BBRANCH_NAME", SqlDbType.VarChar, 50).Value = m_BankBranch.BBRANCH_NAME;
scom.Parameters.Add("@BBRANCH_CTIME", SqlDbType.Decimal, 5).Value = m_BankBranch.BBRANCH_CTIME;
scom.Parameters.Add("@BBRANCH_DTRANSFER", SqlDbType.Decimal, 5).Value = m_BankBranch.BBRANCH_DTRANSFER;
scom.Parameters.Add("@BBRANCH_EXBATCH", SqlDbType.VarChar, 7).Value = m_BankBranch.BBRANCH_EXBATCH;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_Product_Has_Parts table.
/// </summary>
public Boolean Savem_Product_Has_PartSP(M_Product_Has_Parts m_Product_Has_Part, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_Product_Has_PartsSave";
scom.Parameters.Add("@productId", SqlDbType.VarChar, 10).Value = m_Product_Has_Part.productId;
scom.Parameters.Add("@PartId", SqlDbType.VarChar, 10).Value = m_Product_Has_Part.PartId;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_Product_Has_Part.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_CNParts table.
/// </summary>
public Boolean Savet_CNPartSP(T_CNParts t_CNPart, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CNPartsSave";
scom.Parameters.Add("@CNno", SqlDbType.VarChar, 20).Value = t_CNPart.CNno;
scom.Parameters.Add("@TagNumber", SqlDbType.VarChar, 20).Value = t_CNPart.TagNumber;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_CNPart.ItemCode;
scom.Parameters.Add("@PartCode", SqlDbType.VarChar, 20).Value = t_CNPart.PartCode;
scom.Parameters.Add("@QTY", SqlDbType.Decimal, 9).Value = t_CNPart.QTY;
scom.Parameters.Add("@Saved", SqlDbType.Bit, 1).Value = t_CNPart.Saved;
scom.Parameters.Add("@Processed", SqlDbType.Bit, 1).Value = t_CNPart.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_CNPart.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_CNPart.ProcessedUser;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public Boolean SaveBankSP(M_Bank oBank, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "Bank_Save";
scom.Parameters.Add("@BANK_CODE", SqlDbType.VarChar, 10).Value = oBank.BANK_CODE;
scom.Parameters.Add("@BANK_NAME", SqlDbType.VarChar, 50).Value = oBank.BANK_NAME;
scom.Parameters.Add("@BANK_DTRANSFER", SqlDbType.Int).Value = 0;
scom.Parameters.Add("@BANK_EXBATCH", SqlDbType.Int).Value = 0;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_SubCategory table.
/// </summary>
public Boolean Savem_SubCategorySP(M_SubCategory m_SubCategory, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_SubCategorySave";
scom.Parameters.Add("@Codex", SqlDbType.VarChar, 20).Value = m_SubCategory.Codex;
scom.Parameters.Add("@CategoryID", SqlDbType.VarChar, 20).Value = m_SubCategory.CategoryID;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 50).Value = m_SubCategory.Descr;
scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = m_SubCategory.date;
scom.Parameters.Add("@type", SqlDbType.VarChar, 20).Value = m_SubCategory.type;
scom.Parameters.Add("@Lockedby", SqlDbType.VarChar, 20).Value = m_SubCategory.Lockedby;
scom.Parameters.Add("@Locked", SqlDbType.Bit, 1).Value = m_SubCategory.Locked;
scom.Parameters.Add("@Userx", SqlDbType.NChar, 10).Value = m_SubCategory.Userx;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_ProductPriceChange table.
/// </summary>
public Boolean SaveM_ProductPriceChangeSP(M_ProductPriceChange m_ProductPriceChange, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_ProductPriceChangeSave";
scom.Parameters.Add("@Id", SqlDbType.VarChar, 20).Value = m_ProductPriceChange.Id;
scom.Parameters.Add("@Product", SqlDbType.VarChar, 20).Value = m_ProductPriceChange.Product;
scom.Parameters.Add("@ChangedPlace", SqlDbType.VarChar, 30).Value = m_ProductPriceChange.ChangedPlace;
scom.Parameters.Add("@Currentcost", SqlDbType.Decimal, 9).Value = m_ProductPriceChange.Currentcost;
scom.Parameters.Add("@NewCost", SqlDbType.Decimal, 9).Value = m_ProductPriceChange.NewCost;
scom.Parameters.Add("@CurrentSelling", SqlDbType.Decimal, 9).Value = m_ProductPriceChange.CurrentSelling;
scom.Parameters.Add("@NewSelling", SqlDbType.Decimal, 9).Value = m_ProductPriceChange.NewSelling;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_ProductPriceChange.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_ProductPriceChange.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_return_detail table.
/// </summary>
public Boolean Savet_return_detailSP(t_return_detail t_return_detail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_return_detailSave";
scom.Parameters.Add("@returnNo", SqlDbType.VarChar, 20).Value = t_return_detail.returnNo;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_return_detail.locationId;
scom.Parameters.Add("@stockCode", SqlDbType.VarChar, 20).Value = t_return_detail.stockCode;
scom.Parameters.Add("@productId", SqlDbType.VarChar, 20).Value = t_return_detail.productId;
scom.Parameters.Add("@quantity", SqlDbType.Decimal, 9).Value = t_return_detail.quantity;
scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_return_detail.amount;
scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_return_detail.costPrice;
scom.Parameters.Add("@sellingPrice", SqlDbType.Decimal, 9).Value = t_return_detail.sellingPrice;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_return_detail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the t_purchaseReq_detail table.
/// </summary>
public Boolean SaveT_purchaseReq_detailSP(t_purchaseReq_detail t_purchaseReq_detail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_purchaseReq_detailSave";
scom.Parameters.Add("@purchaseReqNo", SqlDbType.VarChar, 20).Value = t_purchaseReq_detail.purchaseReqNo;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_purchaseReq_detail.locationId;
scom.Parameters.Add("@ReqDate", SqlDbType.DateTime, 8).Value = t_purchaseReq_detail.ReqDate;
scom.Parameters.Add("@deleveryDate", SqlDbType.DateTime, 8).Value = t_purchaseReq_detail.deleveryDate;
scom.Parameters.Add("@productId", SqlDbType.VarChar, 20).Value = t_purchaseReq_detail.productId;
scom.Parameters.Add("@description", SqlDbType.VarChar, 150).Value = t_purchaseReq_detail.description;
scom.Parameters.Add("@quantity", SqlDbType.Decimal, 9).Value = t_purchaseReq_detail.quantity;
scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_purchaseReq_detail.costPrice;
scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_purchaseReq_detail.amount;
scom.Parameters.Add("@release", SqlDbType.Int, 4).Value = t_purchaseReq_detail.release;
scom.Parameters.Add("@r_value", SqlDbType.Int, 4).Value = t_purchaseReq_detail.r_value;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_purchaseReq_detail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_SalesAllocHead table.
/// </summary>
public Boolean Savet_SalesAllocHeadSP(T_SalesAllocHead t_SalesAllocHead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_SalesAllocHeadSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 20).Value = t_SalesAllocHead.Docno;
scom.Parameters.Add("@Salesman", SqlDbType.VarChar, 20).Value = t_SalesAllocHead.Salesman;
scom.Parameters.Add("@Item", SqlDbType.VarChar, 20).Value = t_SalesAllocHead.Item;
scom.Parameters.Add("@AllocQTY", SqlDbType.Decimal, 9).Value = t_SalesAllocHead.AllocQTY;
scom.Parameters.Add("@DateFrom", SqlDbType.DateTime, 8).Value = t_SalesAllocHead.DateFrom;
scom.Parameters.Add("@Dateto", SqlDbType.DateTime, 8).Value = t_SalesAllocHead.Dateto;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = t_SalesAllocHead.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_SalesAllocHead.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_CNReason table.
/// </summary>
public Boolean Savem_CNReasonSP(M_CNReason m_CNReason, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_CNReasonSave";
scom.Parameters.Add("@ID", SqlDbType.VarChar, 20).Value = m_CNReason.ID;
scom.Parameters.Add("@Reason", SqlDbType.VarChar, 40).Value = m_CNReason.Reason;
scom.Parameters.Add("@NeedToUpdateStock", SqlDbType.Bit, 1).Value = m_CNReason.NeedToUpdateStock;
scom.Parameters.Add("@StockType", SqlDbType.VarChar, 10).Value = m_CNReason.StockType;
scom.Parameters.Add("@UserCode", SqlDbType.VarChar, 20).Value = m_CNReason.UserCode;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_CNReason.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_DiliveryDet table.
/// </summary>
public Boolean Savet_DiliveryDetSP(T_DiliveryDet t_DiliveryDet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_DiliveryDetSave";
scom.Parameters.Add("@DoNo", SqlDbType.VarChar, 20).Value = t_DiliveryDet.DoNo;
scom.Parameters.Add("@Item", SqlDbType.VarChar, 20).Value = t_DiliveryDet.Item;
scom.Parameters.Add("@ItemNamex", SqlDbType.VarChar, 50).Value = t_DiliveryDet.ItemNamex;
scom.Parameters.Add("@Unit", SqlDbType.VarChar, 10).Value = t_DiliveryDet.Unit;
scom.Parameters.Add("@Qty", SqlDbType.Decimal, 9).Value = t_DiliveryDet.Qty;
scom.Parameters.Add("@Carton", SqlDbType.Decimal, 9).Value = t_DiliveryDet.Carton;
scom.Parameters.Add("@ActualCartons", SqlDbType.Decimal, 9).Value = t_DiliveryDet.ActualCartons;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = t_DiliveryDet.Remarks;
scom.Parameters.Add("@Pass", SqlDbType.Bit, 1).Value = t_DiliveryDet.Pass;
scom.Parameters.Add("@IsCNitem", SqlDbType.Bit, 1).Value = t_DiliveryDet.IsCNitem;
scom.Parameters.Add("@CNNumber", SqlDbType.VarChar, 20).Value = t_DiliveryDet.CNNumber;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_CNBreak table.
/// </summary>
public Boolean Savet_CNBreakSP(T_CNBreak t_CNBreak, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CNBreakSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_CNBreak.DocNo;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_CNBreak.ItemCode;
scom.Parameters.Add("@Namex", SqlDbType.VarChar, 150).Value = t_CNBreak.Namex;
scom.Parameters.Add("@InvQTY", SqlDbType.Decimal, 9).Value = t_CNBreak.InvQTY;
scom.Parameters.Add("@QTY", SqlDbType.Decimal, 9).Value = t_CNBreak.QTY;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_CNBreak.Datex;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = t_CNBreak.Userx;
scom.Parameters.Add("@Grouped", SqlDbType.Bit, 1).Value = t_CNBreak.Grouped;
scom.Parameters.Add("@BalanceQty", SqlDbType.Decimal, 9).Value = t_CNBreak.BalanceQty;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_Loca table.
/// </summary>
public Boolean SaveM_LocaSP(M_Loca m_Loca, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_LocaSave";
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Loca.Locacode;
scom.Parameters.Add("@Companycode", SqlDbType.VarChar, 20).Value = m_Loca.Companycode;
scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = m_Loca.StockCode;
scom.Parameters.Add("@Locaname", SqlDbType.VarChar, 50).Value = m_Loca.Locaname;
scom.Parameters.Add("@Add1", SqlDbType.VarChar, 50).Value = m_Loca.Add1;
scom.Parameters.Add("@Add2", SqlDbType.VarChar, 50).Value = m_Loca.Add2;
scom.Parameters.Add("@Add3", SqlDbType.VarChar, 50).Value = m_Loca.Add3;
scom.Parameters.Add("@Tpno", SqlDbType.VarChar, 20).Value = m_Loca.Tpno;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = m_Loca.Fax;
scom.Parameters.Add("@Emailx", SqlDbType.VarChar, 50).Value = m_Loca.Emailx;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_Loca.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Loca.Datex;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_OrderFormHead table.
/// </summary>
public Boolean Savet_OrderFormHeadSP(T_OrderFormHead t_OrderFormHead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OrderFormHeadSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_OrderFormHead.DocNo;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Locacode;
scom.Parameters.Add("@TRNType", SqlDbType.VarChar, 10).Value = t_OrderFormHead.TRNType;
scom.Parameters.Add("@SalesMan", SqlDbType.VarChar, 20).Value = t_OrderFormHead.SalesMan;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Customer;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_OrderFormHead.Datex;
scom.Parameters.Add("@RecivedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.RecivedBy;
scom.Parameters.Add("@CheckedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.CheckedBy;
scom.Parameters.Add("@Approved", SqlDbType.Int, 4).Value = t_OrderFormHead.Approved;
scom.Parameters.Add("@ApprovedBy", SqlDbType.VarChar, 20).Value = t_OrderFormHead.ApprovedBy;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.ApprovedDate;
scom.Parameters.Add("@RecivedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.RecivedDate;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = t_OrderFormHead.Userx;
scom.Parameters.Add("@CreatedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.CreatedDate;
scom.Parameters.Add("@CQNO", SqlDbType.VarChar, 20).Value = t_OrderFormHead.CQNO;
scom.Parameters.Add("@CQDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.CQDate;
scom.Parameters.Add("@BANK", SqlDbType.VarChar, 20).Value = t_OrderFormHead.BANK;
scom.Parameters.Add("@BRANCH", SqlDbType.VarChar, 20).Value = t_OrderFormHead.BRANCH;
scom.Parameters.Add("@Subtotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.Subtotal;
scom.Parameters.Add("@DiscountPer", SqlDbType.Decimal, 9).Value = t_OrderFormHead.DiscountPer;
scom.Parameters.Add("@SubtotalDisc", SqlDbType.Decimal, 9).Value = t_OrderFormHead.SubtotalDisc;
scom.Parameters.Add("@ItemdiscTotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.ItemdiscTotal;
scom.Parameters.Add("@TotalDisc", SqlDbType.Decimal, 9).Value = t_OrderFormHead.TotalDisc;
scom.Parameters.Add("@NetTotal", SqlDbType.Decimal, 9).Value = t_OrderFormHead.NetTotal;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 250).Value = t_OrderFormHead.Remarks;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_OrderFormHead.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_OrderFormHead.ProcessedUser;
scom.Parameters.Add("@InvCreated", SqlDbType.Int, 4).Value = t_OrderFormHead.InvCreated;
scom.Parameters.Add("@InvCreatedDate", SqlDbType.DateTime, 8).Value = t_OrderFormHead.InvCreatedDate;
scom.Parameters.Add("@INVCreatedUser", SqlDbType.VarChar, 20).Value = t_OrderFormHead.INVCreatedUser;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_Customers table.
/// </summary>
public Boolean SaveM_CustomerSP(M_Customers m_Customer, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_CustomersSave";
scom.Parameters.Add("@CusID", SqlDbType.VarChar, 20).Value = m_Customer.CusID;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_Customer.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Customer.Locacode;
scom.Parameters.Add("@CustName", SqlDbType.VarChar, 50).Value = m_Customer.CustName;
scom.Parameters.Add("@TP", SqlDbType.VarChar, 50).Value = m_Customer.TP;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 50).Value = m_Customer.Fax;
scom.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = m_Customer.Email;
scom.Parameters.Add("@Address1", SqlDbType.VarChar, 50).Value = m_Customer.Address1;
scom.Parameters.Add("@Address2", SqlDbType.VarChar, 50).Value = m_Customer.Address2;
scom.Parameters.Add("@Address3", SqlDbType.VarChar, 50).Value = m_Customer.Address3;
scom.Parameters.Add("@ContactPerson", SqlDbType.VarChar, 20).Value = m_Customer.ContactPerson;
scom.Parameters.Add("@ContactPersonNo", SqlDbType.VarChar, 20).Value = m_Customer.ContactPersonNo;
scom.Parameters.Add("@CurrentStatus", SqlDbType.VarChar, 10).Value = m_Customer.CurrentStatus;
scom.Parameters.Add("@Gradex", SqlDbType.VarChar, 20).Value = m_Customer.Gradex;
scom.Parameters.Add("@CreditLimit", SqlDbType.Decimal, 9).Value = m_Customer.CreditLimit;
scom.Parameters.Add("@CreditPeriod", SqlDbType.Int, 4).Value = m_Customer.CreditPeriod;
scom.Parameters.Add("@MaxDisc", SqlDbType.Decimal, 9).Value = m_Customer.MaxDisc;
scom.Parameters.Add("@MinDisc", SqlDbType.Decimal, 9).Value = m_Customer.MinDisc;
scom.Parameters.Add("@ApplyingDisc", SqlDbType.Decimal, 9).Value = m_Customer.ApplyingDisc;
scom.Parameters.Add("@CusOpenBal", SqlDbType.Decimal, 9).Value = m_Customer.CusOpenBal;
scom.Parameters.Add("@CusCurBal", SqlDbType.Decimal, 9).Value = m_Customer.CusCurBal;
scom.Parameters.Add("@customerOS", SqlDbType.Decimal, 9).Value = m_Customer.customerOS;
scom.Parameters.Add("@pointsEarned", SqlDbType.Decimal, 9).Value = m_Customer.pointsEarned;
scom.Parameters.Add("@controlAccountCode", SqlDbType.VarChar, 15).Value = m_Customer.controlAccountCode;
scom.Parameters.Add("@customerAccountCode", SqlDbType.VarChar, 15).Value = m_Customer.customerAccountCode;
scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = m_Customer.GLUpdate;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_Customer.triggerVal;
scom.Parameters.Add("@SalesMan", SqlDbType.VarChar, 20).Value = m_Customer.SalesMan;
scom.Parameters.Add("@Area", SqlDbType.VarChar, 20).Value = m_Customer.Area;
scom.Parameters.Add("@cat", SqlDbType.VarChar, 20).Value = m_Customer.cat;
scom.Parameters.Add("@subcat", SqlDbType.VarChar, 20).Value = m_Customer.subcat;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the T_Stock table.
/// </summary>
public Boolean SaveT_StockSP(T_Stock t_Stock, int formMode, int StockType)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
if (StockType == 1)
{
scom.CommandText = "T_StockSave";
}
else
{
scom.CommandText = "T_StockDamageSave";
}
scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = t_Stock.StockCode;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_Stock.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_Stock.Locacode;
scom.Parameters.Add("@Suppid", SqlDbType.VarChar, 20).Value = t_Stock.Suppid;
scom.Parameters.Add("@ProductId", SqlDbType.VarChar, 20).Value = t_Stock.ProductId;
scom.Parameters.Add("@Stock", SqlDbType.Decimal, 9).Value = t_Stock.Stock;
scom.Parameters.Add("@OpnStock", SqlDbType.Decimal, 9).Value = t_Stock.OpnStock;
scom.Parameters.Add("@InitialStock", SqlDbType.Decimal, 9).Value = t_Stock.InitialStock;
scom.Parameters.Add("@ReservedStock", SqlDbType.Decimal, 9).Value = t_Stock.ReservedStock;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_Stock.CostPrice;
scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_Stock.SellingPrice;
scom.Parameters.Add("@WholeSalePrice", SqlDbType.Decimal, 9).Value = t_Stock.WholeSalePrice;
scom.Parameters.Add("@MrpPrice", SqlDbType.Decimal, 9).Value = t_Stock.MrpPrice;
scom.Parameters.Add("@CompanyPrice", SqlDbType.Decimal, 9).Value = t_Stock.CompanyPrice;
scom.Parameters.Add("@AvgCost", SqlDbType.Decimal, 9).Value = t_Stock.AvgCost;
scom.Parameters.Add("@InitialCost", SqlDbType.Decimal, 9).Value = t_Stock.InitialCost;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 150).Value = t_Stock.Descr;
scom.Parameters.Add("@FixedGP", SqlDbType.Decimal, 9).Value = t_Stock.FixedGP;
scom.Parameters.Add("@SIH", SqlDbType.Decimal, 9).Value = t_Stock.SIH;
scom.Parameters.Add("@EXPDate", SqlDbType.DateTime, 8).Value = t_Stock.EXPDate;
scom.Parameters.Add("@Usercode", SqlDbType.VarChar, 20).Value = t_Stock.Usercode;
scom.Parameters.Add("@DateCr", SqlDbType.DateTime, 8).Value = t_Stock.DateCr;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
