//List Of Sale Type By Id
public SaleTypeModel GetAllSaleTypeBySaleName(int Salesid)
{
SaleTypeModel objSaleModel = new SaleTypeModel();
string Query = "SELECT * FROM saletypemaster WHERE Sales_Id='" + Salesid + "'";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objSaleModel = new SaleTypeModel();
objSaleModel.Sale_Id = Convert.ToInt32(dr["Sales_Id"]);
objSaleModel.SalesType = dr["SalesType"].ToString();
objSaleModel.typeSpecifyHereSingleAccount = Convert.ToBoolean(dr["typeSpecifyHereSingleAccount"]);
objSaleModel.LedgerAccountBox = dr["LedgerAccountBox"].ToString();
objSaleModel.typeDifferentTaxRate = Convert.ToBoolean(dr["typeDifferentTaxRate"]);
objSaleModel.typeSpecifyINVoucher = Convert.ToBoolean(dr["typeSpecifyINVoucher"]);
objSaleModel.typeTaxable = Convert.ToBoolean(dr["typeTaxable"]);
objSaleModel.typeMultiTax = Convert.ToBoolean(dr["tyypeMultiTax"]);
objSaleModel.typeAgainstSTFrom = Convert.ToBoolean(dr["typeAgainstSTFrom"]);
objSaleModel.typeTaxpaid = Convert.ToBoolean(dr["typeTaxpaid"]);
objSaleModel.typeExempt = Convert.ToBoolean(dr["typeExempt"]);
objSaleModel.typeTaxFree = Convert.ToBoolean(dr["typeTaxFree"]);
objSaleModel.typeLUMSumDealer = Convert.ToBoolean(dr["typeLUMSumDealer"]);
objSaleModel.typeUnRegDealer = Convert.ToBoolean(dr["typeUnRegDealer"]);
objSaleModel.TaxInvoice = Convert.ToBoolean(dr["TaxInvoice"]);
objSaleModel.VatReturnCategory = dr["VatReturnCategory"].ToString();
objSaleModel.VatSaleTaxReport = Convert.ToBoolean(dr["VatSaleTaxReport"]);
objSaleModel.CalculateTaxonItemMRP = Convert.ToBoolean(dr["CalculateTaxonItemMRP"]);
objSaleModel.TaxInclusiveItemPrice = Convert.ToBoolean(dr["TaxInclusiveItemPrice"]);
objSaleModel.CalculateTaxonpercentofAmount = Convert.ToDecimal(dr["CalculateTaxonpercentofAmount"]);
objSaleModel.AdjustTaxinSaleAccount = Convert.ToBoolean(dr["AdjustTaxinSaleAccount"]);
objSaleModel.TaxAccount = dr["TaxAccount"].ToString();
objSaleModel.TypeLocal = Convert.ToBoolean(dr["TypeLocal"]);
objSaleModel.TypeCentral = Convert.ToBoolean(dr["TypeCentral"]);
objSaleModel.TypeStockTransfer = Convert.ToBoolean(dr["TypeStockTransfer"]);
objSaleModel.TypeOther = Convert.ToBoolean(dr["TypeOther"]);
objSaleModel.ExportNormal = Convert.ToBoolean(dr["ExportNormal"]);
objSaleModel.SaleinTransit = Convert.ToBoolean(dr["SaleinTransit"]);
objSaleModel.ExportHighsea = Convert.ToBoolean(dr["ExportHighsea"]);
objSaleModel.IssueSTFrom = Convert.ToBoolean(dr["IssueSTFrom"]);
objSaleModel.FromIssuable = dr["FromIssuable"].ToString();
objSaleModel.ReceiveSTForm = Convert.ToBoolean(dr["ReceiveSTForm"]);
objSaleModel.FromReceivable = dr["FormReceivable"].ToString();
objSaleModel.SingleTaxRate = Convert.ToBoolean(dr["SingleTaxRate"]);
objSaleModel.MultiTaxRate = Convert.ToBoolean(dr["MultiTaxRate"]);
objSaleModel.TaxinPercentage = Convert.ToDecimal(dr["TaxinPercentage"]);
objSaleModel.SurchargeInPercentage = Convert.ToDecimal(dr["SurchargeInPercentage"]);
objSaleModel.freezeTaxinSales = Convert.ToBoolean(dr["freezeTaxinSales"]);
objSaleModel.freezeTaxinSalesReturn = Convert.ToBoolean(dr["freezeTaxinSalesReturn"]);
objSaleModel.InvoiceHeading = dr["InvoiceHeading"].ToString();
objSaleModel.InvoiceDescription = dr["InvoiceDescription"].ToString();
objSaleModel.SkipVatorSaleTaxReport = Convert.ToBoolean(dr["SkipVatorSaleTaxReport"]);
}
return(objSaleModel);
}
public List <eSunSpeedDomain.SaleTypeModel> GetAllSaleType()
{
List <eSunSpeedDomain.SaleTypeModel> lstSaleType = new List <SaleTypeModel>();
eSunSpeedDomain.SaleTypeModel objSaleType;
string Query = "SELECT * FROM SaleType";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
//Is
//Enable
while (dr.Read())
{
objSaleType = new SaleTypeModel();
objSaleType.Sale_Id = Convert.ToInt32(dr["Id"]);
objSaleType.SalesType = dr["SalesType"].ToString();
objSaleType.typeSpecifyHereSingleAccount = Convert.ToBoolean(dr["typeSpecifyHereSingleAccount"]);
objSaleType.LedgerAccountBox = dr["LedgerAccountBox"].ToString();
objSaleType.typeDifferentTaxRate = Convert.ToBoolean(dr["typeDifferentTaxRate"]);
objSaleType.typeSpecifyINVoucher = Convert.ToBoolean(dr["typeSpecifyINVoucher"]);
objSaleType.typeTaxable = Convert.ToBoolean(dr["typeTaxable"]);
objSaleType.typeMultiTax = Convert.ToBoolean(dr["tyypeMultiTax"]);
objSaleType.typeAgainstSTFrom = Convert.ToBoolean(dr["typeAgainstSTFrom"]);
objSaleType.typeTaxpaid = Convert.ToBoolean(dr["typeTaxpaid"]);
objSaleType.typeExempt = Convert.ToBoolean(dr["typeExempt"]);
objSaleType.typeTaxFree = Convert.ToBoolean(dr["typeTaxFree"]);
objSaleType.typeLUMSumDealer = Convert.ToBoolean(dr["typeLUMSumDealer"]);
objSaleType.typeUnRegDealer = Convert.ToBoolean(dr["typeUnRegDealer"]);
objSaleType.TaxInvoice = Convert.ToBoolean(dr["TaxInvoice"]);
objSaleType.VatReturnCategory = dr["VatReturnCategory"].ToString();
objSaleType.VatSaleTaxReport = Convert.ToBoolean(dr["VatSaleTaxReport"]);
objSaleType.CalculateTaxonItemMRP = Convert.ToBoolean(dr["CalculateTaxonItemMRP"]);
objSaleType.TaxInclusiveItemPrice = Convert.ToBoolean(dr["TaxInclusiveItemPrice"]);
objSaleType.CalculateTaxonpercentofAmount = Convert.ToDecimal(dr["CalculateTaxonpercentofAmount"]);
objSaleType.AdjustTaxinSaleAccount = Convert.ToBoolean(dr["AdjustTaxinSaleAccount"]);
objSaleType.TaxAccount = dr["VatSaleTaxReport"].ToString();
objSaleType.TypeLocal = Convert.ToBoolean(dr["TypeLocal"]);
objSaleType.TypeCentral = Convert.ToBoolean(dr["TypeCentral"]);
lstSaleType.Add(objSaleType);
}
return(lstSaleType);
}
private void btnSave_Click(object sender, EventArgs e)
{
objSaleModel = new SaleTypeModel();
if (tbxSaleType.Text.Equals(string.Empty))
{
MessageBox.Show("Sales Type can not be blank!");
tbxSaleType.Focus();
return;
}
objSaleModel.SalesType = tbxSaleType.Text.Trim();
//this GroupBox for sales Account Information of RadioButton
objSaleModel.typeSpecifyHereSingleAccount = rbngrpSalesAcInf.SelectedIndex == 0?true:false;
if (objSaleModel.typeSpecifyHereSingleAccount)
{
objSaleModel.LedgerAccountBox = cbxLedgerAccount.Text.Trim() == null ? string.Empty : cbxLedgerAccount.Text.Trim();
}
objSaleModel.typeDifferentTaxRate = rbngrpSalesAcInf.SelectedIndex == 1?true:false;
objSaleModel.typeSpecifyINVoucher = rbngrpSalesAcInf.SelectedIndex == 2?true:false;
//TaxationType: RadioButton Group
if (rbngrpTaxation.SelectedIndex == 0)
{
objSaleModel.typeTaxable = true;
}
if (rbngrpTaxation.SelectedIndex == 1)
{
objSaleModel.typeAgainstSTFrom = true;
}
if (rbngrpTaxation.SelectedIndex == 2)
{
objSaleModel.typeExempt = true;
}
if (rbngrpTaxation.SelectedIndex == 3)
{
objSaleModel.typeLUMSumDealer = true;
}
if (rbngrpTaxation.SelectedIndex == 4)
{
objSaleModel.typeMultiTax = true;
}
if (rbngrpTaxation.SelectedIndex == 5)
{
objSaleModel.typeTaxpaid = true;
}
if (rbngrpTaxation.SelectedIndex == 6)
{
objSaleModel.typeTaxFree = true;
}
if (rbngrpTaxation.SelectedIndex == 7)
{
objSaleModel.typeUnRegDealer = true;
}
//Region Radio Button GroupBox
if (rbngrpRegion.SelectedIndex == 0)
{
objSaleModel.TypeLocal = true;
}
if (rbngrpRegion.SelectedIndex == 1)
{
objSaleModel.TypeCentral = true;
}
//other Information Group
if (objSaleModel.typeTaxable)
{
if (objSaleModel.TypeLocal)
{
objSaleModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objSaleModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objSaleModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objSaleModel.typeMultiTax)
{
if (objSaleModel.TypeLocal)
{
objSaleModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objSaleModel.CalculateTaxonItemMRP = cbxTaxonItemmrp.SelectedItem.ToString().Equals("Y") ? true : false;
objSaleModel.TaxInclusiveItemPrice = cbxTaxInclItemPrice.SelectedItem.ToString().Equals("Y") ? true : false;
objSaleModel.CalculatedTax = Convert.ToDecimal(tbxCalculatedtax.Text.Trim() == string.Empty ? "0.00" : tbxCalculatedtax.Text.Trim());
objSaleModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objSaleModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
objSaleModel.AdjustTaxinSaleAccount = cbxAdTaxinSaleAmt.SelectedItem.ToString().Equals("Y") ? true : false;
if (objSaleModel.typeDifferentTaxRate == false)
{
objSaleModel.TaxAccount = cbxTaxAccount.SelectedItem.ToString();
}
}
if (objSaleModel.typeAgainstSTFrom)
{
if (objSaleModel.TypeLocal)
{
objSaleModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objSaleModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objSaleModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
if (objSaleModel.typeAgainstSTFrom)
{
objSaleModel.IssueSTFrom = cbxIssueSTform.SelectedItem.ToString().Equals("Y") ? true : false;
if (objSaleModel.IssueSTFrom)
{
objSaleModel.FromIssuable = cbxFormIssuable.SelectedItem.ToString();
}
objSaleModel.ReceiveSTForm = cbxIssueSTform.SelectedItem.ToString().Equals("Y") ? true : false;
if (objSaleModel.IssueSTFrom)
{
objSaleModel.FromReceivable = cbxFormIssuable.SelectedItem.ToString();
}
}
objSaleModel.TaxinPercentage = Convert.ToDecimal(tbxTaxPer.Text.Trim() == string.Empty ? "0.00" : tbxTaxPer.Text.Trim());
objSaleModel.SurchargeInPercentage = Convert.ToDecimal(tbxSurchargePer.Text.Trim() == string.Empty ? "0.00" : tbxSurchargePer.Text.Trim());
objSaleModel.freezeTaxinSales = cbxFreezeTaxinsale.SelectedItem.ToString().Equals("Y") ? true : false;
objSaleModel.freezeTaxinSalesReturn = cbxFreezeTaxinSaleReturn.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objSaleModel.typeTaxpaid || objSaleModel.typeExempt || objSaleModel.typeTaxFree)
{
objSaleModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objSaleModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
}
//if Enable MultiTax Will Show on other Information Group
//Tax Calculation
objSaleModel.SingleTaxRate = rbngrpTaxcalculation.SelectedIndex == 0 ? true : false;
objSaleModel.MultiTaxRate = rbngrpTaxcalculation.SelectedIndex == 1? true : false;
if (objSaleModel.SingleTaxRate)
{
objSaleModel.TaxinPercentage = Convert.ToDecimal(tbxTaxPer.Text.Trim() == string.Empty ? "0.00" : tbxTaxPer.Text.Trim());
objSaleModel.SurchargeInPercentage = Convert.ToDecimal(tbxSurchargePer.Text.Trim() == string.Empty ? "0.00" : tbxSurchargePer.Text.Trim());
objSaleModel.freezeTaxinSales = cbxFreezeTaxinsale.SelectedItem.ToString().Equals("Y") ? true : false;
objSaleModel.freezeTaxinSalesReturn = cbxFreezeTaxinSaleReturn.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objSaleModel.MultiTaxRate)
{
if (objSaleModel.typeSpecifyHereSingleAccount)
{
objSaleModel.servicesLedgerBox = cbxServicesAccLedger.SelectedItem.ToString();
}
}
//Type of Transaction on Region GrupBox Sub
objSaleModel.TypeStockTransfer = rbngrpTranction.SelectedIndex == 0 ? true : false;
objSaleModel.ExportNormal = rbngrpTranction.SelectedIndex == 1 ? true : false;
objSaleModel.SaleinTransit = rbngrpTranction.SelectedIndex == 2 ? true : false;
objSaleModel.TypeOther = rbngrpTranction.SelectedIndex == 3? true : false;
objSaleModel.ExportHighsea = rbngrpTranction.SelectedIndex == 4 ? true : false;
objSaleModel.InvoiceHeading = tbxInvoiceHeading.Text.Trim() == null ? string.Empty : tbxInvoiceHeading.Text.Trim();
objSaleModel.InvoiceDescription = tbxInvoiceDescription.Text.Trim() == null ? string.Empty : tbxInvoiceDescription.Text.Trim();
bool isSuccess = objSaleBL.SaveSalesType(objSaleModel);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
tbxSaleType.Focus();
}
}
private void FillSalesTypeInfo()
{
if (SalesId == 0)
{
tbxSaleType.Focus();
laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
return;
}
objSaleModel = objSaleBL.GetAllSaleTypeBySaleName(SalesId);
tbxSaleType.Text = objSaleModel.SalesType.ToString();
if (objSaleModel.typeSpecifyHereSingleAccount)
{
rbngrpSalesAcInf.SelectedIndex = 0;
}
cbxLedgerAccount.Text = objSaleModel.LedgerAccountBox.ToString();
if (objSaleModel.typeDifferentTaxRate)
{
rbngrpSalesAcInf.SelectedIndex = 1;
}
if (objSaleModel.typeSpecifyINVoucher)
{
rbngrpSalesAcInf.SelectedIndex = 2;
}
if (objSaleModel.typeTaxable)
{
rbngrpTaxation.SelectedIndex = 0;
}
if (objSaleModel.typeAgainstSTFrom)
{
rbngrpTaxation.SelectedIndex = 1;
}
if (objSaleModel.typeExempt)
{
rbngrpTaxation.SelectedIndex = 2;
}
if (objSaleModel.typeTaxpaid)
{
rbngrpTaxation.SelectedIndex = 5;
}
if (objSaleModel.typeMultiTax)
{
rbngrpTaxation.SelectedIndex = 4;
}
if (objSaleModel.typeTaxFree)
{
rbngrpTaxation.SelectedIndex = 6;
}
if (objSaleModel.typeLUMSumDealer)
{
rbngrpTaxation.SelectedIndex = 7;
}
if (objSaleModel.typeUnRegDealer)
{
rbngrpTaxation.SelectedIndex = 3;
}
cbxTaxInvoiceyesno.SelectedItem = (objSaleModel.TaxInvoice)?"Y":"N";
cbxVatreturnCategory.SelectedItem = objSaleModel.VatReturnCategory.ToString();
cbxVatorSalesTaxReports.SelectedItem = objSaleModel.SkipVatorSaleTaxReport ? "Y" : "N";
cbxTaxonItemmrp.SelectedItem = objSaleModel.CalculateTaxonItemMRP ? "Y" : "N";
cbxTaxInclItemPrice.SelectedItem = objSaleModel.TaxInclusiveItemPrice ? "Y" : "N";
tbxCalculatedtax.Text = objSaleModel.CalculateTaxonpercentofAmount.ToString();
cbxAdTaxinSaleAmt.SelectedItem = objSaleModel.AdjustTaxinSaleAccount ? "Y" : "N";
cbxTaxAccount.SelectedItem = objSaleModel.TaxAccount.ToString();
if (objSaleModel.TypeLocal)
{
rbngrpRegion.SelectedIndex = 0;
}
if (objSaleModel.TypeCentral)
{
rbngrpRegion.SelectedIndex = 1;
}
if (objSaleModel.TypeStockTransfer)
{
rbngrpTranction.SelectedIndex = 0;
}
if (objSaleModel.TypeOther)
{
rbngrpTranction.SelectedIndex = 3;
}
if (objSaleModel.ExportNormal)
{
rbngrpTranction.SelectedIndex = 1;
}
if (objSaleModel.SaleinTransit)
{
rbngrpTranction.SelectedIndex = 2;
}
if (objSaleModel.ExportHighsea)
{
rbngrpTranction.SelectedIndex = 4;
}
cbxIssueSTform.SelectedItem = objSaleModel.IssueSTFrom?"Y":"N";
cbxFormIssuable.SelectedItem = objSaleModel.FromIssuable.ToString();
cbxRecevieSTForm.SelectedItem = objSaleModel.ReceiveSTForm?"Y":"N";
cbxFormReceviable.SelectedItem = objSaleModel.FromReceivable.ToString();
if (objSaleModel.SingleTaxRate)
{
rbngrpTaxcalculation.SelectedIndex = 0;
}
if (objSaleModel.MultiTaxRate)
{
rbngrpTaxcalculation.SelectedIndex = 1;
}
tbxTaxPer.Text = objSaleModel.TaxinPercentage.ToString();
tbxSurchargePer.Text = objSaleModel.SurchargeInPercentage.ToString();
cbxFreezeTaxinsale.SelectedItem = objSaleModel.freezeTaxinSales?"Y":"N";
cbxFreezeTaxinSaleReturn.SelectedItem = objSaleModel.freezeTaxinSalesReturn?"Y":"N";
tbxInvoiceHeading.Text = objSaleModel.InvoiceHeading.ToString();
tbxInvoiceDescription.Text = objSaleModel.InvoiceDescription.ToString();
laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
tbxSaleType.Focus();
}
public bool SaveStype(SaleTypeModel objStype)
{
string Query = string.Empty;
bool isSaved = 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("@CreatedBy", objStype.CreatedBy));
Query = "INSERT INTO SaleType ([SalesType],[typeSpecifyHereSingleAccount],[LedgerAccountBox],[typeDifferentTaxRate]," +
"[typeSpecifyINVoucher],[typeTaxable],[tyypeMultiTax],[typeAgainstSTFrom],[typeTaxpaid],[typeExempt],[typeTaxFree],[typeLUMSumDealer]," +
"[typeUnRegDealer],[TaxInvoice],[VatReturnCategory],[VatSaleTaxReport],[CalculateTaxonItemMRP],[TaxInclusiveItemPrice], " +
"[CalculateTaxonpercentofAmount],[AdjustTaxinSaleAccount],[TaxAccount],[TypeLocal],[TypeCentral],[TypeStockTransfer],[TypeOther],[ExportNormal], " +
"[SaleinTransit],[ExportHighsea],[IssueSTFrom],[FromIssuable],[ReceiveSTForm])" +
"VALUES(@SalesType,@typeSpecifyHereSingleAccount,@LedgerAccountBox,@typeDifferentTaxRate,@typeSpecifyINVoucher,@typeTaxable, " +
"@typeMultiTax,@typeAgainstSTFrom,@typeTaxpaid,@typeExempt,@typeTaxFree,@typeLUMSumDealer,@typeUnRegDealer,@TaxInvoice,@VatReturnCategory, " +
"@VatSaleTaxReport,@CalculateTaxonItemMRP,@TaxInclusiveItemPrice,@CalculateTaxonpercentofAmount,@AdjustTaxinSaleAccount,@TaxAccount,@TypeLocal, " +
"@TypeCentral,@TypeStockTransfer,@TypeOther,@ExportNormal,@SaleinTransit,@ExportHighsea,@IssueSTFrom,@FromIssuable,@ReceiveSTForm)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public bool SaveSalesType(SaleTypeModel objStype)
{
string Query = string.Empty;
bool isSaved = 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));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertSaleTypeMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isSaved = true;
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
