public HttpResponseMessage GetBDMAppointmentDetailById(GetBDMAppointmentDetailDTO objAppointmentDetail)
{
HttpResponseMessage message;
try
{
// BDMAppointmentDetailDAL dal = new BDMAppointmentDetailDAL();
var dynObj = new { result = _obj.GetAppointmentDetailById(objAppointmentDetail) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" });
ErrorLog.CreateErrorMessage(ex, "BDMAppoinmentDetail", "GetBDMAppointmentDetailById");
}
return(message);
}
public List <BDMAppointmentDetailDTO> GetAppointmentDetailById(GetBDMAppointmentDetailDTO objAppointmentDetail)
{
List <BDMAppointmentDetailDTO> appoinment = new List <BDMAppointmentDetailDTO>();
using (DbLayer dbLayer = new DbLayer())
{
SqlCommand SqlCmd = new SqlCommand("spSelectBDMAppoinmentDetail");
SqlCmd.CommandType = CommandType.StoredProcedure;
// SqlCmd.Parameters.AddWithValue("@EmployeeId", objAppointmentDetail.Id);
SqlCmd.Parameters.AddWithValue("@position", objAppointmentDetail.Position);
SqlCmd.Parameters.AddWithValue("@EmployeeId", objAppointmentDetail.Id);
//if (objAppointmentDetail.Position == 4)
//{
// SqlCmd.Parameters.AddWithValue("@State", objAppointmentDetail.State);
// SqlCmd.Parameters.AddWithValue("@City", objAppointmentDetail.City);
//}
//if (objAppointmentDetail.Position != 4)
//{
// SqlCmd.Parameters.AddWithValue("@EmployeeId", objAppointmentDetail.Id);
//}
SqlCmd.Parameters.AddWithValue("@ActionBy", objAppointmentDetail.ActionBy);
if (objAppointmentDetail.FromDate.Year != 1 && objAppointmentDetail.ToDate.Year != 1)
{
SqlCmd.Parameters.AddWithValue("@FromDate", objAppointmentDetail.FromDate);
SqlCmd.Parameters.AddWithValue("@ToDate", objAppointmentDetail.ToDate);
}
else
{
var fr = DateTime.Now.AddDays(-30);
var en = DateTime.Now;
SqlCmd.Parameters.AddWithValue("@FromDate", fr);
SqlCmd.Parameters.AddWithValue("@ToDate", en);
}
appoinment = dbLayer.GetEntityList <BDMAppointmentDetailDTO>(SqlCmd);
}
return(appoinment);
}
