public string PutData(List <ChallanIn> records, int intChallanID, string strPartyName, string strAddress, DateTime dteDate)
        {
            try
            {
                tblChallanInPutDataTableAdapter    adp  = new tblChallanInPutDataTableAdapter();
                sprInsertStockRegisterTableAdapter adp2 = new sprInsertStockRegisterTableAdapter();

                foreach (var x in records)
                {
                    adp.PutData(intChallanID, strPartyName, strAddress, dteDate, x.strDetails, x.intQuantity, x.strRemarks);
                    adp2.PutBalanceData(1, intChallanID, strPartyName, dteDate, x.strDetails, x.intQuantity, x.strRemarks);
                }

                return("Challan is stocked in Successfully.");
            }
            catch (Exception e)
            {
                return("error");
            }
        }
        public string PutData(List <ChallanOut> records, int intChallanNo, string strPartyName, string strAddress, DateTime dteDate, string strLCNo, DateTime dteLCDate)
        {
            try
            {
                tblChallanOutTableAdapter          adp  = new tblChallanOutTableAdapter();
                sprInsertStockRegisterTableAdapter adp2 = new sprInsertStockRegisterTableAdapter();

                foreach (var x in records)
                {
                    adp.PutData(intChallanNo, strPartyName, strAddress, dteDate, x.strDetails, x.intQuantity, x.strRemarks, x.strPurchNo, x.dtePurchDate, strLCNo, dteLCDate);
                    adp2.PutBalanceData(2, intChallanNo, strPartyName, dteDate, x.strDetails, x.intQuantity, x.strRemarks);
                }

                return("Challan is created Successfully.");
            }
            catch (Exception e)
            {
                return("error");
            }
        }
示例#3
0
        public string PutData(DateTime dteProductionDate, string strRowMet, double decRowMet, string strRemarkRow, List <NewProduct> records)
        {
            try
            {
                insertIntoProductionTableAdapter   adp  = new insertIntoProductionTableAdapter();
                sprInsertStockRegisterTableAdapter adp2 = new sprInsertStockRegisterTableAdapter();

                adp.InsertIntoProduction(dteProductionDate, strRowMet, decRowMet, strRemarkRow, "OUT");
                adp2.PutBalanceData(4, 50, "Production", dteProductionDate, strRowMet, Convert.ToInt32(decRowMet), strRemarkRow);
                foreach (var x in records)
                {
                    adp.InsertIntoProduction(dteProductionDate, x.strDetails, x.intQuantity, x.strRemark, "IN");
                    adp2.PutBalanceData(3, 50, "Production", dteProductionDate, x.strDetails, x.intQuantity, x.strRemark);
                }

                return("Bill is created successfully.");
            }
            catch (Exception e)
            {
                return("error");
            }
        }