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