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();
}
}