public List <ServiceMasterDTO> GetAllServices(ServiceMasterGetDTO objGetServices)
{
List <ServiceMasterDTO> requirement = new List <ServiceMasterDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectServices");
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetServices.ActionBy);
SqlCmd.CommandType = CommandType.StoredProcedure;
requirement = dbLayer.GetEntityList <ServiceMasterDTO>(SqlCmd);
}
return(requirement);
}
public List <ServiceMasterDTO> GetInActiveServiceMaster(ServiceMasterGetDTO objInActive)
{
List <ServiceMasterDTO> inactiveList = new List <ServiceMasterDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectServices");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Active", 0);
SqlCmd.Parameters.AddWithValue("@ActionBy", objInActive.ActionBy);
inactiveList = dbLayer.GetEntityList <ServiceMasterDTO>(SqlCmd);
}
return(inactiveList);
}
public ServiceMasterDTO GetServiceById(ServiceMasterGetDTO objGetServiceById)
{
ServiceMasterDTO requirement = new ServiceMasterDTO();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectServices");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Id", objGetServiceById.Id);
SqlCmd.Parameters.AddWithValue("@ActionBy", objGetServiceById.ActionBy);
requirement = dbLayer.GetEntityList <ServiceMasterDTO>(SqlCmd).FirstOrDefault();
}
return(requirement);
}
public HttpResponseMessage GetActiveServiceMaster(ServiceMasterGetDTO objActive)
{
HttpResponseMessage message;
try
{
// ServiceMasterDataAccessLayer dal = new ServiceMasterDataAccessLayer();
var dynObj = new { result = _Service.GetActiveServiceMaster(objActive) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "ServiceMaster", "GetActiveServiceMaster");
}
return(message);
}
