public IActionResult UpdateServicePriceChart([FromBody] ServicePriceChartModel servicePriceChart) { string Action = "Update"; try { if (servicePriceChart.ServicePriceChartId == 0 || servicePriceChart.ServicePlanID == 0 || servicePriceChart.AvailableServiceID == 0 || servicePriceChart.ServiceName == "" || servicePriceChart.PlanType == "" || servicePriceChart.ServiceName == "string" || servicePriceChart.PlanType == "string" || servicePriceChart.ServiceName == null || servicePriceChart.PlanType == null) { return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter ServicePriceChartId / ServicePlanID / AvailableServiceID / ServiceName / PlanType" } })); } else { int row = GetSaveServicePriceChart(servicePriceChart, Action); //Data.ServicePriceChart.SaveServicePriceChart(servicePriceChart, Action); if (row > 0) { return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully")); } else { return(StatusCode((int)HttpStatusCode.Forbidden, new { Error = "Error Updating the Service Price Chart" })); } } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("UpdateServicePriceChart", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } })); } }
public IActionResult GetServicePriceByID(int ServicePlanID) { List <ServicePriceChartModel> serviceList = new List <ServicePriceChartModel>(); // string GetConnectionString = ServicesController.GetConnectionString(); try { DataTable dt = Data.ServiceAvailability.GetServicePriceByID(ServicePlanID); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ServicePriceChartModel service = new ServicePriceChartModel(); service.ServicePriceChartId = (dt.Rows[i]["ServicePriceChartId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePriceChartId"]); service.AvailableServiceID = (dt.Rows[i]["AvailableServiceID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["AvailableServiceID"]); service.ServicePlanID = (dt.Rows[i]["ServicePlanID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePlanID"]); service.ServiceName = (dt.Rows[i]["ServiceName"] == DBNull.Value ? "" : dt.Rows[i]["ServiceName"].ToString()); service.PlanType = (dt.Rows[i]["PlanType"] == DBNull.Value ? "" : dt.Rows[i]["PlanType"].ToString()); service.Price = (dt.Rows[i]["Price"] == DBNull.Value ? 0 : (decimal)dt.Rows[i]["Price"]); service.IsAvailable = (dt.Rows[i]["IsAvailable"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsAvailable"]); service.Description = dt.Rows[i]["Description"].ToString(); service.BusinessCondition = dt.Rows[i]["BusinessCondition"].ToString(); service.Notes = dt.Rows[i]["Notes"].ToString(); //service.IsDeleted = (dt.Rows[i]["IsDeleted"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsDeleted"]); serviceList.Add(service); } return(StatusCode((int)HttpStatusCode.OK, serviceList)); } else { return(StatusCode((int)HttpStatusCode.OK, new { })); } } catch (Exception e) { string SaveErrorLog = Data.Common.SaveErrorLog("GetServicePriceChart", e.Message); return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } })); } }
public static int SaveServicePriceChart(ServicePriceChartModel servicePriceChart, string Action) { try { string ConnectionString = Common.GetConnectionString(); List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@ServicePriceChartId", servicePriceChart.ServicePriceChartId)); parameters.Add(new SqlParameter("@AvailableServiceID", servicePriceChart.AvailableServiceID)); parameters.Add(new SqlParameter("@ServicePlanID", servicePriceChart.ServicePlanID)); parameters.Add(new SqlParameter("@IsAvailable", servicePriceChart.IsAvailable)); parameters.Add(new SqlParameter("@Price", servicePriceChart.Price)); parameters.Add(new SqlParameter("@Action", Action)); int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spServicePriceChart", parameters.ToArray()); return(rowsAffected); } catch (Exception e) { //loggerErr.Error(e.Message + " - " + e.StackTrace); throw e; } }
public static int GetSaveServicePriceChart([FromBody] ServicePriceChartModel servicePriceChart, string Action) { int res = Data.ServicePriceChart.SaveServicePriceChart(servicePriceChart, Action); return(res); }