public long insert_Sales_return_Detail_DA(BOSalesInvoiceNew objItem) { try { Hashtable ht = new Hashtable(); ht.Add("DCNO", objItem.DCNO); ht.Add("DCDate", objItem.DCDATE); ht.Add("InvoiceID", objItem.InvoiceID); ht.Add("ClientID", objItem.ClientID); ht.Add("ProductID", objItem.ProductID); ht.Add("Quantity", objItem.Quantity); ht.Add("ReturnQTY", objItem.ReturnQTY); ht.Add("IsActive", objItem.IsActive); ht.Add("IsApprove", objItem.IsApprove); return(Convert.ToInt32(idb.InsertData(ht, "spInsertSalesReturnDetail"))); } catch (Exception ex) { // Alert.Show(ex.Message); throw ex; } }
public long insertInvoiceMaster(BOSalesInvoiceNew objItem) { try { Hashtable ht = new Hashtable(); ht.Add("InvoiceID", objItem.InvoiceID); ht.Add("InvoiceDate", objItem.InvoiceDate); ht.Add("CompanyID", objItem.CompanyID); ht.Add("ClientID", objItem.ClientID); ht.Add("SalesInitiatorID", objItem.SalesInitiatorID); ht.Add("Remarks", objItem.Remarks); ht.Add("InvoiceType", objItem.InvoiceType); ht.Add("IsActive", objItem.IsActive); ht.Add("IsApprove", objItem.IsApprove); ht.Add("ApprovedBy", objItem.ApprovedBy); ht.Add("ApproveComments", objItem.ApproveComments); ht.Add("ApproveDate", objItem.ApproveDate); ht.Add("CreatedBy", objItem.CreatedBy); ht.Add("CreatedDate", objItem.CreatedDate); ht.Add("UpdateID", objItem.UpdateID); ht.Add("UpdateDate", objItem.UpdateDate); ht.Add("SIMonth", objItem.SIMonth); ht.Add("SIYear", objItem.SIYear); ht.Add("InvoiceIDSerial", objItem.InvoiceIDSerial); ht.Add("VatPercent", objItem.VatPercent); ht.Add("DiscountAmount", objItem.DiscountAmount); ht.Add("NetAmount", objItem.NetAmount); ht.Add("ReturnAmount", objItem.ReturnAmount); ht.Add("DamageAmount", objItem.DamageAmount); ht.Add("DiscountPercent", objItem.DiscountPercent); ht.Add("IsSalesApproval", objItem.IsSalesApproval); ht.Add("SalesApproveBy", objItem.SalesApproveBy); ht.Add("SalesApproveDate", objItem.SalesApproveDate); ht.Add("IsTransfer", objItem.IsTransfer); ht.Add("TransferNo", objItem.TransferNo); ht.Add("StoreID", objItem.StoreID); ht.Add("IsDC", objItem.IsDC); ht.Add("SalesType", objItem.SalesType); ht.Add("CashAmount", objItem.CashAmount); ht.Add("CardAmount", objItem.CardAmount); ht.Add("ChangeAmount", objItem.ChangeAmount); ht.Add("RecieveAmount", objItem.RecieveAmount); ht.Add("ServiceCharge", objItem.ServiceCharge); ht.Add("DeliveryCharge", objItem.DeliveryCharge); ht.Add("VatAmount", objItem.VatAmount1); return(Convert.ToInt32(idb.InsertData(ht, "spInsertInvoiceMaster"))); } catch (Exception ex) { // Alert.Show(ex.Message); throw ex; } }
public long insert_Sales_return_Master_DA(BOSalesInvoiceNew objItem) { try { Hashtable ht = new Hashtable(); ht.Add("DCNO", objItem.DCNO); ht.Add("DCDATE", objItem.DCDATE); ht.Add("InvoiceID", objItem.InvoiceID); ht.Add("CompanyID", objItem.CompanyID); ht.Add("ClientID", objItem.ClientID); ht.Add("SalesInitiatorID", objItem.SalesInitiatorID); ht.Add("Remarks", objItem.Remarks); ht.Add("InvoiceType", objItem.InvoiceType); ht.Add("IsActive", objItem.IsActive); ht.Add("IsApprove", objItem.IsApprove); ht.Add("ApprovedBy", objItem.ApprovedBy); ht.Add("ApproveComments", objItem.ApproveComments); ht.Add("ApproveDate", objItem.ApproveDate); ht.Add("CreatedBy", objItem.CreatedBy); ht.Add("CreatedDate", objItem.CreatedDate); ht.Add("UpdateID", objItem.UpdateID); ht.Add("UpdateDate", objItem.UpdateDate); ht.Add("SIMonth", objItem.SIMonth); ht.Add("SIYear", objItem.SIYear); ht.Add("DCSerial", objItem.DCSerial); ht.Add("StoreID", objItem.StoreID); ht.Add("GatePassNo", objItem.GatePassNo); ht.Add("VehicleNo", objItem.VehicleNo); ht.Add("DriverName", objItem.DriverName); ht.Add("DeliveryAddress", objItem.DeliveryAddress); return(Convert.ToInt32(idb.InsertData(ht, "spInsertSalesReturnMaster"))); } catch (Exception ex) { // Alert.Show(ex.Message); throw ex; } }
public static long insertInvoiceMasterVAT(BOSalesInvoiceNew grrbo) { DASalesInvoice daaddemp = new DASalesInvoice(); return(Convert.ToInt64(daaddemp.insertInvoiceMasterVAT(grrbo))); }
public static long insertPurchaseMasterBL(BOSalesInvoiceNew grrbo) { DASalesInvoice daaddemp = new DASalesInvoice(); return(Convert.ToInt64(daaddemp.insertPurchaseMasterDA(grrbo))); }
public static long insert_Sales_Detail_BL(BOSalesInvoiceNew grrbo) { DASalesInvoice daaddemp = new DASalesInvoice(); return(Convert.ToInt64(daaddemp.insert_Sales_return_Detail_DA(grrbo))); }