/// <summary>
/// Saves a record to the T_Stock_open table.
/// </summary>
public Boolean Savet_Stock_openSP(T_Stock_open t_Stock_open, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_Stock_openSave";
scom.Parameters.Add("@DocNo", SqlDbType.VarChar, 20).Value = t_Stock_open.DocNo;
scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = t_Stock_open.StockCode;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_Stock_open.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_Stock_open.Locacode;
scom.Parameters.Add("@Suppid", SqlDbType.VarChar, 20).Value = t_Stock_open.Suppid;
scom.Parameters.Add("@ProductId", SqlDbType.VarChar, 20).Value = t_Stock_open.ProductId;
scom.Parameters.Add("@Stock", SqlDbType.Decimal, 9).Value = t_Stock_open.Stock;
scom.Parameters.Add("@OpnStock", SqlDbType.Decimal, 9).Value = t_Stock_open.OpnStock;
scom.Parameters.Add("@InitialStock", SqlDbType.Decimal, 9).Value = t_Stock_open.InitialStock;
scom.Parameters.Add("@ReservedStock", SqlDbType.Decimal, 9).Value = t_Stock_open.ReservedStock;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_Stock_open.CostPrice;
scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_Stock_open.SellingPrice;
scom.Parameters.Add("@WholeSalePrice", SqlDbType.Decimal, 9).Value = t_Stock_open.WholeSalePrice;
scom.Parameters.Add("@MrpPrice", SqlDbType.Decimal, 9).Value = t_Stock_open.MrpPrice;
scom.Parameters.Add("@CompanyPrice", SqlDbType.Decimal, 9).Value = t_Stock_open.CompanyPrice;
scom.Parameters.Add("@AvgCost", SqlDbType.Decimal, 9).Value = t_Stock_open.AvgCost;
scom.Parameters.Add("@InitialCost", SqlDbType.Decimal, 9).Value = t_Stock_open.InitialCost;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 150).Value = t_Stock_open.Descr;
scom.Parameters.Add("@FixedGP", SqlDbType.Decimal, 9).Value = t_Stock_open.FixedGP;
scom.Parameters.Add("@SIH", SqlDbType.Decimal, 9).Value = t_Stock_open.SIH;
scom.Parameters.Add("@EXPDate", SqlDbType.DateTime, 8).Value = t_Stock_open.EXPDate;
scom.Parameters.Add("@Usercode", SqlDbType.VarChar, 20).Value = t_Stock_open.Usercode;
scom.Parameters.Add("@DateCr", SqlDbType.DateTime, 8).Value = t_Stock_open.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);
}
}
/// <summary>
/// Saves a record to the T_RecDet table.
/// </summary>
public Boolean Savet_RecDetSP(T_RecDet t_RecDet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_RecDetSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 10).Value = t_RecDet.Docno;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_RecDet.locationId;
scom.Parameters.Add("@Sequence", SqlDbType.Int, 4).Value = t_RecDet.Sequence;
scom.Parameters.Add("@Paytype", SqlDbType.VarChar, 20).Value = t_RecDet.Paytype;
scom.Parameters.Add("@HeadAmt", SqlDbType.Decimal, 9).Value = t_RecDet.HeadAmt;
scom.Parameters.Add("@Amt", SqlDbType.Decimal, 9).Value = t_RecDet.Amt;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_RecDet.InvNo;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_RecDet.Datex;
scom.Parameters.Add("@CQno", SqlDbType.VarChar, 20).Value = t_RecDet.CQno;
scom.Parameters.Add("@Bank", SqlDbType.VarChar, 20).Value = t_RecDet.Bank;
scom.Parameters.Add("@BankBranch", SqlDbType.VarChar, 20).Value = t_RecDet.BankBranch;
scom.Parameters.Add("@BankDate", SqlDbType.DateTime, 8).Value = t_RecDet.BankDate;
scom.Parameters.Add("@isReconsile", SqlDbType.Bit, 1).Value = t_RecDet.isReconsile;
scom.Parameters.Add("@ReconsileDate", SqlDbType.DateTime, 8).Value = t_RecDet.ReconsileDate;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_RecDet.Customer;
scom.Parameters.Add("@isreturned", SqlDbType.Bit, 1).Value = t_RecDet.isreturned;
scom.Parameters.Add("@ReturnDate", SqlDbType.DateTime, 8).Value = t_RecDet.ReturnDate;
scom.Parameters.Add("@ReturnUpdateUSer", SqlDbType.VarChar, 20).Value = t_RecDet.ReturnUpdateUSer;
scom.Parameters.Add("@ReasontoRtn", SqlDbType.VarChar, 120).Value = t_RecDet.ReasontoRtn;
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_grn_detail table.
/// </summary>
public Boolean Savet_grn_detailSP(t_grn_detail t_grn_detail, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_grn_detailSave";
scom.Parameters.Add("@grnNo", SqlDbType.VarChar, 20).Value = t_grn_detail.grnNo;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_grn_detail.locationId;
scom.Parameters.Add("@productId", SqlDbType.VarChar, 20).Value = t_grn_detail.productId;
scom.Parameters.Add("@stock", SqlDbType.Decimal, 9).Value = t_grn_detail.stock;
scom.Parameters.Add("@tax", SqlDbType.Decimal, 9).Value = t_grn_detail.tax;
scom.Parameters.Add("@priceLevel", SqlDbType.VarChar, 10).Value = t_grn_detail.priceLevel;
scom.Parameters.Add("@quantity", SqlDbType.Int, 4).Value = t_grn_detail.quantity;
scom.Parameters.Add("@freeQty", SqlDbType.Int, 4).Value = t_grn_detail.freeQty;
scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_grn_detail.amount;
scom.Parameters.Add("@disPerc", SqlDbType.Decimal, 9).Value = t_grn_detail.disPerc;
scom.Parameters.Add("@disAmount", SqlDbType.Decimal, 9).Value = t_grn_detail.disAmount;
scom.Parameters.Add("@batchNo", SqlDbType.VarChar, 20).Value = t_grn_detail.batchNo;
scom.Parameters.Add("@expDate", SqlDbType.DateTime, 8).Value = t_grn_detail.expDate;
scom.Parameters.Add("@stockCode", SqlDbType.VarChar, 20).Value = t_grn_detail.stockCode;
scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.costPrice;
scom.Parameters.Add("@sellingPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.sellingPrice;
scom.Parameters.Add("@returnedQuantity", SqlDbType.Int, 4).Value = t_grn_detail.returnedQuantity;
scom.Parameters.Add("@remainingQuantity", SqlDbType.Int, 4).Value = t_grn_detail.remainingQuantity;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn_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_RecHed table.
/// </summary>
public Boolean Savet_RecHedSP(T_RecHed t_RecHed, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_RecHedSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 10).Value = t_RecHed.Docno;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_RecHed.locationId;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_RecHed.Datex;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_RecHed.Customer;
scom.Parameters.Add("@Status", SqlDbType.VarChar, 10).Value = t_RecHed.Status;
scom.Parameters.Add("@refNo", SqlDbType.VarChar, 20).Value = t_RecHed.refNo;
scom.Parameters.Add("@Memo", SqlDbType.VarChar, 150).Value = t_RecHed.Memo;
scom.Parameters.Add("@Recivedfrom", SqlDbType.VarChar, 150).Value = t_RecHed.Recivedfrom;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_RecHed.remarks;
scom.Parameters.Add("@Amount", SqlDbType.Decimal, 9).Value = t_RecHed.Amount;
scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_RecHed.isProcessed;
scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_RecHed.processDate;
scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_RecHed.processUser;
scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_RecHed.isSaved;
scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_RecHed.GLUpdate;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_RecHed.triggerVal;
scom.Parameters.Add("@iscancelled", SqlDbType.Bit, 1).Value = t_RecHed.iscancelled;
scom.Parameters.Add("@CancelledUser", SqlDbType.VarChar, 20).Value = t_RecHed.CancelledUser;
scom.Parameters.Add("@CancelledDate", SqlDbType.DateTime, 8).Value = t_RecHed.CancelledDate;
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_purchaseOrder table.
/// </summary>
public Boolean Savet_purchaseOrderSP(t_purchaseOrder t_purchaseOrder, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_purchaseOrderSave";
scom.Parameters.Add("@no", SqlDbType.VarChar, 20).Value = t_purchaseOrder.no;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_purchaseOrder.locationId;
scom.Parameters.Add("@reqLocationId", SqlDbType.VarChar, 20).Value = t_purchaseOrder.reqLocationId;
scom.Parameters.Add("@pReqNo", SqlDbType.VarChar, 20).Value = t_purchaseOrder.pReqNo;
scom.Parameters.Add("@poMethod", SqlDbType.VarChar, 20).Value = t_purchaseOrder.poMethod;
scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_purchaseOrder.date;
scom.Parameters.Add("@supplierId", SqlDbType.VarChar, 20).Value = t_purchaseOrder.supplierId;
scom.Parameters.Add("@DeliveryDate", SqlDbType.DateTime, 8).Value = t_purchaseOrder.DeliveryDate;
scom.Parameters.Add("@DLocationID", SqlDbType.VarChar, 20).Value = t_purchaseOrder.DLocationID;
scom.Parameters.Add("@noOfItems", SqlDbType.Decimal, 9).Value = t_purchaseOrder.noOfItems;
scom.Parameters.Add("@noOfPeaces", SqlDbType.Decimal, 9).Value = t_purchaseOrder.noOfPeaces;
scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_purchaseOrder.grossAmount;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 100).Value = t_purchaseOrder.remarks;
scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_purchaseOrder.isSaved;
scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_purchaseOrder.isProcessed;
scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_purchaseOrder.processDate;
scom.Parameters.Add("@processUser", SqlDbType.VarChar, 20).Value = t_purchaseOrder.processUser;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_purchaseOrder.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_Agents table.
/// </summary>
public Boolean SaveM_AgentSP(M_Agents m_Agent, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_AgentsSave";
scom.Parameters.Add("@AgentCode", SqlDbType.VarChar, 20).Value = m_Agent.AgentCode;
scom.Parameters.Add("@Namex", SqlDbType.VarChar, 50).Value = m_Agent.Namex;
scom.Parameters.Add("@Address1", SqlDbType.VarChar, 150).Value = m_Agent.Address1;
scom.Parameters.Add("@Address2", SqlDbType.VarChar, 150).Value = m_Agent.Address2;
scom.Parameters.Add("@Address3", SqlDbType.VarChar, 150).Value = m_Agent.Address3;
scom.Parameters.Add("@TPOffice", SqlDbType.VarChar, 50).Value = m_Agent.TPOffice;
scom.Parameters.Add("@TPPersonal", SqlDbType.VarChar, 50).Value = m_Agent.TPPersonal;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 50).Value = m_Agent.Fax;
scom.Parameters.Add("@Email", SqlDbType.VarChar, 20).Value = m_Agent.Email;
scom.Parameters.Add("@AccNo", SqlDbType.VarChar, 20).Value = m_Agent.AccNo;
scom.Parameters.Add("@NICno", SqlDbType.VarChar, 20).Value = m_Agent.NICno;
scom.Parameters.Add("@PassportNo", SqlDbType.VarChar, 20).Value = m_Agent.PassportNo;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Agent.Datex;
scom.Parameters.Add("@userx", SqlDbType.VarChar, 20).Value = m_Agent.userx;
scom.Parameters.Add("@TimeFrom", SqlDbType.DateTime, 8).Value = m_Agent.TimeFrom;
scom.Parameters.Add("@TimeTo", SqlDbType.DateTime, 8).Value = m_Agent.TimeTo;
scom.Parameters.Add("@District", SqlDbType.VarChar, 20).Value = m_Agent.District;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = m_Agent.Remarks;
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_CNGrouping table.
/// </summary>
public Boolean Savet_CNGroupingSP(T_CNGrouping t_CNGrouping, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_CNGroupingSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 20).Value = t_CNGrouping.Docno;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_CNGrouping.ItemCode;
scom.Parameters.Add("@Name", SqlDbType.VarChar, 150).Value = t_CNGrouping.Name;
scom.Parameters.Add("@CNType", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNType;
scom.Parameters.Add("@CNReason", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNReason;
scom.Parameters.Add("@InvoiceQty", SqlDbType.Decimal, 9).Value = t_CNGrouping.InvoiceQty;
scom.Parameters.Add("@CNQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.CNQTY;
scom.Parameters.Add("@BreakdownQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.BreakdownQTY;
scom.Parameters.Add("@TagNumber", SqlDbType.VarChar, 50).Value = t_CNGrouping.TagNumber;
scom.Parameters.Add("@Selected", SqlDbType.Bit, 1).Value = t_CNGrouping.Selected;
scom.Parameters.Add("@SelectedQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.SelectedQTY;
scom.Parameters.Add("@balanceQTY", SqlDbType.Decimal, 9).Value = t_CNGrouping.balanceQTY;
scom.Parameters.Add("@Shipped", SqlDbType.Bit, 1).Value = t_CNGrouping.Shipped;
scom.Parameters.Add("@ShippedDate", SqlDbType.DateTime, 8).Value = t_CNGrouping.ShippedDate;
scom.Parameters.Add("@ShippedDO", SqlDbType.VarChar, 20).Value = t_CNGrouping.ShippedDO;
scom.Parameters.Add("@CNnumber", SqlDbType.VarChar, 20).Value = t_CNGrouping.CNnumber;
scom.Parameters.Add("@PartEntered", SqlDbType.Bit, 1).Value = t_CNGrouping.PartEntered;
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_trnsferNote table.
/// </summary>
public Boolean Savet_trnsferNoteSP(t_trnsferNote t_trnsferNote, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_trnsferNoteSave";
scom.Parameters.Add("@no", SqlDbType.VarChar, 20).Value = t_trnsferNote.no;
scom.Parameters.Add("@sourceLocId", SqlDbType.VarChar, 20).Value = t_trnsferNote.sourceLocId;
scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_trnsferNote.date;
scom.Parameters.Add("@refNo", SqlDbType.VarChar, 20).Value = t_trnsferNote.refNo;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_trnsferNote.remarks;
scom.Parameters.Add("@destinationLocId", SqlDbType.VarChar, 20).Value = t_trnsferNote.destinationLocId;
scom.Parameters.Add("@purchaseReqNo", SqlDbType.VarChar, 20).Value = t_trnsferNote.purchaseReqNo;
scom.Parameters.Add("@noOfItems", SqlDbType.Decimal, 9).Value = t_trnsferNote.noOfItems;
scom.Parameters.Add("@noOfPeaces", SqlDbType.Decimal, 9).Value = t_trnsferNote.noOfPeaces;
scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_trnsferNote.grossAmount;
scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_trnsferNote.isSaved;
scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_trnsferNote.isProcessed;
scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_trnsferNote.processDate;
scom.Parameters.Add("@processUser", SqlDbType.VarChar, 20).Value = t_trnsferNote.processUser;
scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_trnsferNote.GLUpdate;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_trnsferNote.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_StockRet table.
/// </summary>
public Boolean SaveT_StockRetSP(T_StockDamage t_StockRet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_StockRetSave";
scom.Parameters.Add("@StockCode", SqlDbType.VarChar, 20).Value = t_StockRet.StockCode;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = t_StockRet.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_StockRet.Locacode;
scom.Parameters.Add("@Suppid", SqlDbType.VarChar, 20).Value = t_StockRet.Suppid;
scom.Parameters.Add("@ProductId", SqlDbType.VarChar, 20).Value = t_StockRet.ProductId;
//scom.Parameters.Add("@Type", SqlDbType.VarChar, 20).Value = t_StockRet.Type;
//scom.Parameters.Add("@Qty", SqlDbType.Decimal, 9).Value = t_StockRet.Qty;
scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = t_StockRet.SellingPrice;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_StockRet.CostPrice;
scom.Parameters.Add("@AvgCost", SqlDbType.Decimal, 9).Value = t_StockRet.AvgCost;
scom.Parameters.Add("@OpnStock", SqlDbType.Decimal, 9).Value = t_StockRet.OpnStock;
scom.Parameters.Add("@InitialCost", SqlDbType.Decimal, 9).Value = t_StockRet.InitialCost;
scom.Parameters.Add("@InitialStock", SqlDbType.Decimal, 9).Value = t_StockRet.InitialStock;
scom.Parameters.Add("@Descr", SqlDbType.VarChar, 150).Value = t_StockRet.Descr;
scom.Parameters.Add("@Usercode", SqlDbType.VarChar, 20).Value = t_StockRet.Usercode;
//scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_StockRet.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_SalesMan table.
/// </summary>
public Boolean SaveM_SalesManSP(M_SalesMan m_SalesMan, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_SalesManSave";
scom.Parameters.Add("@SalesmanID", SqlDbType.VarChar, 20).Value = m_SalesMan.SalesmanID;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_SalesMan.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_SalesMan.Locacode;
scom.Parameters.Add("@SalesmanName", SqlDbType.VarChar, 50).Value = m_SalesMan.SalesmanName;
scom.Parameters.Add("@TP", SqlDbType.VarChar, 20).Value = m_SalesMan.TP;
scom.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = m_SalesMan.Fax;
scom.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = m_SalesMan.Email;
scom.Parameters.Add("@Address1", SqlDbType.VarChar, 50).Value = m_SalesMan.Address1;
scom.Parameters.Add("@Address2", SqlDbType.VarChar, 50).Value = m_SalesMan.Address2;
scom.Parameters.Add("@Address3", SqlDbType.VarChar, 50).Value = m_SalesMan.Address3;
scom.Parameters.Add("@ContactPerson", SqlDbType.VarChar, 20).Value = m_SalesMan.ContactPerson;
scom.Parameters.Add("@ContactPersonNo", SqlDbType.VarChar, 50).Value = m_SalesMan.ContactPersonNo;
scom.Parameters.Add("@CurrentStatus", SqlDbType.VarChar, 20).Value = m_SalesMan.CurrentStatus;
scom.Parameters.Add("@Gradex", SqlDbType.VarChar, 20).Value = m_SalesMan.Gradex;
scom.Parameters.Add("@NICNo", SqlDbType.VarChar, 20).Value = m_SalesMan.NICNo;
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_PayMode table.
/// </summary>
public Boolean Savem_PayModeSP(M_PayMode m_PayMode, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_PayModeSave";
scom.Parameters.Add("@id", SqlDbType.VarChar, 10).Value = m_PayMode.id;
scom.Parameters.Add("@description", SqlDbType.VarChar, 50).Value = m_PayMode.description;
scom.Parameters.Add("@isActive", SqlDbType.Int, 4).Value = m_PayMode.isActive;
scom.Parameters.Add("@isSubPaymode", SqlDbType.Int, 4).Value = m_PayMode.isSubPaymode;
scom.Parameters.Add("@isAddBalance", SqlDbType.Int, 4).Value = m_PayMode.isAddBalance;
scom.Parameters.Add("@isAdvancePayment", SqlDbType.Int, 4).Value = m_PayMode.isAdvancePayment;
scom.Parameters.Add("@isControlOverPayment", SqlDbType.Int, 4).Value = m_PayMode.isControlOverPayment;
scom.Parameters.Add("@isVoucher", SqlDbType.Int, 4).Value = m_PayMode.isVoucher;
scom.Parameters.Add("@accountCode", SqlDbType.VarChar, 15).Value = m_PayMode.accountCode;
scom.Parameters.Add("@CommissionAccCode", SqlDbType.VarChar, 15).Value = m_PayMode.CommissionAccCode;
scom.Parameters.Add("@isCredit", SqlDbType.Int, 4).Value = m_PayMode.isCredit;
scom.Parameters.Add("@isPoint", SqlDbType.Int, 4).Value = m_PayMode.isPoint;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_PayMode.triggerVal;
scom.Parameters.Add("@ischeque", SqlDbType.Int, 4).Value = m_PayMode.ischeque;
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_packinghead table.
/// </summary>
public Boolean Savet_packingheadSP(T_packinghead t_packinghead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_packingheadSave";
scom.Parameters.Add("@PackingNo", SqlDbType.VarChar, 20).Value = t_packinghead.PackingNo;
scom.Parameters.Add("@RefNumber", SqlDbType.VarChar, 20).Value = t_packinghead.RefNumber;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_packinghead.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_packinghead.LocaCode;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_packinghead.Datex;
scom.Parameters.Add("@NoOfCartons", SqlDbType.Decimal, 9).Value = t_packinghead.NoOfCartons;
scom.Parameters.Add("@Vehicle", SqlDbType.VarChar, 20).Value = t_packinghead.Vehicle;
scom.Parameters.Add("@Driver", SqlDbType.VarChar, 20).Value = t_packinghead.Driver;
scom.Parameters.Add("@CreatedUser", SqlDbType.VarChar, 20).Value = t_packinghead.CreatedUser;
scom.Parameters.Add("@CreatedTime", SqlDbType.DateTime, 8).Value = t_packinghead.CreatedTime;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_packinghead.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_packinghead.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_packinghead.ProcessedUser;
scom.Parameters.Add("@Glupdated", SqlDbType.Bit, 1).Value = t_packinghead.Glupdated;
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_Vehicles table.
/// </summary>
public Boolean SaveM_VehicleSP(M_Vehicles m_Vehicle, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_VehiclesSave";
scom.Parameters.Add("@VehicleID", SqlDbType.VarChar, 20).Value = m_Vehicle.VehicleID;
scom.Parameters.Add("@VehicleNo", SqlDbType.VarChar, 20).Value = m_Vehicle.VehicleNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = m_Vehicle.CompCode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Vehicle.Locacode;
scom.Parameters.Add("@Make", SqlDbType.VarChar, 30).Value = m_Vehicle.Make;
scom.Parameters.Add("@Model", SqlDbType.VarChar, 30).Value = m_Vehicle.Model;
scom.Parameters.Add("@Driver", SqlDbType.VarChar, 50).Value = m_Vehicle.Driver;
scom.Parameters.Add("@Milage", SqlDbType.VarChar, 50).Value = m_Vehicle.Milage;
scom.Parameters.Add("@FuelEfficiency", SqlDbType.Decimal, 9).Value = m_Vehicle.FuelEfficiency;
scom.Parameters.Add("@Status", SqlDbType.VarChar, 20).Value = m_Vehicle.Status;
scom.Parameters.Add("@Route", SqlDbType.VarChar, 20).Value = m_Vehicle.Route;
scom.Parameters.Add("@Userx", SqlDbType.VarChar, 20).Value = m_Vehicle.Userx;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_Vehicle.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_OrderFormDet table.
/// </summary>
public Boolean Savet_OrderFormDetSP(T_OrderFormDet t_OrderFormDet, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OrderFormDetSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Docno;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.CompCode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Locacode;
scom.Parameters.Add("@OFNo", SqlDbType.VarChar, 20).Value = t_OrderFormDet.OFNo;
scom.Parameters.Add("@ItemCode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.ItemCode;
scom.Parameters.Add("@Quntity", SqlDbType.Decimal, 9).Value = t_OrderFormDet.Quntity;
scom.Parameters.Add("@Barcode", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Barcode;
scom.Parameters.Add("@UnitPrice", SqlDbType.Decimal, 9).Value = t_OrderFormDet.UnitPrice;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = t_OrderFormDet.CostPrice;
scom.Parameters.Add("@Unit", SqlDbType.VarChar, 20).Value = t_OrderFormDet.Unit;
scom.Parameters.Add("@Amountx", SqlDbType.Decimal, 9).Value = t_OrderFormDet.Amountx;
scom.Parameters.Add("@discper", SqlDbType.Decimal, 9).Value = t_OrderFormDet.discper;
scom.Parameters.Add("@discount", SqlDbType.Decimal, 9).Value = t_OrderFormDet.discount;
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_OpenStkHead table.
/// </summary>
public Boolean Savet_OpenStkHeadSP(T_OpenStkHead t_OpenStkHead, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OpenStkHeadSave";
scom.Parameters.Add("@Docno", SqlDbType.VarChar, 10).Value = t_OpenStkHead.Docno;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_OpenStkHead.locationId;
scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_OpenStkHead.date;
scom.Parameters.Add("@supplier", SqlDbType.VarChar, 20).Value = t_OpenStkHead.supplier;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_OpenStkHead.remarks;
scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_OpenStkHead.grossAmount;
scom.Parameters.Add("@netAmount", SqlDbType.Decimal, 9).Value = t_OpenStkHead.netAmount;
scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_OpenStkHead.isSaved;
scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_OpenStkHead.isProcessed;
scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_OpenStkHead.processDate;
scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_OpenStkHead.processUser;
scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_OpenStkHead.GLUpdate;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_OpenStkHead.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_grn table.
/// </summary>
public Boolean Savet_grnSP(t_grn t_grn, List <t_grn_detail> grndets, int formMode, string screenname)
{
SqlCommand scom;
bool retvalue = false;
try
{
using (TransactionScope transaction = new TransactionScope())
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_grnSave";
scom.Parameters.Add("@no", SqlDbType.VarChar, 10).Value = t_grn.no;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 10).Value = t_grn.locationId;
scom.Parameters.Add("@poNo", SqlDbType.VarChar, 20).Value = t_grn.poNo;
scom.Parameters.Add("@date", SqlDbType.DateTime, 8).Value = t_grn.date;
scom.Parameters.Add("@refNo", SqlDbType.VarChar, 20).Value = t_grn.refNo;
scom.Parameters.Add("@expireDate", SqlDbType.DateTime, 8).Value = t_grn.expireDate;
scom.Parameters.Add("@supplierId", SqlDbType.VarChar, 20).Value = t_grn.supplierId;
scom.Parameters.Add("@supInvoiceNo", SqlDbType.VarChar, 20).Value = t_grn.supInvoiceNo;
scom.Parameters.Add("@supInvoiceDate", SqlDbType.DateTime, 8).Value = t_grn.supInvoiceDate;
scom.Parameters.Add("@supInvoiceValue", SqlDbType.Decimal, 9).Value = t_grn.supInvoiceValue;
scom.Parameters.Add("@supDoNo", SqlDbType.VarChar, 20).Value = t_grn.supDoNo;
scom.Parameters.Add("@supDoDate", SqlDbType.DateTime, 8).Value = t_grn.supDoDate;
scom.Parameters.Add("@remarks", SqlDbType.VarChar, 50).Value = t_grn.remarks;
scom.Parameters.Add("@noOfItems", SqlDbType.Decimal, 9).Value = t_grn.noOfItems;
scom.Parameters.Add("@noOfPieces", SqlDbType.Decimal, 9).Value = t_grn.noOfPieces;
scom.Parameters.Add("@grossAmount", SqlDbType.Decimal, 9).Value = t_grn.grossAmount;
scom.Parameters.Add("@isSaved", SqlDbType.Bit, 1).Value = t_grn.isSaved;
scom.Parameters.Add("@isProcessed", SqlDbType.Bit, 1).Value = t_grn.isProcessed;
scom.Parameters.Add("@processDate", SqlDbType.DateTime, 8).Value = t_grn.processDate;
scom.Parameters.Add("@processUser", SqlDbType.VarChar, 30).Value = t_grn.processUser;
scom.Parameters.Add("@netDiscount", SqlDbType.Decimal, 9).Value = t_grn.netDiscount;
scom.Parameters.Add("@additions", SqlDbType.Decimal, 9).Value = t_grn.additions;
scom.Parameters.Add("@deductions", SqlDbType.Decimal, 9).Value = t_grn.deductions;
scom.Parameters.Add("@netAmount", SqlDbType.Decimal, 9).Value = t_grn.netAmount;
scom.Parameters.Add("@isAllReturned", SqlDbType.Bit, 1).Value = t_grn.isAllReturned;
scom.Parameters.Add("@GLUpdate", SqlDbType.Bit, 1).Value = t_grn.GLUpdate;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
retvalue = new u_DBConnection().RunQuery(scom);
foreach (t_grn_detail t_grn_detail in grndets)
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_grn_detailSave";
scom.Parameters.Add("@grnNo", SqlDbType.VarChar, 20).Value = t_grn_detail.grnNo;
scom.Parameters.Add("@locationId", SqlDbType.VarChar, 20).Value = t_grn_detail.locationId;
scom.Parameters.Add("@productId", SqlDbType.VarChar, 20).Value = t_grn_detail.productId;
scom.Parameters.Add("@stock", SqlDbType.Decimal, 9).Value = t_grn_detail.stock;
scom.Parameters.Add("@tax", SqlDbType.Decimal, 9).Value = t_grn_detail.tax;
scom.Parameters.Add("@priceLevel", SqlDbType.VarChar, 10).Value = t_grn_detail.priceLevel;
scom.Parameters.Add("@quantity", SqlDbType.Int, 4).Value = t_grn_detail.quantity;
scom.Parameters.Add("@freeQty", SqlDbType.Int, 4).Value = t_grn_detail.freeQty;
scom.Parameters.Add("@amount", SqlDbType.Decimal, 9).Value = t_grn_detail.amount;
scom.Parameters.Add("@disPerc", SqlDbType.Decimal, 9).Value = t_grn_detail.disPerc;
scom.Parameters.Add("@disAmount", SqlDbType.Decimal, 9).Value = t_grn_detail.disAmount;
scom.Parameters.Add("@batchNo", SqlDbType.VarChar, 20).Value = t_grn_detail.batchNo;
scom.Parameters.Add("@expDate", SqlDbType.DateTime, 8).Value = t_grn_detail.expDate;
scom.Parameters.Add("@stockCode", SqlDbType.VarChar, 20).Value = t_grn_detail.stockCode;
scom.Parameters.Add("@costPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.costPrice;
scom.Parameters.Add("@sellingPrice", SqlDbType.Decimal, 9).Value = t_grn_detail.sellingPrice;
scom.Parameters.Add("@returnedQuantity", SqlDbType.Int, 4).Value = t_grn_detail.returnedQuantity;
scom.Parameters.Add("@remainingQuantity", SqlDbType.Int, 4).Value = t_grn_detail.remainingQuantity;
scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = t_grn_detail.triggerVal;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = 1; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
retvalue = new u_DBConnection().RunQuery(scom);
}
//increment the serial
transaction.Complete();
}
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Saves a record to the M_Products table.
/// </summary>
public Boolean SaveM_ProductSP(M_Products m_Product, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "M_ProductsSave";
scom.Parameters.Add("@IDX", SqlDbType.VarChar, 20).Value = m_Product.IDX;
scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_Product.Compcode;
scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_Product.Locacode;
scom.Parameters.Add("@Namex", SqlDbType.VarChar, 150).Value = m_Product.Namex;
scom.Parameters.Add("@PrintName", SqlDbType.VarChar, 150).Value = m_Product.PrintName;
scom.Parameters.Add("@Category", SqlDbType.VarChar, 30).Value = m_Product.Category;
scom.Parameters.Add("@Make", SqlDbType.VarChar, 30).Value = m_Product.Make;
scom.Parameters.Add("@Model", SqlDbType.VarChar, 30).Value = m_Product.Model;
scom.Parameters.Add("@Brand", SqlDbType.VarChar, 30).Value = m_Product.Brand;
scom.Parameters.Add("@Color", SqlDbType.VarChar, 30).Value = m_Product.Color;
scom.Parameters.Add("@Unitx", SqlDbType.VarChar, 30).Value = m_Product.Unitx;
scom.Parameters.Add("@Suplier", SqlDbType.VarChar, 30).Value = m_Product.Suplier;
scom.Parameters.Add("@UnitPrice", SqlDbType.Decimal, 9).Value = m_Product.UnitPrice;
scom.Parameters.Add("@SellingPrice", SqlDbType.Decimal, 9).Value = m_Product.SellingPrice;
scom.Parameters.Add("@CostPrice", SqlDbType.Decimal, 9).Value = m_Product.CostPrice;
scom.Parameters.Add("@ReorderQTY", SqlDbType.Decimal, 9).Value = m_Product.ReorderQTY;
scom.Parameters.Add("@ReorderLevel", SqlDbType.Decimal, 9).Value = m_Product.ReorderLevel;
scom.Parameters.Add("@MaxDisc", SqlDbType.Decimal, 9).Value = m_Product.MaxDisc;
scom.Parameters.Add("@MinDisc", SqlDbType.Decimal, 9).Value = m_Product.MinDisc;
scom.Parameters.Add("@ApplyingDisc", SqlDbType.Decimal, 9).Value = m_Product.ApplyingDisc;
scom.Parameters.Add("@LockItem", SqlDbType.Bit, 1).Value = m_Product.LockItem;
scom.Parameters.Add("@IsActive", SqlDbType.Bit, 1).Value = m_Product.IsActive;
scom.Parameters.Add("@FrezzItem", SqlDbType.Bit, 1).Value = m_Product.FrezzItem;
scom.Parameters.Add("@DiscountAllowed", SqlDbType.Bit, 1).Value = m_Product.DiscountAllowed;
scom.Parameters.Add("@SalesCommAllowed", SqlDbType.Bit, 1).Value = m_Product.SalesCommAllowed;
scom.Parameters.Add("@NegativeQTY", SqlDbType.Bit, 1).Value = m_Product.NegativeQTY;
scom.Parameters.Add("@VatApplicable", SqlDbType.Bit, 1).Value = m_Product.VatApplicable;
scom.Parameters.Add("@Norefundable", SqlDbType.Bit, 1).Value = m_Product.Norefundable;
scom.Parameters.Add("@OpenPrice", SqlDbType.Bit, 1).Value = m_Product.OpenPrice;
scom.Parameters.Add("@StockLot", SqlDbType.Bit, 1).Value = m_Product.StockLot;
scom.Parameters.Add("@isOpenPrice", SqlDbType.Bit, 1).Value = m_Product.isOpenPrice;
scom.Parameters.Add("@IsMaintainStockLot", SqlDbType.Bit, 1).Value = m_Product.IsMaintainStockLot;
scom.Parameters.Add("@WholesalePrice", SqlDbType.Decimal, 9).Value = m_Product.WholesalePrice;
scom.Parameters.Add("@SupplierWarrenty", SqlDbType.Decimal, 9).Value = m_Product.SupplierWarrenty;
scom.Parameters.Add("@CustomerWarrenty", SqlDbType.Decimal, 9).Value = m_Product.CustomerWarrenty;
scom.Parameters.Add("@CommissionAmount", SqlDbType.Decimal, 9).Value = m_Product.CommissionAmount;
scom.Parameters.Add("@CommissionPer", SqlDbType.Decimal, 9).Value = m_Product.CommissionPer;
scom.Parameters.Add("@CreateUser", SqlDbType.VarChar, 20).Value = m_Product.CreateUser;
scom.Parameters.Add("@CreateDate", SqlDbType.DateTime, 8).Value = m_Product.CreateDate;
scom.Parameters.Add("@ModifyUser", SqlDbType.VarChar, 20).Value = m_Product.ModifyUser;
scom.Parameters.Add("@ModifyDate", SqlDbType.DateTime, 8).Value = m_Product.ModifyDate;
scom.Parameters.Add("@SubCategory", SqlDbType.VarChar, 20).Value = m_Product.SubCategory;
scom.Parameters.Add("@AutoIndex", SqlDbType.Int, 4).Value = m_Product.AutoIndex;
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_DIliveryHed table.
/// </summary>
public Boolean Savet_DIliveryHedSP(T_DIliveryHed t_DIliveryHed, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_DIliveryHedSave";
scom.Parameters.Add("@DoNo", SqlDbType.VarChar, 20).Value = t_DIliveryHed.DoNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_DIliveryHed.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_DIliveryHed.LocaCode;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_DIliveryHed.InvNo;
scom.Parameters.Add("@InvoiceAmount", SqlDbType.Decimal, 9).Value = t_DIliveryHed.InvoiceAmount;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_DIliveryHed.Customer;
scom.Parameters.Add("@CustomerDIscRate", SqlDbType.Decimal, 9).Value = t_DIliveryHed.CustomerDIscRate;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_DIliveryHed.Datex;
scom.Parameters.Add("@Agent", SqlDbType.VarChar, 20).Value = t_DIliveryHed.Agent;
scom.Parameters.Add("@Lorry", SqlDbType.VarChar, 20).Value = t_DIliveryHed.Lorry;
scom.Parameters.Add("@NoOfCartons", SqlDbType.Decimal, 9).Value = t_DIliveryHed.NoOfCartons;
scom.Parameters.Add("@Dispatched", SqlDbType.Int, 4).Value = t_DIliveryHed.Dispatched;
scom.Parameters.Add("@DispatchedDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.DispatchedDate;
scom.Parameters.Add("@DispatchedUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.DispatchedUser;
scom.Parameters.Add("@Checked", SqlDbType.Int, 4).Value = t_DIliveryHed.Checked;
scom.Parameters.Add("@CheckedUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.CheckedUser;
scom.Parameters.Add("@Checkeddate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.Checkeddate;
scom.Parameters.Add("@Approved", SqlDbType.Int, 4).Value = t_DIliveryHed.Approved;
scom.Parameters.Add("@ApprovedUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.ApprovedUser;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.ApprovedDate;
scom.Parameters.Add("@Handovered", SqlDbType.Int, 4).Value = t_DIliveryHed.Handovered;
scom.Parameters.Add("@HandoverdUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.HandoverdUser;
scom.Parameters.Add("@HandoverDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.HandoverDate;
scom.Parameters.Add("@HandoverCartons", SqlDbType.Decimal, 9).Value = t_DIliveryHed.HandoverCartons;
scom.Parameters.Add("@Delivered", SqlDbType.Int, 4).Value = t_DIliveryHed.Delivered;
scom.Parameters.Add("@DiliveredUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.DiliveredUser;
scom.Parameters.Add("@DiliveryDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.DiliveryDate;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = t_DIliveryHed.Remarks;
scom.Parameters.Add("@NoOfPrints", SqlDbType.Decimal, 9).Value = t_DIliveryHed.NoOfPrints;
scom.Parameters.Add("@PrintUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.PrintUser;
scom.Parameters.Add("@Status", SqlDbType.VarChar, 10).Value = t_DIliveryHed.Status;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_DIliveryHed.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.ProcessedUser;
scom.Parameters.Add("@Audited", SqlDbType.Int, 4).Value = t_DIliveryHed.Audited;
scom.Parameters.Add("@AuditDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.AuditDate;
scom.Parameters.Add("@AuditUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.AuditUser;
scom.Parameters.Add("@Completed", SqlDbType.Int, 4).Value = t_DIliveryHed.Completed;
scom.Parameters.Add("@CompletedDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.CompletedDate;
scom.Parameters.Add("@PackingListCreated", SqlDbType.Int, 4).Value = t_DIliveryHed.PackingListCreated;
scom.Parameters.Add("@PackingListNo", SqlDbType.VarChar, 20).Value = t_DIliveryHed.PackingListNo;
scom.Parameters.Add("@PackingListDate", SqlDbType.DateTime, 8).Value = t_DIliveryHed.PackingListDate;
scom.Parameters.Add("@PackingListUser", SqlDbType.VarChar, 20).Value = t_DIliveryHed.PackingListUser;
scom.Parameters.Add("@ReportedProblems", SqlDbType.VarChar, 250).Value = t_DIliveryHed.ReportedProblems;
scom.Parameters.Add("@AuditRemarks", SqlDbType.VarChar, 250).Value = t_DIliveryHed.AuditRemarks;
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_InvoiceHed table.
/// </summary>
public Boolean Savet_InvoiceHedSP(T_InvoiceHed t_InvoiceHed, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_InvoiceHedSave";
scom.Parameters.Add("@InvID", SqlDbType.VarChar, 20).Value = t_InvoiceHed.InvID;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_InvoiceHed.LocaCode;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_InvoiceHed.Customer;
scom.Parameters.Add("@Paymeth", SqlDbType.VarChar, 10).Value = t_InvoiceHed.Paymeth;
scom.Parameters.Add("@RefNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.RefNo;
scom.Parameters.Add("@ManualNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.ManualNo;
scom.Parameters.Add("@OrderFormNo", SqlDbType.VarChar, 20).Value = t_InvoiceHed.OrderFormNo;
scom.Parameters.Add("@DONumber", SqlDbType.VarChar, 20).Value = t_InvoiceHed.DONumber;
scom.Parameters.Add("@GrossAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.GrossAmt;
scom.Parameters.Add("@SubtotaldiscPer", SqlDbType.Decimal, 9).Value = t_InvoiceHed.SubtotaldiscPer;
scom.Parameters.Add("@SubtotalDisc", SqlDbType.Decimal, 9).Value = t_InvoiceHed.SubtotalDisc;
scom.Parameters.Add("@ItemdiscTotal", SqlDbType.Decimal, 9).Value = t_InvoiceHed.ItemdiscTotal;
scom.Parameters.Add("@TotalDisc", SqlDbType.Decimal, 9).Value = t_InvoiceHed.TotalDisc;
scom.Parameters.Add("@Tax", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Tax;
scom.Parameters.Add("@Vatamt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Vatamt;
scom.Parameters.Add("@NetAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.NetAmt;
scom.Parameters.Add("@CreditPeriod", SqlDbType.Decimal, 9).Value = t_InvoiceHed.CreditPeriod;
scom.Parameters.Add("@Noofitems", SqlDbType.Decimal, 9).Value = t_InvoiceHed.Noofitems;
scom.Parameters.Add("@NoOfPieces", SqlDbType.Decimal, 9).Value = t_InvoiceHed.NoOfPieces;
scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = t_InvoiceHed.Datex;
scom.Parameters.Add("@PrerairedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.PrerairedBy;
scom.Parameters.Add("@Checked", SqlDbType.Int, 4).Value = t_InvoiceHed.Checked;
scom.Parameters.Add("@CheckedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CheckedBy;
scom.Parameters.Add("@Approved", SqlDbType.Int, 4).Value = t_InvoiceHed.Approved;
scom.Parameters.Add("@AprrovedBy", SqlDbType.VarChar, 20).Value = t_InvoiceHed.AprrovedBy;
scom.Parameters.Add("@ApprovedDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.ApprovedDate;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 150).Value = t_InvoiceHed.Remarks;
scom.Parameters.Add("@CQNO", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CQNO;
scom.Parameters.Add("@CQDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.CQDate;
scom.Parameters.Add("@BANK", SqlDbType.VarChar, 20).Value = t_InvoiceHed.BANK;
scom.Parameters.Add("@BRANCH", SqlDbType.VarChar, 20).Value = t_InvoiceHed.BRANCH;
scom.Parameters.Add("@Processed", SqlDbType.Int, 4).Value = t_InvoiceHed.Processed;
scom.Parameters.Add("@ProcessedDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.ProcessedDate;
scom.Parameters.Add("@ProcessedUser", SqlDbType.VarChar, 20).Value = t_InvoiceHed.ProcessedUser;
scom.Parameters.Add("@Glupdated", SqlDbType.Bit, 1).Value = t_InvoiceHed.Glupdated;
scom.Parameters.Add("@MultipleDO", SqlDbType.Int, 4).Value = t_InvoiceHed.MultipleDO;
scom.Parameters.Add("@DueAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.DueAmt;
scom.Parameters.Add("@PaidAmt", SqlDbType.Decimal, 9).Value = t_InvoiceHed.PaidAmt;
scom.Parameters.Add("@IsSettled", SqlDbType.Bit, 1).Value = t_InvoiceHed.IsSettled;
scom.Parameters.Add("@Iscancelled", SqlDbType.Bit, 1).Value = t_InvoiceHed.Iscancelled;
scom.Parameters.Add("@CancelledDate", SqlDbType.DateTime, 8).Value = t_InvoiceHed.CancelledDate;
scom.Parameters.Add("@CancelledUSer", SqlDbType.VarChar, 20).Value = t_InvoiceHed.CancelledUSer;
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_OrderTracking table.
/// </summary>
public Boolean Savet_OrderTrackingSP(T_OrderTracking t_OrderTracking, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "T_OrderTrackingSave";
scom.Parameters.Add("@OFNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFNo;
scom.Parameters.Add("@CompCode", SqlDbType.VarChar, 20).Value = t_OrderTracking.CompCode;
scom.Parameters.Add("@LocaCode", SqlDbType.VarChar, 20).Value = t_OrderTracking.LocaCode;
scom.Parameters.Add("@Customer", SqlDbType.VarChar, 20).Value = t_OrderTracking.Customer;
scom.Parameters.Add("@CustomerDIscRate", SqlDbType.Decimal, 9).Value = t_OrderTracking.CustomerDIscRate;
scom.Parameters.Add("@SalesMan", SqlDbType.VarChar, 20).Value = t_OrderTracking.SalesMan;
scom.Parameters.Add("@OFApproved", SqlDbType.Int, 4).Value = t_OrderTracking.OFApproved;
scom.Parameters.Add("@OFApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFApprovedUser;
scom.Parameters.Add("@OFApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.OFApprovedDate;
scom.Parameters.Add("@OFNoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.OFNoOfPrints;
scom.Parameters.Add("@OFPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.OFPrintUser;
scom.Parameters.Add("@InvCreated", SqlDbType.Int, 4).Value = t_OrderTracking.InvCreated;
scom.Parameters.Add("@InvNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvNo;
scom.Parameters.Add("@InvAmount", SqlDbType.Decimal, 9).Value = t_OrderTracking.InvAmount;
scom.Parameters.Add("@InvApproved", SqlDbType.Int, 4).Value = t_OrderTracking.InvApproved;
scom.Parameters.Add("@InvApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvApprovedUser;
scom.Parameters.Add("@InvApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.InvApprovedDate;
scom.Parameters.Add("@InvNoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.InvNoOfPrints;
scom.Parameters.Add("@InvPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.InvPrintUser;
scom.Parameters.Add("@DOCreated", SqlDbType.Int, 4).Value = t_OrderTracking.DOCreated;
scom.Parameters.Add("@DONo", SqlDbType.VarChar, 20).Value = t_OrderTracking.DONo;
scom.Parameters.Add("@DOAmount", SqlDbType.Decimal, 9).Value = t_OrderTracking.DOAmount;
scom.Parameters.Add("@DOMultipleNO", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOMultipleNO;
scom.Parameters.Add("@DOProcessed", SqlDbType.Int, 4).Value = t_OrderTracking.DOProcessed;
scom.Parameters.Add("@DOProcessedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOProcessedUser;
scom.Parameters.Add("@DOProcessedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DOProcessedDate;
scom.Parameters.Add("@DOApproved", SqlDbType.Int, 4).Value = t_OrderTracking.DOApproved;
scom.Parameters.Add("@DOApprovedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOApprovedUser;
scom.Parameters.Add("@DOApprovedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DOApprovedDate;
scom.Parameters.Add("@DONoOfPrints", SqlDbType.Decimal, 9).Value = t_OrderTracking.DONoOfPrints;
scom.Parameters.Add("@DOvPrintUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DOvPrintUser;
scom.Parameters.Add("@Audited", SqlDbType.Int, 4).Value = t_OrderTracking.Audited;
scom.Parameters.Add("@AuditDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.AuditDate;
scom.Parameters.Add("@AuditUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.AuditUser;
scom.Parameters.Add("@Dispatched", SqlDbType.Int, 4).Value = t_OrderTracking.Dispatched;
scom.Parameters.Add("@DispatchedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.DispatchedDate;
scom.Parameters.Add("@DispatchedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.DispatchedUser;
scom.Parameters.Add("@Handedover", SqlDbType.Int, 4).Value = t_OrderTracking.Handedover;
scom.Parameters.Add("@HandedoverUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.HandedoverUser;
scom.Parameters.Add("@HandedoverDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.HandedoverDate;
scom.Parameters.Add("@Completed", SqlDbType.Int, 4).Value = t_OrderTracking.Completed;
scom.Parameters.Add("@CompletedUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.CompletedUser;
scom.Parameters.Add("@CompletedDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.CompletedDate;
scom.Parameters.Add("@PackingListCreated", SqlDbType.Int, 4).Value = t_OrderTracking.PackingListCreated;
scom.Parameters.Add("@PackingListNo", SqlDbType.VarChar, 20).Value = t_OrderTracking.PackingListNo;
scom.Parameters.Add("@PackingListDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.PackingListDate;
scom.Parameters.Add("@PackingListUser", SqlDbType.VarChar, 20).Value = t_OrderTracking.PackingListUser;
scom.Parameters.Add("@Remarks", SqlDbType.VarChar, 250).Value = t_OrderTracking.Remarks;
scom.Parameters.Add("@HandOverLorry", SqlDbType.VarChar, 20).Value = t_OrderTracking.HandOverLorry;
scom.Parameters.Add("@CompleteRemark", SqlDbType.VarChar, 250).Value = t_OrderTracking.CompleteRemark;
scom.Parameters.Add("@OrderDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.OrderDate;
scom.Parameters.Add("@InvoiceDate", SqlDbType.DateTime, 8).Value = t_OrderTracking.InvoiceDate;
scom.Parameters.Add("@Dodate", SqlDbType.DateTime, 8).Value = t_OrderTracking.Dodate;
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);
}
}
