public List <LeaveFrequencyMasterDTO> GetAllLeaveFrequencyMaster(LeaveFrequencyMasterGetDTO objLeave)
{
List <LeaveFrequencyMasterDTO> Leave = new List <LeaveFrequencyMasterDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectLeaveFrequency");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ActionBy", objLeave.ActionBy);
Leave = dbLayer.GetEntityList <LeaveFrequencyMasterDTO>(SqlCmd);
}
return(Leave);
}
public LeaveFrequencyMasterDTO GetLeaveFrequencyMasterById(LeaveFrequencyMasterGetDTO objLeave)
{
LeaveFrequencyMasterDTO accounts = new LeaveFrequencyMasterDTO();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectLeaveFrequencyMaster");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@Id", objLeave.Id);
SqlCmd.Parameters.AddWithValue("@ActionBy", objLeave.ActionBy);
accounts = dbLayer.GetEntityList <LeaveFrequencyMasterDTO>(SqlCmd).FirstOrDefault();
}
return(accounts);
}
public HttpResponseMessage GetLeaveFrequencyMasterById(LeaveFrequencyMasterGetDTO objLeave)
{
HttpResponseMessage message;
try
{
// LeaveFrequencyMasterDataAccessLayer dal = new LeaveFrequencyMasterDataAccessLayer();
var dynObj = new { result = _frequency.GetLeaveFrequencyMasterById(objLeave) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "Leave", "GetLeaveFrequencyMasterById");
}
return(message);
}
