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