public List <TaxRatesModel> GetTaxRatesByTaxId(int TaxId) { TaxRatesModel objRate = new TaxRatesModel(); List <TaxRatesModel> lstRates = new List <TaxRatesModel>(); string Query = "SELECT * FROM TaxRate WHERE TaxCat_Id=" + TaxId; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objRate = new TaxRatesModel(); objRate.TaxCat_Id = DataFormat.GetInteger(dr["TaxCat_Id"]); objRate.TaxRate_Id = DataFormat.GetInteger(dr["TaxRate_Id"]); objRate.wef = Convert.ToDateTime(dr["wef"]); objRate.Local_Tax = Convert.ToDecimal(dr["Tax_Local"]); objRate.Tax_Central = Convert.ToDecimal(dr["Tax_Central"]); objRate.Local_Schg = Convert.ToDecimal(dr["Tax_Schg"]); objRate.Schg_Central = Convert.ToDecimal(dr["Schg_Central"]); objRate.Service_Tax = Convert.ToDecimal(dr["Service_Tax"]); objRate.Entry_Tax = Convert.ToDecimal(dr["Entry_Tax"]); objRate.Tax_Type = dr["Tax_Type"].ToString(); lstRates.Add(objRate); } return(lstRates); }
private void btnSave_Click(object sender, EventArgs e) { if (tbxName.Text.Equals(string.Empty)) { MessageBox.Show("TaxCategory Name can not be blank!"); return; } eSunSpeedDomain.TaxCategoryModel objtaxcat = new TaxCategoryModel(); objtaxcat.Name = tbxName.Text.Trim(); objtaxcat.TaxCat_Type = cbxtype.SelectedItem.ToString() == ""?string.Empty: cbxtype.SelectedItem.ToString(); if (cbxtype.SelectedIndex == 0) { objtaxcat.TaxonMRP = Convert.ToBoolean(cbxTaxonmrp.SelectedItem.ToString() == "Y" ? true : false); if (cbxTaxonmrp.SelectedItem.ToString() == "Y") { objtaxcat.TaxonMRPMode = cbxtaxonmrpmode.SelectedItem.ToString() == ""?string.Empty : cbxtaxonmrpmode.SelectedItem.ToString(); } objtaxcat.Taxation_Type = cbxTaxationtype.SelectedItem.ToString() == ""? string.Empty : cbxTaxationtype.Text.Trim(); } objtaxcat.TaxonMRPMode = cbxtaxonmrpmode.Text.Trim() == null?string.Empty:cbxtaxonmrpmode.Text.Trim(); objtaxcat.Local_Tax = Convert.ToDecimal(tbxRateoftaxLocal.Text.ToString() == string.Empty ? "0.00" : tbxRateoftaxLocal.Text.ToString()); objtaxcat.CentralTax = Convert.ToDecimal(tbxRateofCenteral.Text.ToString() == string.Empty ? "0.00" : tbxRateofCenteral.Text.ToString()); objtaxcat.ServiceTax = Convert.ToDecimal(tbxServiceTax.Text.Trim() == string.Empty?"0.00": tbxServiceTax.Text.Trim()); objtaxcat.CalculatedTaxon = Convert.ToDecimal(tbxcalculatedtaxon.Text.ToString() == string.Empty?"0.00": tbxcalculatedtaxon.Text.ToString()); objtaxcat.HSNCode = tbxHsn.Text.Trim() == null ? string.Empty : tbxHsn.Text.Trim(); objtaxcat.Tax_Desc = tbxDescription.Text == null ? string.Empty : tbxDescription.Text.Trim(); //Tax Rates Grid TaxRatesModel objTaxRates; List <TaxRatesModel> lstTaxRates = new List <TaxRatesModel>(); for (int i = 0; i < dvgTaxrateDetails.DataRowCount; i++) { DataRow row = dvgTaxrateDetails.GetDataRow(i); objTaxRates = new TaxRatesModel(); objTaxRates.wef = Convert.ToDateTime(row["wef"].ToString()); objTaxRates.Local_Tax = Convert.ToDecimal(row["Local_Tax"].ToString() == string.Empty?"0.00":row["Local_Tax"].ToString()); objTaxRates.Local_Schg = Convert.ToDecimal(row["Local_Schg"].ToString() == string.Empty?"0.00": row["Local_Schg"].ToString()); objTaxRates.Tax_Type = row["Tax_Type"].ToString(); objTaxRates.Tax_Central = Convert.ToDecimal(row["Tax_Central"].ToString() == string.Empty?"0.00": row["Tax_Central"].ToString()); objTaxRates.Schg_Central = Convert.ToDecimal(row["Schg_Central"].ToString() == string.Empty ? "0.00" : row["Schg_Central"].ToString()); objTaxRates.Entry_Tax = Convert.ToDecimal(row["Entry_Tax"].ToString() == string.Empty ? "0.00" : row["Entry_Tax"].ToString()); objTaxRates.Service_Tax = Convert.ToDecimal(row["Service_Tax"].ToString() == string.Empty ? "0.00" : row["Service_Tax"].ToString()); lstTaxRates.Add(objTaxRates); } objtaxcat.TaxRates = lstTaxRates; bool isSuccess = objtaxbl.SaveTaxCategory(objtaxcat); if (isSuccess) { MessageBox.Show("Saved Successfully!"); ClearFormValues(); } }
//Get Tax category List With Grid public List <TaxCategoryModel> GetTaxCategoryRatesbyId(int id) { List <TaxCategoryModel> lsttaxcate = new List <TaxCategoryModel>(); TaxCategoryModel objTax; string Query = "SELECT * FROM taxcategory WHERE TaxCat_Id=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objTax = new TaxCategoryModel(); objTax.TaxCat_Id = DataFormat.GetInteger(dr["TaxCat_Id"]); objTax.Name = dr["Name"].ToString(); objTax.TaxCat_Type = dr["TaxCat_Type"].ToString(); objTax.ServiceTax = Convert.ToDecimal(dr["Service_Tax"].ToString() == string.Empty?"0":dr["Service_Tax"]); objTax.CentralTax = Convert.ToDecimal(dr["Central_Tax"]); objTax.Local_Tax = Convert.ToDecimal(dr["Local_Tax"]); objTax.Taxation_Type = dr["Taxation_Type"].ToString(); objTax.TaxonMRP = Convert.ToBoolean(dr["TaxonMRP"]); objTax.CalculatedTaxon = Convert.ToDecimal(dr["CalculatedTaxon"]); objTax.TaxonMRPMode = dr["TaxonMRPMode"].ToString(); objTax.HSNCode = dr["HSNCode"].ToString(); objTax.Tax_Desc = dr["Tax_Desc"].ToString(); //SELECT Tax Rates string itemQuery = "SELECT * FROM taxrate WHERE TaxCat_Id=" + objTax.TaxCat_Id; System.Data.IDataReader drTax = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objTax.TaxRates = new List <TaxRatesModel>(); TaxRatesModel objRate; while (drTax.Read()) { objRate = new TaxRatesModel(); objRate.TaxCat_Id = DataFormat.GetInteger(drTax["TaxCat_Id"]); objRate.TaxRate_Id = DataFormat.GetInteger(drTax["TaxRate_Id"]); objRate.wef = Convert.ToDateTime(drTax["wef"]); objRate.Local_Tax = Convert.ToDecimal(drTax["Tax_Local"]); objRate.Tax_Central = Convert.ToDecimal(drTax["Tax_Central"]); objRate.Local_Schg = Convert.ToDecimal(drTax["Tax_Schg"]); objRate.Schg_Central = Convert.ToDecimal(drTax["Schg_Central"]); objRate.Service_Tax = Convert.ToDecimal(drTax["Service_Tax"]); objRate.Entry_Tax = Convert.ToDecimal(drTax["Entry_Tax"]); objRate.Tax_Type = drTax["Tax_Type"].ToString(); objTax.TaxRates.Add(objRate); } lsttaxcate.Add(objTax); } return(lsttaxcate); }
private void btnUpdate_Click(object sender, EventArgs e) { eSunSpeedDomain.TaxCategoryModel objGsttax = new TaxCategoryModel(); objGsttax.GSTName = tbxName.Text.Trim(); objGsttax.TaxCat_Type = cbxType.SelectedItem.ToString() == "" ? string.Empty : cbxType.SelectedItem.ToString(); //if (cbxType.SelectedIndex == 0) //{ objGsttax.TaxonMRP = Convert.ToBoolean(cbxTaxonmrp.SelectedItem.ToString() == "Y" ? true : false); objGsttax.TaxonMRPMode = cbxTaxonmrpmode.SelectedItem.ToString() == "" ? string.Empty : cbxTaxonmrpmode.SelectedItem.ToString(); //} objGsttax.SGST_Tax = Convert.ToDecimal(tbxSgstTax.Text.ToString() == string.Empty ? "0.00" : tbxSgstTax.Text.ToString()); objGsttax.IGST_Tax = Convert.ToDecimal(tbxIgstTax.Text.ToString() == string.Empty ? "0.00" : tbxIgstTax.Text.ToString()); objGsttax.CGST_Tax = Convert.ToDecimal(tbxCgstTax.Text.Trim() == string.Empty ? "0.00" : tbxCgstTax.Text.Trim()); objGsttax.CalculatedTaxon = Convert.ToDecimal(tbxCalculatedtaxon.Text.ToString() == string.Empty ? "0.00" : tbxCalculatedtaxon.Text.ToString()); //GST Tax Rates Grid TaxRatesModel objGSTTaxRates; List <TaxRatesModel> lstTaxRates = new List <TaxRatesModel>(); for (int i = 0; i < dvgGSTTaxrateDetails.DataRowCount; i++) { DataRow row = dvgGSTTaxrateDetails.GetDataRow(i); objGSTTaxRates = new TaxRatesModel(); objGSTTaxRates.wef = Convert.ToDateTime(row["wef"].ToString()); objGSTTaxRates.CGST_Tax = Convert.ToDecimal(row["CGST_Tax"].ToString() == string.Empty ? "0.00" : row["CGST_Tax"].ToString()); objGSTTaxRates.SGST_Tax = Convert.ToDecimal(row["SGST_Tax"].ToString() == string.Empty ? "0.00" : row["SGST_Tax"].ToString()); objGSTTaxRates.Tax_Type = row["Tax_Type"].ToString(); objGSTTaxRates.IGST_Tax = Convert.ToDecimal(row["IGST_Tax"].ToString() == string.Empty ? "0.00" : row["IGST_Tax"].ToString()); objGSTTaxRates.Cess = Convert.ToDecimal(row["Cess"].ToString() == string.Empty ? "0.00" : row["Cess"].ToString()); objGSTTaxRates.TaxRate_Id = Convert.ToInt32(row["TaxRate_Id"].ToString() == string.Empty ? "0" : row["TaxRate_Id"].ToString()); objGSTTaxRates.GSTID = Convert.ToInt32(row["GSTID"].ToString() == string.Empty ? "0" : row["GSTID"].ToString()); lstTaxRates.Add(objGSTTaxRates); } objGsttax.GSTTaxRates = lstTaxRates; objGsttax.GST_ID = Convert.ToInt32(GST_Id); bool isSuccess = objtaxbl.UpdateGSTDetails(objGsttax); if (isSuccess) { MessageBox.Show("Update Successfully!"); ClearFormValues(); GST_Id = 0; Administration.List.GSTcategoryList frmList = new Administration.List.GSTcategoryList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillGSTCategoryInfo(); } }
//Get Toatl GST Details With Tax Rates By Id public List <TaxCategoryModel> GetGSTCategoryRatesbyId(long id) { List <TaxCategoryModel> lstgstcate = new List <TaxCategoryModel>(); TaxCategoryModel objTax; string Query = "SELECT * FROM gstdetails WHERE GST_ID=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objTax = new TaxCategoryModel(); objTax.GST_ID = DataFormat.GetInteger(dr["GST_ID"]); objTax.GSTName = dr["GSTName"].ToString(); objTax.TaxCat_Type = dr["TaxCat_Type"].ToString(); objTax.CGST_Tax = Convert.ToDecimal(dr["CGST_Tax"].ToString() == string.Empty ? "0.00" : dr["CGST_Tax"]); objTax.SGST_Tax = Convert.ToDecimal(dr["SGST_Tax"].ToString() == string.Empty ? "0.00" : dr["SGST_Tax"]); objTax.IGST_Tax = Convert.ToDecimal(dr["IGST_Tax"].ToString() == string.Empty ? "0.00" : dr["IGST_Tax"]); objTax.TaxonMRP = Convert.ToBoolean(dr["TaxonMRP"]); objTax.CalculatedTaxon = Convert.ToDecimal(dr["CalculatedTaxon"].ToString() == string.Empty ? "0.00" : dr["CalculatedTaxon"]); objTax.TaxonMRPMode = dr["TaxonMRPMode"].ToString() == null ? string.Empty:dr["TaxonMRPMode"].ToString(); //SELECT GST Tax Rates string itemQuery = "SELECT * FROM gsttaxratedetails WHERE GST_ID=" + id; System.Data.IDataReader drTax = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objTax.TaxRates = new List <TaxRatesModel>(); TaxRatesModel objRate; while (drTax.Read()) { objRate = new TaxRatesModel(); objRate.GSTID = DataFormat.GetInteger(drTax["GST_ID"]); objRate.TaxRate_Id = DataFormat.GetInteger(drTax["TaxRate_Id"]); objRate.wef = Convert.ToDateTime(drTax["wef"].ToString()); objRate.CGST_Tax = Convert.ToDecimal(drTax["CGST_Tax"].ToString() == string.Empty ? "0.00" : drTax["CGST_Tax"]); objRate.SGST_Tax = Convert.ToDecimal(drTax["SGST_Tax"].ToString() == string.Empty ? "0.00" : drTax["SGST_Tax"]); objRate.IGST_Tax = Convert.ToDecimal(drTax["IGST_Tax"].ToString() == string.Empty ? "0.00" : drTax["IGST_Tax"]); objRate.Cess = Convert.ToDecimal(drTax["Cess"].ToString() == string.Empty ? "0.00" : drTax["Cess"]); objRate.Tax_Type = drTax["Tax_Type"].ToString(); objTax.TaxRates.Add(objRate); } lstgstcate.Add(objTax); } return(lstgstcate); }
private void btnSave_Click(object sender, EventArgs e) { if (tbxName.Text.Equals(string.Empty)) { MessageBox.Show("GST Name can not be blank!"); return; } eSunSpeedDomain.TaxCategoryModel objGsttax = new TaxCategoryModel(); objGsttax.GSTName = tbxName.Text.Trim(); objGsttax.TaxCat_Type = cbxType.SelectedItem.ToString() == ""?string.Empty: cbxType.SelectedItem.ToString(); if (cbxType.SelectedIndex == 0) { objGsttax.TaxonMRP = Convert.ToBoolean(cbxTaxonmrp.SelectedItem.ToString() == "Y" ? true : false); objGsttax.TaxonMRPMode = cbxTaxonmrpmode.SelectedItem.ToString() == ""?string.Empty : cbxTaxonmrpmode.SelectedItem.ToString(); } objGsttax.SGST_Tax = Convert.ToDecimal(tbxSgstTax.Text.ToString() == string.Empty ? "0.00" : tbxSgstTax.Text.ToString()); objGsttax.IGST_Tax = Convert.ToDecimal(tbxIgstTax.Text.ToString() == string.Empty ? "0.00" : tbxIgstTax.Text.ToString()); objGsttax.CGST_Tax = Convert.ToDecimal(tbxCgstTax.Text.Trim() == string.Empty?"0.00": tbxCgstTax.Text.Trim()); objGsttax.CalculatedTaxon = Convert.ToDecimal(tbxCalculatedtaxon.Text.ToString() == string.Empty?"0.00": tbxCalculatedtaxon.Text.ToString()); //GST Tax Rates Grid TaxRatesModel objGSTTaxRates; List <TaxRatesModel> lstTaxRates = new List <TaxRatesModel>(); for (int i = 0; i < dvgGSTTaxrateDetails.DataRowCount; i++) { DataRow row = dvgGSTTaxrateDetails.GetDataRow(i); objGSTTaxRates = new TaxRatesModel(); objGSTTaxRates.wef = Convert.ToDateTime(row["wef"].ToString()); objGSTTaxRates.CGST_Tax = Convert.ToDecimal(row["CGST_Tax"].ToString() == string.Empty?"0.00":row["CGST_Tax"].ToString()); objGSTTaxRates.SGST_Tax = Convert.ToDecimal(row["SGST_Tax"].ToString() == string.Empty?"0.00": row["SGST_Tax"].ToString()); objGSTTaxRates.Tax_Type = row["Tax_Type"].ToString(); objGSTTaxRates.IGST_Tax = Convert.ToDecimal(row["IGST_Tax"].ToString() == string.Empty?"0.00": row["IGST_Tax"].ToString()); objGSTTaxRates.Cess = Convert.ToDecimal(row["Cess"].ToString() == string.Empty ? "0.00" : row["Cess"].ToString()); lstTaxRates.Add(objGSTTaxRates); } objGsttax.GSTTaxRates = lstTaxRates; bool isSuccess = objtaxbl.SaveGSTDetails(objGsttax); if (isSuccess) { MessageBox.Show("Saved Successfully!"); ClearFormValues(); } }
public bool UpdateTaxRates(TaxRatesModel objTaxRate) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@wef", objTaxRate.wef)); paramCollection.Add(new DBParameter("@Tax_Local", objTaxRate.Local_Tax)); paramCollection.Add(new DBParameter("@Tax_Schg", objTaxRate.Local_Schg)); paramCollection.Add(new DBParameter("@Tax_Type", objTaxRate.Tax_Type)); paramCollection.Add(new DBParameter("@Tax_Central", objTaxRate.Tax_Central)); paramCollection.Add(new DBParameter("@Schg_Central", objTaxRate.Schg_Central)); paramCollection.Add(new DBParameter("@Entry_Tax", objTaxRate.Entry_Tax)); paramCollection.Add(new DBParameter("@Serivce_Tax", objTaxRate.Service_Tax)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@TaxRate_Id", objTaxRate.TaxRate_Id)); paramCollection.Add(new DBParameter("@TaxCat_Id", objTaxRate.TaxCat_Id)); Query = "UPDATE TaxRate SET [wef]=@wef,[Tax_Local]=@Tax_Local,[Tax_Schg]=@Tax_Schg,[Tax_Type]=@Tax_Type," + "[Tax_Central]=@Tax_Central,[Schg_Central]=@Schg_Central,[Entry_Tax]=@Entry_Tax,[Service_Tax]=@Serivce_Tax," + "[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE TaxRate_Id=@TaxRate_Id AND TaxCat_Id=@TaxCat_Id"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
private void btnUpdate_Click(object sender, EventArgs e) { eSunSpeedDomain.TaxCategoryModel objtaxcat = new TaxCategoryModel(); objtaxcat.Name = tbxName.Text.Trim(); objtaxcat.TaxCat_Type = cbxtype.SelectedItem.ToString() == "" ? string.Empty : cbxtype.SelectedItem.ToString(); if (cbxtype.SelectedIndex == 0) { objtaxcat.TaxonMRP = Convert.ToBoolean(cbxTaxonmrp.SelectedItem.ToString() == "Y" ? true : false); if (cbxTaxonmrp.SelectedItem.ToString() == "Y") { objtaxcat.TaxonMRPMode = cbxtaxonmrpmode.SelectedItem.ToString() == "" ? string.Empty : cbxtaxonmrpmode.SelectedItem.ToString(); } } objtaxcat.Taxation_Type = cbxTaxationtype.Text.Trim() == null ? string.Empty : cbxTaxationtype.Text.Trim(); objtaxcat.TaxonMRPMode = cbxtaxonmrpmode.Text.Trim() == null ? string.Empty : cbxtaxonmrpmode.Text.Trim(); objtaxcat.Local_Tax = Convert.ToDecimal(tbxRateoftaxLocal.Text.ToString() == string.Empty ? "0.00" : tbxRateoftaxLocal.Text.ToString()); objtaxcat.CentralTax = Convert.ToDecimal(tbxRateofCenteral.Text.ToString() == string.Empty ? "0.00" : tbxRateofCenteral.Text.ToString()); objtaxcat.ServiceTax = Convert.ToDecimal(tbxServiceTax.Text.Trim() == string.Empty ? "0.00" : tbxServiceTax.Text.Trim()); objtaxcat.CalculatedTaxon = Convert.ToDecimal(tbxcalculatedtaxon.Text.ToString() == string.Empty ? "0.00" : tbxcalculatedtaxon.Text.ToString()); objtaxcat.HSNCode = tbxHsn.Text.Trim() == null ? string.Empty : tbxHsn.Text.Trim(); objtaxcat.Tax_Desc = tbxDescription.Text == null ? string.Empty : tbxDescription.Text.Trim(); //Tax Rates Grid TaxRatesModel objTaxRates; List <TaxRatesModel> lstTaxRates = new List <TaxRatesModel>(); for (int i = 0; i < dvgTaxrateDetails.DataRowCount; i++) { DataRow row = dvgTaxrateDetails.GetDataRow(i); objTaxRates = new TaxRatesModel(); objTaxRates.wef = Convert.ToDateTime(row["wef"].ToString()); objTaxRates.Local_Tax = Convert.ToDecimal(row["Local_Tax"].ToString() == string.Empty ? "0.00" : row["Local_Tax"].ToString()); objTaxRates.Local_Schg = Convert.ToDecimal(row["Local_Schg"].ToString() == string.Empty ? "0.00" : row["Local_Schg"].ToString()); objTaxRates.Tax_Type = row["Tax_Type"].ToString(); objTaxRates.Tax_Central = Convert.ToDecimal(row["Tax_Central"].ToString() == string.Empty ? "0.00" : row["Tax_Central"].ToString()); objTaxRates.Schg_Central = Convert.ToDecimal(row["Schg_Central"].ToString() == string.Empty ? "0.00" : row["Schg_Central"].ToString()); objTaxRates.Entry_Tax = Convert.ToDecimal(row["Entry_Tax"].ToString() == string.Empty ? "0.00" : row["Entry_Tax"].ToString()); objTaxRates.Service_Tax = Convert.ToDecimal(row["Service_Tax"].ToString() == string.Empty ? "0.00" : row["Service_Tax"].ToString()); objTaxRates.TaxRate_Id = Convert.ToInt32(row["TaxRate_Id"].ToString() == string.Empty ? "0" : row["TaxRate_Id"].ToString()); objTaxRates.TaxCat_Id = Convert.ToInt32(row["TaxCat_Id"].ToString() == string.Empty ? "0" : row["TaxCat_Id"].ToString()); lstTaxRates.Add(objTaxRates); } objtaxcat.TaxRates = lstTaxRates; objtaxcat.TaxCat_Id = Tax_Id; bool isSuccess = objtaxbl.UpdateTaxCategory(objtaxcat); if (isSuccess) { MessageBox.Show("Update Successfully!"); ClearFormValues(); Tax_Id = 0; Administration.List.TaxcategoryList frmList = new Administration.List.TaxcategoryList(); frmList.StartPosition = FormStartPosition.CenterScreen; frmList.ShowDialog(); FillTaxCategoryInfo(); } }