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;
        }
    }
Example #11
0
    public static long insertTargetProductBL(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.insertTargetProductDA(grrbo)));
    }
Example #12
0
    public static long InsertDiscountDetailBL(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.InsertDiscountDetailDA(grrbo)));
    }
Example #13
0
    public static long InsertCombinationAwardBL(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.InsertCombinationAwardDA(grrbo)));
    }
Example #14
0
    public static long insertInvoiceReturnMaster(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.insertInvoiceReturnMaster(grrbo)));
    }
Example #15
0
    public static long InsertCombinationOfferMasterAmountBL(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.InsertCombinationOfferMasterAmountDA(grrbo)));
    }
Example #16
0
    public static long insertInvoiceDetailSupli(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.insertInvoiceDetailSuppli(grrbo)));
    }
Example #17
0
    public static long insertCombinationCalculationBL_View(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.insertCombinationCalculationDA_View(grrbo)));
    }
Example #18
0
    public static long insertPurchaseDetailBL(BOSalesInvoicecs grrbo)
    {
        DASalesInvoice daaddemp = new DASalesInvoice();

        return(Convert.ToInt64(daaddemp.insertPurchaseDetailDA(grrbo)));
    }