public long insertTargetProductDA(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("SRID", boaddemp.SRID1);
ht.Add("TargetMonth", boaddemp.TargetMonth1);
ht.Add("TargetYear", boaddemp.TargetYear1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("SalesTargetQty", boaddemp.SalesTargetQty1);
ht.Add("EntryID", boaddemp.EntryID1);
ht.Add("EntryDate", boaddemp.EntryDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertSalesTargetProduct")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long insertInvoiceReturnMaster(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("ReturnID", boaddemp.ReturnID1);
ht.Add("ReturnDate", boaddemp.InvoiceDate1);
ht.Add("InvoiceID", boaddemp.InvoiceID1);
ht.Add("ReturnAmount", boaddemp.Returnamount);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("IsApprove", boaddemp.IsApprove1);
ht.Add("ApprovedBy", boaddemp.ApprovedBy1);
ht.Add("ApproveComments", boaddemp.ApproveComments1);
ht.Add("ApproveDate", boaddemp.ApproveDate1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
ht.Add("SIMonth", boaddemp.SIMonth1);
ht.Add("SIYear", boaddemp.SIYear1);
ht.Add("InvoiceIDSerial", boaddemp.InvoiceIDSerial1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertInvoiceReturnMaster")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long InsertDiscountMasterDA(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("DiscountID", boaddemp.OfferID1);
ht.Add("DiscountName", boaddemp.OfferName1);
ht.Add("StarDate", boaddemp.StarDate1);
ht.Add("EndDate", boaddemp.EndDate1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertDiscountMaster")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long InsertCombinationOfferMasterDA(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("SNID", boaddemp.SNID1);
ht.Add("OfferID", boaddemp.OfferID1);
ht.Add("OfferName", boaddemp.OfferName1);
ht.Add("StarDate", boaddemp.StarDate1);
ht.Add("EndDate", boaddemp.EndDate1);
ht.Add("DTID", boaddemp.DTID1);
ht.Add("DMID", boaddemp.DMID1);
ht.Add("MinValue", boaddemp.MinValue1);
ht.Add("MaxValue", boaddemp.MaxValue1);
ht.Add("OfferValue", boaddemp.OfferValue1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
ht.Add("MultiPlyQy", boaddemp.MultiPlyQy1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertCombinationOfferMaster")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long InsertDiscountDetailDA(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("DiscountID", boaddemp.OfferID1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("DTID", boaddemp.DTID1);
ht.Add("DMID", boaddemp.DMID1);
ht.Add("MinValue", boaddemp.MinValue1);
ht.Add("MaxValue", boaddemp.MaxValue1);
ht.Add("DiscountValue", boaddemp.OfferValue1);
ht.Add("StarDate", boaddemp.StarDate1);
ht.Add("EndDate", boaddemp.EndDate1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertDiscountDetail")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long insertInvoiceReturn(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("InvoiceID", boaddemp.InvoiceID1);
ht.Add("InvoiceDate", boaddemp.InvoiceDate1);
ht.Add("ReturnDate", boaddemp.ReturnDate1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("Quantity", boaddemp.Quantity1);
ht.Add("Rate", boaddemp.Rate1);
ht.Add("Total", boaddemp.Total1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("IsApprove", boaddemp.IsApprove1);
ht.Add("ReturnQuantity", boaddemp.ReturnQty1);
ht.Add("DamageQuantity", boaddemp.DamageQTY1);
// ht.Add("DisReturnQuantity", boaddemp.DiscReturnQTy1 );
return(Convert.ToInt32(idb.InsertData(ht, "spInsertInvoiceReturn")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long insertInvoiceDetailVAT(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("InvoiceID", boaddemp.InvoiceID1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("Quantity", boaddemp.Quantity1);
ht.Add("Rate", boaddemp.Rate1);
ht.Add("Total", boaddemp.Total1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("IsApprove", boaddemp.IsApprove1);
ht.Add("DiscountQuantity", boaddemp.DiscountQTy1);
ht.Add("DiscountPercent", boaddemp.DiscountPercent1);
ht.Add("DiscountAmount", boaddemp.DiscountAmount1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertInvoiceDetailVAT")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long InsertCombinationProductAmountDA(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("OfferID", boaddemp.OfferID1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("MinValue", boaddemp.MinValue1);
ht.Add("MaxValue", boaddemp.MaxValue1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertCombinationPrdAmnt")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long insertCombinationCalculationDA_View(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("SMSID", boaddemp.SMSID1);
ht.Add("ProductID", boaddemp.ProductID1);
ht.Add("Quantity", boaddemp.Quantity1);
ht.Add("OfferID", boaddemp.OfferID1);
return(Convert.ToInt32(idb.InsertData(ht, "spCombinationCalculation_View")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public long insertInvoiceMaster_View(BOSalesInvoicecs boaddemp)
{
try
{
var ht = new Hashtable();
ht.Add("InvoiceID", boaddemp.InvoiceID1);
ht.Add("InvoiceDate", boaddemp.InvoiceDate1);
ht.Add("CompanyID", boaddemp.CompanyID1);
ht.Add("ClientID", boaddemp.ClientID1);
ht.Add("SalesInitiatorID", boaddemp.SalesInitiatorID1);
ht.Add("Remarks", boaddemp.Remarks1);
ht.Add("InvoiceType", boaddemp.InvoiceType1);
ht.Add("IsActive", boaddemp.IsActive1);
ht.Add("IsApprove", boaddemp.IsApprove1);
ht.Add("ApprovedBy", boaddemp.ApprovedBy1);
ht.Add("ApproveComments", boaddemp.ApproveComments1);
ht.Add("ApproveDate", boaddemp.ApproveDate1);
ht.Add("CreatedBy", boaddemp.CreatedBy1);
ht.Add("CreatedDate", boaddemp.CreatedDate1);
ht.Add("UpdateID", boaddemp.UpdateID1);
ht.Add("UpdateDate", boaddemp.UpdateDate1);
ht.Add("SIMonth", boaddemp.SIMonth1);
ht.Add("SIYear", boaddemp.SIYear1);
ht.Add("InvoiceIDSerial", boaddemp.InvoiceIDSerial1);
ht.Add("VatPercent", boaddemp.VatPercent1);
ht.Add("DiscountAmount", boaddemp.DiscountAmount1);
ht.Add("NetAmount", boaddemp.NetAmount1);
ht.Add("DiscountPercent", boaddemp.DiscountPercent1);
return(Convert.ToInt32(idb.InsertData(ht, "spInsertInvoiceMaster_View")));
}
catch (Exception ex)
{
// Alert.Show(ex.Message);
throw ex;
}
}
public static long insertTargetProductBL(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.insertTargetProductDA(grrbo)));
}
public static long InsertDiscountDetailBL(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.InsertDiscountDetailDA(grrbo)));
}
public static long InsertCombinationAwardBL(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.InsertCombinationAwardDA(grrbo)));
}
public static long insertInvoiceReturnMaster(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.insertInvoiceReturnMaster(grrbo)));
}
public static long InsertCombinationOfferMasterAmountBL(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.InsertCombinationOfferMasterAmountDA(grrbo)));
}
public static long insertInvoiceDetailSupli(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.insertInvoiceDetailSuppli(grrbo)));
}
public static long insertCombinationCalculationBL_View(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.insertCombinationCalculationDA_View(grrbo)));
}
public static long insertPurchaseDetailBL(BOSalesInvoicecs grrbo)
{
DASalesInvoice daaddemp = new DASalesInvoice();
return(Convert.ToInt64(daaddemp.insertPurchaseDetailDA(grrbo)));
}