public IHttpActionResult DeleteTaxSavingType(TaxSavingTypeModel taxSavingTypeModel) { long result; result = EmployeeRepository.DeleteTaxSavingType(taxSavingTypeModel.TaxSavingType); return(Json(result)); }
public static long InsertTaxSavingType(TaxSavingTypeModel taxSavingType) { long result; BuildQuery qb = new BuildQuery(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); qb.ClearParameters(); qb.SetInParam("@TaxSavingTypeName", taxSavingType.TaxSavingTypeName, SqlDbType.NVarChar); qb.SetInParam("@TaxCategoryCode", taxSavingType.TaxCategoryCode, SqlDbType.NVarChar); result = qb.ExecuteNonQuery("spInsertTaxSavingType", CommandType.StoredProcedure); return(result); }
public IHttpActionResult UpdateTaxSavingType(TaxSavingTypeModel taxSavingTypeModel) { try { long result; JavaScriptSerializer serializer = new JavaScriptSerializer(); TaxSavingTypeModel taxsaving = serializer.Deserialize <TaxSavingTypeModel>(taxSavingTypeModel.jsonData); result = EmployeeRepository.UpdateTaxSavingType(taxsaving); return(Json(result)); } catch (Exception ex) { return(Ok("")); } }
public IHttpActionResult EditTaxSavingType(TaxSavingTypeModel taxSavingTypeModel) { try { DataSet ds = EmployeeRepository.GetTaxSavingType(); DataTable Results = ds.Tables[0]; var query = Results.AsEnumerable().Select(result => new { TaxSavingType = result.Field <int>("TaxSavingType"), TaxSavingTypeName = result.Field <string>("TaxSavingTypeName"), TaxCategoryCode = result.Field <string>("TaxCategoryCode") }); var filterdata = query.Where(m => m.TaxSavingType == taxSavingTypeModel.TaxSavingType); return(Ok(filterdata));; } catch { return(null); } }