//update public bool UpdateStype(eSunSpeedDomain.SaleTypeModel objStype) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@SalesType", objStype.SalesType)); paramCollection.Add(new DBParameter("@typeSpecifyHereSingleAccount", objStype.typeSpecifyHereSingleAccount)); paramCollection.Add(new DBParameter("@LedgerAccountBox", objStype.LedgerAccountBox)); paramCollection.Add(new DBParameter("@typeDifferentTaxRate", objStype.typeDifferentTaxRate, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeSpecifyINVoucher", objStype.typeSpecifyINVoucher, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxable", objStype.typeTaxable, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeMultiTax", objStype.typeMultiTax, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeAgainstSTFrom", objStype.typeAgainstSTFrom, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxpaid", objStype.typeTaxpaid, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeExempt", objStype.typeExempt, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxFree", objStype.typeTaxFree, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeLUMSumDealer", objStype.typeLUMSumDealer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeUnRegDealer", objStype.typeUnRegDealer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxInvoice", objStype.TaxInvoice, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@VatReturnCategory", objStype.VatReturnCategory)); paramCollection.Add(new DBParameter("@VatSaleTaxReport", objStype.VatSaleTaxReport, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@CalculateTaxonItemMRP", objStype.CalculateTaxonItemMRP, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxInclusiveItemPrice", objStype.TaxInclusiveItemPrice, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@CalculateTaxonpercentofAmount", objStype.CalculateTaxonpercentofAmount)); paramCollection.Add(new DBParameter("@AdjustTaxinSaleAccount", objStype.AdjustTaxinSaleAccount, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxAccount", objStype.TaxAccount)); paramCollection.Add(new DBParameter("@TypeLocal", objStype.TypeLocal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeCentral", objStype.TypeCentral, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeStockTransfer", objStype.TypeStockTransfer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeOther", objStype.TypeOther, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ExportNormal", objStype.ExportNormal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SaleinTransit", objStype.SaleinTransit, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ExportHighsea", objStype.ExportHighsea, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@IssueSTFrom", objStype.IssueSTFrom, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@FromIssuable", objStype.FromIssuable)); paramCollection.Add(new DBParameter("@ReceiveSTForm", objStype.ReceiveSTForm, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ST_ID", objStype.Sale_Id)); Query = "UPDATE SaleType SET [SalesType]=@SalesType,[typeSpecifyHereSingleAccount]=@typeSpecifyHereSingleAccount,[LedgerAccountBox]=@LedgerAccountBox,[typeDifferentTaxRate]=@typeDifferentTaxRate,[typeSpecifyINVoucher]=@typeSpecifyINVoucher,[typeTaxable]=@typeTaxable," + "[tyypeMultiTax]=@typeMultiTax,[typeAgainstSTFrom]=@typeAgainstSTFrom,[typeTaxpaid]=@typeTaxpaid,[typeExempt]=@typeExempt," + "[typeTaxFree]=@typeTaxFree,[typeLUMSumDealer]=@typeLUMSumDealer,[typeUnRegDealer]=@typeUnRegDealer,[TaxInvoice]=@TaxInvoice,[VatReturnCategory]=@VatReturnCategory,[VatSaleTaxReport]=@VatSaleTaxReport,[CalculateTaxonItemMRP]=@CalculateTaxonItemMRP,[TaxInclusiveItemPrice]=@TaxInclusiveItemPrice,[CalculateTaxonpercentofAmount]=@CalculateTaxonpercentofAmount,[AdjustTaxinSaleAccount]=@AdjustTaxinSaleAccount,[TaxAccount]=@TaxAccount,[TypeLocal]=@TypeLocal," + "[TypeCentral]=@TypeCentral,[TypeStockTransfer]=@TypeStockTransfer,[TypeOther]=@TypeOther,[ExportNormal]=@ExportNormal,[SaleinTransit]=@SaleinTransit," + "[ExportHighsea]=@ExportHighsea,[IssueSTFrom]=@IssueSTFrom,[FromIssuable]=@FromIssuable,[ReceiveSTForm]=@ReceiveSTForm " + "WHERE [Id]=@ST_ID"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdate = true; } } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }
//update Sale Type Master public bool UpdateSalestype(eSunSpeedDomain.SaleTypeModel objStype) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@SalesType", objStype.SalesType)); paramCollection.Add(new DBParameter("@typeSpecifyHereSingleAccount", objStype.typeSpecifyHereSingleAccount, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@LedgerAccountBox", objStype.LedgerAccountBox)); paramCollection.Add(new DBParameter("@typeDifferentTaxRate", objStype.typeDifferentTaxRate, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeSpecifyINVoucher", objStype.typeSpecifyINVoucher, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxable", objStype.typeTaxable, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@tyypeMultiTax", objStype.typeMultiTax, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeAgainstSTFrom", objStype.typeAgainstSTFrom, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxpaid", objStype.typeTaxpaid, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeExempt", objStype.typeExempt, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeTaxFree", objStype.typeTaxFree, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeLUMSumDealer", objStype.typeLUMSumDealer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@typeUnRegDealer", objStype.typeUnRegDealer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxInvoice", objStype.TaxInvoice, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@VatReturnCategory", objStype.VatReturnCategory)); paramCollection.Add(new DBParameter("@VatSaleTaxReport", objStype.VatSaleTaxReport, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@CalculateTaxonItemMRP", objStype.CalculateTaxonItemMRP, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxInclusiveItemPrice", objStype.TaxInclusiveItemPrice, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@CalculateTaxonpercentofAmount", objStype.CalculatedTax)); paramCollection.Add(new DBParameter("@AdjustTaxinSaleAccount", objStype.AdjustTaxinSaleAccount, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxAccount", objStype.TaxAccount)); paramCollection.Add(new DBParameter("@SkipVatorSaleTaxReport", objStype.SkipVatorSaleTaxReport, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeLocal", objStype.TypeLocal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeCentral", objStype.TypeCentral, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeStockTransfer", objStype.TypeStockTransfer, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TypeOther", objStype.TypeOther, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ExportNormal", objStype.ExportNormal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SaleinTransit", objStype.SaleinTransit, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ExportHighsea", objStype.ExportHighsea, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@SingleTaxRate", objStype.SingleTaxRate, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@MultiTaxRate", objStype.MultiTaxRate, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@TaxinPercentage", objStype.TaxinPercentage, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@SurchargeInPercentage", objStype.SurchargeInPercentage, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@freezeTaxinSales", objStype.freezeTaxinSales, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@freezeTaxinSalesReturn", objStype.freezeTaxinSalesReturn, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@IssueSTFrom", objStype.IssueSTFrom, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@FromIssuable", objStype.FromIssuable)); paramCollection.Add(new DBParameter("@ReceiveSTForm", objStype.ReceiveSTForm, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@FormReceivable", objStype.FromReceivable)); paramCollection.Add(new DBParameter("@InvoiceHeading", objStype.InvoiceHeading)); paramCollection.Add(new DBParameter("@InvoiceDescription", objStype.InvoiceDescription)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@SalesTypeId", objStype.Sale_Id)); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spUpdateSaleTypeMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); isUpdate = true; } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }