//List Of Purcchase Type By Id
public PurchaseTypeModel GetAllPurchTypeByPurchId(int Purcid)
{
PurchaseTypeModel objPurcModel = new PurchaseTypeModel();
string Query = "SELECT * FROM purchasetypemaster WHERE Purch_Id='" + Purcid + "'";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objPurcModel = new PurchaseTypeModel();
objPurcModel.Purch_Id = Convert.ToInt32(dr["Purch_Id"]);
objPurcModel.PurchType = dr["PurchaseType"].ToString();
objPurcModel.typeSpecifyHereSingleAccount = Convert.ToBoolean(dr["typeSpecifyHereSingleAccount"]);
objPurcModel.LedgerAccountBox = dr["LedgerAccountBox"].ToString();
objPurcModel.typeDifferentTaxRate = Convert.ToBoolean(dr["typeDifferentTaxRate"]);
objPurcModel.typeSpecifyINVoucher = Convert.ToBoolean(dr["typeSpecifyINVoucher"]);
objPurcModel.typeTaxable = Convert.ToBoolean(dr["typeTaxable"]);
objPurcModel.typeMultiTax = Convert.ToBoolean(dr["tyypeMultiTax"]);
objPurcModel.typeAgainstSTFrom = Convert.ToBoolean(dr["typeAgainstSTFrom"]);
objPurcModel.typeTaxpaid = Convert.ToBoolean(dr["typeTaxpaid"]);
objPurcModel.typeExempt = Convert.ToBoolean(dr["typeExempt"]);
objPurcModel.typeTaxFree = Convert.ToBoolean(dr["typeTaxFree"]);
objPurcModel.typeLUMSumDealer = Convert.ToBoolean(dr["typeLUMSumDealer"]);
objPurcModel.typeUnRegDealer = Convert.ToBoolean(dr["typeUnRegDealer"]);
objPurcModel.TaxInvoice = Convert.ToBoolean(dr["TaxInvoice"]);
objPurcModel.VatReturnCategory = dr["VatReturnCategory"].ToString();
objPurcModel.VatSaleTaxReport = Convert.ToBoolean(dr["VatSaleTaxReport"]);
objPurcModel.CalculateTaxonItemMRP = Convert.ToBoolean(dr["CalculateTaxonItemMRP"]);
objPurcModel.TaxInclusiveItemPrice = Convert.ToBoolean(dr["TaxInclusiveItemPrice"]);
objPurcModel.CalculateTaxonpercentofAmount = Convert.ToDecimal(dr["CalculateTaxonpercentofAmount"]);
objPurcModel.AdjustTaxinSaleAccount = Convert.ToBoolean(dr["AdjustTaxinSaleAccount"]);
objPurcModel.TaxAccount = dr["TaxAccount"].ToString();
objPurcModel.TypeLocal = Convert.ToBoolean(dr["TypeLocal"]);
objPurcModel.TypeCentral = Convert.ToBoolean(dr["TypeCentral"]);
objPurcModel.TypeStockTransfer = Convert.ToBoolean(dr["TypeStockTransfer"]);
objPurcModel.TypeOther = Convert.ToBoolean(dr["TypeOther"]);
objPurcModel.ExportNormal = Convert.ToBoolean(dr["ExportNormal"]);
objPurcModel.SaleinTransit = Convert.ToBoolean(dr["SaleinTransit"]);
objPurcModel.ExportHighsea = Convert.ToBoolean(dr["ExportHighsea"]);
objPurcModel.IssueSTFrom = Convert.ToBoolean(dr["IssueSTFrom"]);
objPurcModel.FromIssuable = dr["FromIssuable"].ToString();
objPurcModel.ReceiveSTForm = Convert.ToBoolean(dr["ReceiveSTForm"]);
objPurcModel.FromReceivable = dr["FormReceivable"].ToString();
objPurcModel.SingleTaxRate = Convert.ToBoolean(dr["SingleTaxRate"]);
objPurcModel.MultiTaxRate = Convert.ToBoolean(dr["MultiTaxRate"]);
objPurcModel.TaxinPercentage = Convert.ToDecimal(dr["TaxinPercentage"]);
objPurcModel.SurchargeInPercentage = Convert.ToDecimal(dr["SurchargeInPercentage"]);
objPurcModel.freezeTaxinSales = Convert.ToBoolean(dr["freezeTaxinSales"]);
objPurcModel.freezeTaxinSalesReturn = Convert.ToBoolean(dr["freezeTaxinSalesReturn"]);
objPurcModel.InvoiceHeading = dr["InvoiceHeading"].ToString();
objPurcModel.InvoiceDescription = dr["InvoiceDescription"].ToString();
objPurcModel.SkipVatorSaleTaxReport = Convert.ToBoolean(dr["SkipVatorSaleTaxReport"]);
}
return(objPurcModel);
}
//List Of All Purchase Types
public List <PurchaseTypeModel> GetAllPurchaseType()
{
List <eSunSpeedDomain.PurchaseTypeModel> lstPurcType = new List <PurchaseTypeModel>();
eSunSpeedDomain.PurchaseTypeModel objPurcType;
string Query = "SELECT * FROM purchasetypemaster";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objPurcType = new PurchaseTypeModel();
objPurcType.Purch_Id = Convert.ToInt32(dr["Purch_Id"]);
objPurcType.PurchType = dr["PurchaseType"].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"]);
lstPurcType.Add(objPurcType);
}
return(lstPurcType);
}
private void btnSave_Click(object sender, EventArgs e)
{
objPurcModel = new PurchaseTypeModel();
if (tbxPurcahseType.Text.Equals(string.Empty))
{
MessageBox.Show("Sales Type can not be blank!");
tbxPurcahseType.Focus();
return;
}
objPurcModel.PurchType = tbxPurcahseType.Text.Trim();
//this GroupBox for sales Account Information of RadioButton
objPurcModel.typeSpecifyHereSingleAccount = rbngrpSalesAcInf.SelectedIndex == 0 ? true : false;
if (objPurcModel.typeSpecifyHereSingleAccount)
{
objPurcModel.LedgerAccountBox = cbxLedgerAccount.Text.Trim() == null ? string.Empty : cbxLedgerAccount.Text.Trim();
}
objPurcModel.typeDifferentTaxRate = rbngrpSalesAcInf.SelectedIndex == 1 ? true : false;
objPurcModel.typeSpecifyINVoucher = rbngrpSalesAcInf.SelectedIndex == 2 ? true : false;
//TaxationType: RadioButton Group
if (rbngrpTaxation.SelectedIndex == 0)
{
objPurcModel.typeTaxable = true;
}
if (rbngrpTaxation.SelectedIndex == 1)
{
objPurcModel.typeAgainstSTFrom = true;
}
if (rbngrpTaxation.SelectedIndex == 2)
{
objPurcModel.typeExempt = true;
}
if (rbngrpTaxation.SelectedIndex == 3)
{
objPurcModel.typeLUMSumDealer = true;
}
if (rbngrpTaxation.SelectedIndex == 4)
{
objPurcModel.typeMultiTax = true;
}
if (rbngrpTaxation.SelectedIndex == 5)
{
objPurcModel.typeTaxpaid = true;
}
if (rbngrpTaxation.SelectedIndex == 6)
{
objPurcModel.typeTaxFree = true;
}
if (rbngrpTaxation.SelectedIndex == 7)
{
objPurcModel.typeUnRegDealer = true;
}
//Region Radio Button GroupBox
if (rbngrpRegion.SelectedIndex == 0)
{
objPurcModel.TypeLocal = true;
}
if (rbngrpRegion.SelectedIndex == 1)
{
objPurcModel.TypeCentral = true;
}
//other Information Group
if (objPurcModel.typeTaxable)
{
if (objPurcModel.TypeLocal)
{
objPurcModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objPurcModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objPurcModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objPurcModel.typeMultiTax)
{
if (objPurcModel.TypeLocal)
{
objPurcModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objPurcModel.CalculateTaxonItemMRP = cbxTaxonItemmrp.SelectedItem.ToString().Equals("Y") ? true : false;
objPurcModel.TaxInclusiveItemPrice = cbxTaxInclItemPrice.SelectedItem.ToString().Equals("Y") ? true : false;
objPurcModel.CalculatedTax = Convert.ToDecimal(tbxCalculatedtax.Text.Trim() == string.Empty ? "0.00" : tbxCalculatedtax.Text.Trim());
objPurcModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objPurcModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
objPurcModel.AdjustTaxinSaleAccount = cbxAdTaxinSaleAmt.SelectedItem.ToString().Equals("Y") ? true : false;
if (objPurcModel.typeDifferentTaxRate == false)
{
objPurcModel.TaxAccount = cbxTaxAccount.SelectedItem.ToString();
}
}
if (objPurcModel.typeAgainstSTFrom)
{
if (objPurcModel.TypeLocal)
{
objPurcModel.TaxInvoice = cbxTaxInvoiceyesno.SelectedItem.ToString().Equals("Y") ? true : false;
}
objPurcModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objPurcModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
if (objPurcModel.typeAgainstSTFrom)
{
objPurcModel.IssueSTFrom = cbxIssueSTform.SelectedItem.ToString().Equals("Y") ? true : false;
if (objPurcModel.IssueSTFrom)
{
objPurcModel.FromIssuable = cbxFormIssuable.SelectedItem.ToString();
}
objPurcModel.ReceiveSTForm = cbxIssueSTform.SelectedItem.ToString().Equals("Y") ? true : false;
if (objPurcModel.IssueSTFrom)
{
objPurcModel.FromReceivable = cbxFormIssuable.SelectedItem.ToString();
}
}
objPurcModel.TaxinPercentage = Convert.ToDecimal(tbxTaxPer.Text.Trim() == string.Empty ? "0.00" : tbxTaxPer.Text.Trim());
objPurcModel.SurchargeInPercentage = Convert.ToDecimal(tbxSurchargePer.Text.Trim() == string.Empty ? "0.00" : tbxSurchargePer.Text.Trim());
objPurcModel.freezeTaxinSales = cbxFreezeTaxinsale.SelectedItem.ToString().Equals("Y") ? true : false;
objPurcModel.freezeTaxinSalesReturn = cbxFreezeTaxinSaleReturn.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objPurcModel.typeTaxpaid || objPurcModel.typeExempt || objPurcModel.typeTaxFree)
{
objPurcModel.VatReturnCategory = cbxVatreturnCategory.SelectedItem.ToString();
objPurcModel.SkipVatorSaleTaxReport = cbxVatorSalesTaxReports.SelectedItem.ToString().Equals("Y") ? true : false;
}
//if Enable MultiTax Will Show on other Information Group
//Tax Calculation
objPurcModel.SingleTaxRate = rbngrpTaxcalculation.SelectedIndex == 0 ? true : false;
objPurcModel.MultiTaxRate = rbngrpTaxcalculation.SelectedIndex == 1 ? true : false;
if (objPurcModel.SingleTaxRate)
{
objPurcModel.TaxinPercentage = Convert.ToDecimal(tbxTaxPer.Text.Trim() == string.Empty ? "0.00" : tbxTaxPer.Text.Trim());
objPurcModel.SurchargeInPercentage = Convert.ToDecimal(tbxSurchargePer.Text.Trim() == string.Empty ? "0.00" : tbxSurchargePer.Text.Trim());
objPurcModel.freezeTaxinSales = cbxFreezeTaxinsale.SelectedItem.ToString().Equals("Y") ? true : false;
objPurcModel.freezeTaxinSalesReturn = cbxFreezeTaxinSaleReturn.SelectedItem.ToString().Equals("Y") ? true : false;
}
if (objPurcModel.MultiTaxRate)
{
if (objPurcModel.typeSpecifyHereSingleAccount)
{
objPurcModel.servicesLedgerBox = cbxServicesAccLedger.SelectedItem.ToString();
}
}
//Type of Transaction on Region GrupBox Sub
objPurcModel.TypeStockTransfer = rbngrpTranction.SelectedIndex == 0 ? true : false;
objPurcModel.ExportNormal = rbngrpTranction.SelectedIndex == 1 ? true : false;
objPurcModel.SaleinTransit = rbngrpTranction.SelectedIndex == 2 ? true : false;
objPurcModel.TypeOther = rbngrpTranction.SelectedIndex == 3 ? true : false;
objPurcModel.ExportHighsea = rbngrpTranction.SelectedIndex == 4 ? true : false;
objPurcModel.InvoiceHeading = tbxInvoiceHeading.Text.Trim() == null ? string.Empty : tbxInvoiceHeading.Text.Trim();
objPurcModel.InvoiceDescription = tbxInvoiceDescription.Text.Trim() == null ? string.Empty : tbxInvoiceDescription.Text.Trim();
bool isSuccess = objPurcBL.SavePurchaseType(objPurcModel);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
tbxPurcahseType.Focus();
}
}
private void FillPurchaseTypeInfo()
{
if (PurcId == 0)
{
tbxPurcahseType.Focus();
laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
return;
}
objPurcModel = objPurcBL.GetAllPurchTypeByPurchId(PurcId);
tbxPurcahseType.Text = objPurcModel.PurchType.ToString();
if (objPurcModel.typeSpecifyHereSingleAccount)
{
rbngrpSalesAcInf.SelectedIndex = 0;
}
cbxLedgerAccount.Text = objPurcModel.LedgerAccountBox.ToString();
if (objPurcModel.typeDifferentTaxRate)
{
rbngrpSalesAcInf.SelectedIndex = 1;
}
if (objPurcModel.typeSpecifyINVoucher)
{
rbngrpSalesAcInf.SelectedIndex = 2;
}
if (objPurcModel.typeTaxable)
{
rbngrpTaxation.SelectedIndex = 0;
}
if (objPurcModel.typeAgainstSTFrom)
{
rbngrpTaxation.SelectedIndex = 1;
}
if (objPurcModel.typeExempt)
{
rbngrpTaxation.SelectedIndex = 2;
}
if (objPurcModel.typeTaxpaid)
{
rbngrpTaxation.SelectedIndex = 5;
}
if (objPurcModel.typeMultiTax)
{
rbngrpTaxation.SelectedIndex = 4;
}
if (objPurcModel.typeTaxFree)
{
rbngrpTaxation.SelectedIndex = 6;
}
if (objPurcModel.typeLUMSumDealer)
{
rbngrpTaxation.SelectedIndex = 7;
}
if (objPurcModel.typeUnRegDealer)
{
rbngrpTaxation.SelectedIndex = 3;
}
cbxTaxInvoiceyesno.SelectedItem = (objPurcModel.TaxInvoice)?"Y":"N";
cbxVatreturnCategory.SelectedItem = objPurcModel.VatReturnCategory.ToString();
cbxVatorSalesTaxReports.SelectedItem = objPurcModel.SkipVatorSaleTaxReport ? "Y" : "N";
cbxTaxonItemmrp.SelectedItem = objPurcModel.CalculateTaxonItemMRP ? "Y" : "N";
cbxTaxInclItemPrice.SelectedItem = objPurcModel.TaxInclusiveItemPrice ? "Y" : "N";
tbxCalculatedtax.Text = objPurcModel.CalculateTaxonpercentofAmount.ToString();
cbxAdTaxinSaleAmt.SelectedItem = objPurcModel.AdjustTaxinSaleAccount ? "Y" : "N";
cbxTaxAccount.SelectedItem = objPurcModel.TaxAccount.ToString();
if (objPurcModel.TypeLocal)
{
rbngrpRegion.SelectedIndex = 0;
}
if (objPurcModel.TypeCentral)
{
rbngrpRegion.SelectedIndex = 1;
}
if (objPurcModel.TypeStockTransfer)
{
rbngrpTranction.SelectedIndex = 0;
}
if (objPurcModel.TypeOther)
{
rbngrpTranction.SelectedIndex = 3;
}
if (objPurcModel.ExportNormal)
{
rbngrpTranction.SelectedIndex = 1;
}
if (objPurcModel.SaleinTransit)
{
rbngrpTranction.SelectedIndex = 2;
}
if (objPurcModel.ExportHighsea)
{
rbngrpTranction.SelectedIndex = 4;
}
cbxIssueSTform.SelectedItem = objPurcModel.IssueSTFrom?"Y":"N";
cbxFormIssuable.SelectedItem = objPurcModel.FromIssuable.ToString();
cbxRecevieSTForm.SelectedItem = objPurcModel.ReceiveSTForm?"Y":"N";
cbxFormReceviable.SelectedItem = objPurcModel.FromReceivable.ToString();
if (objPurcModel.SingleTaxRate)
{
rbngrpTaxcalculation.SelectedIndex = 0;
}
if (objPurcModel.MultiTaxRate)
{
rbngrpTaxcalculation.SelectedIndex = 1;
}
tbxTaxPer.Text = objPurcModel.TaxinPercentage.ToString();
tbxSurchargePer.Text = objPurcModel.SurchargeInPercentage.ToString();
cbxFreezeTaxinsale.SelectedItem = objPurcModel.freezeTaxinSales?"Y":"N";
cbxFreezeTaxinSaleReturn.SelectedItem = objPurcModel.freezeTaxinSalesReturn?"Y":"N";
tbxInvoiceHeading.Text = objPurcModel.InvoiceHeading.ToString();
tbxInvoiceDescription.Text = objPurcModel.InvoiceDescription.ToString();
laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
tbxPurcahseType.Focus();
}
public bool SavePurchaseType(PurchaseTypeModel objPtype)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PurchaseType", objPtype.PurchType));
paramCollection.Add(new DBParameter("@typeSpecifyHereSingleAccount", objPtype.typeSpecifyHereSingleAccount, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@LedgerAccountBox", objPtype.LedgerAccountBox));
paramCollection.Add(new DBParameter("@typeDifferentTaxRate", objPtype.typeDifferentTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeSpecifyINVoucher", objPtype.typeSpecifyINVoucher, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxable", objPtype.typeTaxable, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@tyypeMultiTax", objPtype.typeMultiTax, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeAgainstSTFrom", objPtype.typeAgainstSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxpaid", objPtype.typeTaxpaid, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeExempt", objPtype.typeExempt, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeTaxFree", objPtype.typeTaxFree, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeLUMSumDealer", objPtype.typeLUMSumDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@typeUnRegDealer", objPtype.typeUnRegDealer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInvoice", objPtype.TaxInvoice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@VatReturnCategory", objPtype.VatReturnCategory));
paramCollection.Add(new DBParameter("@VatSaleTaxReport", objPtype.VatSaleTaxReport, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonItemMRP", objPtype.CalculateTaxonItemMRP, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxInclusiveItemPrice", objPtype.TaxInclusiveItemPrice, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@CalculateTaxonpercentofAmount", objPtype.CalculatedTax));
paramCollection.Add(new DBParameter("@AdjustTaxinSaleAccount", objPtype.AdjustTaxinSaleAccount, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxAccount", objPtype.TaxAccount));
paramCollection.Add(new DBParameter("@SkipVatorSaleTaxReport", objPtype.SkipVatorSaleTaxReport, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeLocal", objPtype.TypeLocal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeCentral", objPtype.TypeCentral, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeStockTransfer", objPtype.TypeStockTransfer, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TypeOther", objPtype.TypeOther, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportNormal", objPtype.ExportNormal, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SaleinTransit", objPtype.SaleinTransit, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@ExportHighsea", objPtype.ExportHighsea, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SingleTaxRate", objPtype.SingleTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@MultiTaxRate", objPtype.MultiTaxRate, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@TaxinPercentage", objPtype.TaxinPercentage, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SurchargeInPercentage", objPtype.SurchargeInPercentage, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@freezeTaxinSales", objPtype.freezeTaxinSales, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@freezeTaxinSalesReturn", objPtype.freezeTaxinSalesReturn, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@IssueSTFrom", objPtype.IssueSTFrom, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@FromIssuable", objPtype.FromIssuable));
paramCollection.Add(new DBParameter("@ReceiveSTForm", objPtype.ReceiveSTForm, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@FormReceivable", objPtype.FromReceivable));
paramCollection.Add(new DBParameter("@InvoiceHeading", objPtype.InvoiceHeading));
paramCollection.Add(new DBParameter("@InvoiceDescription", objPtype.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("spInsertPurchaseTypeMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isSaved = true;
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
