public List <LeadEvent> GetEventsInDatetimeRange(DateTime startDate, DateTime endDate)
{
objResponse Response = new objResponse();
List <LeadEvent> result = new List <LeadEvent>();
int i = 0;
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@startDate", SqlDbType.DateTime, 1000);
sqlParameter[0].Value = startDate;
sqlParameter[1] = new SqlParameter("@endDate", SqlDbType.DateTime, 100);
sqlParameter[1].Value = endDate;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetLeadEvents", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
LeadEvent rec = new LeadEvent();
rec.ID = Convert.ToInt64(dr["LeadEvent_Id_Auto_Pk"]); //we dont link this back to anything as its a group summary but the fullcalendar needs unique IDs for each event item (unless its a repeating event)
// rec.Relatedlead = -1;
string StringDate = string.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(dr["DateTimeScheduled"]));
rec.StartDateString = StringDate + "T00:00:00"; //ISO 8601 format
rec.EndDateString = StringDate + "T23:59:59";
rec.Title = dr["Title"].ToString();
result.Add(rec);
i++;
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("GetEventsInDatetimeRange", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(result);
}
public List <LeadEvent> GetLeadEventsInDatetimeRangeForTransfer(DateTime startDate, DateTime endDate)
{
objResponse Response = new objResponse();
List <LeadEvent> result = new List <LeadEvent>();
int i = 0;
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter("@startDate", SqlDbType.DateTime, 1000);
sqlParameter[0].Value = startDate;
sqlParameter[1] = new SqlParameter("@endDate", SqlDbType.DateTime, 100);
sqlParameter[1].Value = endDate;
DATA_ACCESS_LAYER.Fill(Response.ResponseData, "usp_GetLeadEvents", sqlParameter, DB_CONSTANTS.ConnectionString_ICS);
if (Response.ResponseData.Tables[0].Rows.Count > 0)
{
Response.ErrorCode = 0;
Response.ErrorMessage = Response.ResponseData.Tables[0].Rows[0][0].ToString();
foreach (DataRow dr in Response.ResponseData.Tables[0].Rows)
{
LeadEvent rec = new LeadEvent();
rec.ID = Convert.ToInt64(dr["LeadEvent_Id_Auto_Pk"]); //we dont link this back to anything as its a group summary but the fullcalendar needs unique IDs for each event item (unless its a repeating event)
rec.StartDateString = Convert.ToDateTime(dr["DateTimeScheduled"]).ToString("MM/dd/yy HH:mm"); // "s" is a preset format that outputs as: "2009-02-27T12:12:22"
//rec.EndDateString = Convert.ToDateTime(dr["DateTimeScheduled"]).AddMinutes(Convert.ToInt32(dr["AppointmentLength"])).ToString("MM/dd/yy HH:mm"); // field AppointmentLength is in minutes
rec.Title = dr["Title"].ToString();
rec.StatusColor = dr["Colour"].ToString();;
result.Add(rec);
}
}
else
{
Response.ErrorCode = 2001;
Response.ErrorMessage = "There is an Error. Please Try After some time.";
}
}
catch (Exception ex)
{
Response.ErrorCode = 3001;
Response.ErrorMessage = ex.Message.ToString();
BAL.Common.LogManager.LogError("LoadEventsInDatetimeRange", 1, Convert.ToString(ex.Source), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
}
return(result);
}
