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