public Int16 InsertMunicipalityTaxesDetails([FromBody] MunicipalityTaxes taxes) { Int16 Num = 0; try { List <MunicipalityTaxes> municipalityTaxes = new List <MunicipalityTaxes>(); DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Taxes"].ToString())) { SqlCommand sqlComm = new SqlCommand("FetchTaxesDetails", conn); sqlComm.Parameters.AddWithValue("@Action_Type", 'I'); sqlComm.Parameters.AddWithValue("@Munc_Name", taxes.MunicipalityName); sqlComm.Parameters.AddWithValue("@Start_Date", taxes.StartDate); sqlComm.Parameters.AddWithValue("@End_Date", taxes.EndDate); sqlComm.Parameters.AddWithValue("@Tax_Amt", taxes.TaxAmount); sqlComm.Parameters.AddWithValue("@Tax_Type", taxes.TaxType); sqlComm.CommandType = CommandType.StoredProcedure; conn.Open(); Num = (Int16)sqlComm.ExecuteNonQuery(); } return(Num); } catch (Exception ex) { throw ex; } }
public MunicipalityTaxesRepository() { if (_MunicipalityTaxes == null) { _MunicipalityTaxes = new MunicipalityTaxes(); } }
public decimal GetMunicipalityTaxesDetails([FromBody] MunicipalityTaxes taxes) { decimal taxAmt = 0; try { List <MunicipalityTaxes> municipalityTaxes = new List <MunicipalityTaxes>(); DataSet ds = new DataSet(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Taxes"].ToString())) { SqlCommand sqlComm = new SqlCommand("FetchTaxesDetails", conn); sqlComm.Parameters.AddWithValue("@Action_Type", 'G'); sqlComm.Parameters.AddWithValue("@Munc_Name", taxes.MunicipalityName); sqlComm.Parameters.AddWithValue("@date", taxes.checkDate); sqlComm.CommandType = CommandType.StoredProcedure; conn.Open(); taxAmt = (Decimal)sqlComm.ExecuteScalar(); } return(taxAmt); } catch (Exception ex) { throw ex; } }