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