public HttpResponseMessage GetAppoinmentDetailfromServerFilter(BDMAppointmentFilter objAppointmentDetail)
{
HttpResponseMessage message;
try
{
// BDMAppointmentDetailDAL dal = new BDMAppointmentDetailDAL();
var dynObj = new { result = _obj.GetAppoinmentDetailfromServerFilter(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", "GetAppoinmentDetailfromServerFilter");
}
return(message);
}
public List <BDMAppointmentServerFilter> GetAppoinmentDetailfromServerFilter(BDMAppointmentFilter FilterDetail)
{
List <BDMAppointmentServerFilter> appoinments = new List <BDMAppointmentServerFilter>();
using (DbLayer dbLayer = new DbLayer())
{
if (FilterDetail.Position != 1)
{
SqlCommand SqlCmd = new SqlCommand("spSelectBDMAppoinmentDetailExport");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ActionBy", FilterDetail.ActionBy);
if (FilterDetail.EmployeeId != 0)
{
SqlCmd.Parameters.AddWithValue("@EmployeeId", FilterDetail.EmployeeId);
//if (FilterDetail.FromDate.Year == 1 && FilterDetail.ToDate.Year == 1)
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", DateTime.Now.AddDays(-30));
// SqlCmd.Parameters.AddWithValue("@ToDate", DateTime.Now);
//}
}
if (FilterDetail.FirstName != null && FilterDetail.FirstName != "")
{
SqlCmd.Parameters.AddWithValue("@FirstName", FilterDetail.FirstName);
//if (FilterDetail.FromDate.Year == 1 && FilterDetail.ToDate.Year == 1)
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", DateTime.Now.AddDays(-30));
// SqlCmd.Parameters.AddWithValue("@ToDate", DateTime.Now);
//}
}
if (FilterDetail.ClientName != null && FilterDetail.ClientName != "")
{
SqlCmd.Parameters.AddWithValue("@ClientName", FilterDetail.ClientName);
}
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", FilterDetail.FromDate);
// if (FilterDetail.ToDate.Year != 1)
// {
// SqlCmd.Parameters.AddWithValue("@ToDate", FilterDetail.ToDate);
// }
//}
SqlCmd.Parameters.AddWithValue("@FromDate", FilterDetail.FromDate);
SqlCmd.Parameters.AddWithValue("@ToDate", FilterDetail.ToDate);
appoinments = dbLayer.GetEntityList <BDMAppointmentServerFilter>(SqlCmd);
}
else
{
SqlCommand SqlCmd = new SqlCommand("spSelectBDMAppoinmentDetailExport");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ActionBy", FilterDetail.ActionBy);
if (FilterDetail.EmployeeId != 0)
{
SqlCmd.Parameters.AddWithValue("@EmployeeId", FilterDetail.EmployeeId);
//if (FilterDetail.FromDate.Year == 1 && FilterDetail.ToDate.Year == 1)
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", DateTime.Now.AddDays(-30));
// SqlCmd.Parameters.AddWithValue("@ToDate", DateTime.Now);
//}
}
if (FilterDetail.FirstName != null && FilterDetail.FirstName != "")
{
SqlCmd.Parameters.AddWithValue("@FirstName", FilterDetail.FirstName);
//if (FilterDetail.FromDate.Year == 1 && FilterDetail.ToDate.Year == 1)
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", DateTime.Now.AddDays(-30));
// SqlCmd.Parameters.AddWithValue("@ToDate", DateTime.Now);
//}
}
if (FilterDetail.ClientName != null && FilterDetail.ClientName != "")
{
SqlCmd.Parameters.AddWithValue("@ClientName", FilterDetail.ClientName);
//if (FilterDetail.ToDate.Year != 1)
//{
// SqlCmd.Parameters.AddWithValue("@ToDate", FilterDetail.ToDate);
//}
}
//else
//{
// SqlCmd.Parameters.AddWithValue("@FromDate", DateTime.Now.AddDays(-30));
// SqlCmd.Parameters.AddWithValue("@ToDate", DateTime.Now);
//}
SqlCmd.Parameters.AddWithValue("@FromDate", FilterDetail.FromDate);
SqlCmd.Parameters.AddWithValue("@ToDate", FilterDetail.ToDate);
appoinments = dbLayer.GetEntityList <BDMAppointmentServerFilter>(SqlCmd);
}
}
return(appoinments);
}
