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