public ActionResult StaffEventCreation(StaffEventCreation staffEvent)
{
EduData = new EducationManagerData();
bool res = false;
try
{
if (staffEvent.Eventid != 0)
{
if (staffEvent.InitialEventDate != staffEvent.EventDate && staffEvent.InitialEventTime == staffEvent.StartTime)
{
staffEvent.EventChangesOn = 1;
}
else if (staffEvent.InitialEventDate == staffEvent.EventDate && staffEvent.InitialEventTime != staffEvent.StartTime)
{
staffEvent.EventChangesOn = 2;
}
else if (staffEvent.InitialEventDate != staffEvent.EventDate && staffEvent.InitialEventTime != staffEvent.StartTime)
{
staffEvent.EventChangesOn = 3;
}
else
{
staffEvent.EventChangesOn = 0;
}
}
res = EduData.SaveStaffEventDetails(staffEvent);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(RedirectToAction("EventsList"));
}
public ActionResult StaffEventInfo(string Yakkrid)
{
EduData = new EducationManagerData();
StaffEventCreation events = new StaffEventCreation();
try
{
events = EduData.StaffEventInfo(Yakkrid);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(events));
}
public StaffEventCreation StaffEventInfo(string yakkrid)
{
StaffEventCreation evt = new StaffEventCreation();
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
StaffDetails staff = new StaffDetails();
_dataset = new DataSet();
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", staff.AgencyId));
command.Parameters.Add(new SqlParameter("@userid", staff.UserId));
command.Parameters.Add(new SqlParameter("@yakkrid", yakkrid));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_StaffEventInfo";
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(_dataset);
if (_dataset != null && _dataset.Tables[0] != null && _dataset.Tables[0].Rows.Count > 0)
{
evt.EventDescription = _dataset.Tables[0].Rows[0]["Description"].ToString();
evt.EvenitAddress = _dataset.Tables[0].Rows[0]["EventAddress"].ToString();
evt.EventDate = _dataset.Tables[0].Rows[0]["TrainingDate"].ToString();
evt.Eventid = Convert.ToInt32(_dataset.Tables[0].Rows[0]["EventId"]);
evt.EventName = _dataset.Tables[0].Rows[0]["TrainingName"].ToString();
evt.Trainer = _dataset.Tables[0].Rows[0]["Trainer"].ToString();
evt.ContinuingEdu = _dataset.Tables[0].Rows[0]["ContinuingEducation"].ToString();
evt.TotalHours = _dataset.Tables[0].Rows[0]["TotalHours"].ToString();
evt.StartTime = _dataset.Tables[0].Rows[0]["EventTime"].ToString();
evt.RSVPStatus = Convert.ToInt32(_dataset.Tables[0].Rows[0]["RSVPStatus"]);
evt.EventChangesOn = Convert.ToInt32(_dataset.Tables[0].Rows[0]["EventChangesOn"]);
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(evt);
}
//public ActionResult GetEventByYakkrid(string YakkrId)
//{
// StaffEventCreation eventdata = new StaffEventCreation();
// EduData = new EducationManagerData();
// try
// {
// eventdata = EduData.GetEventByYakkrId(YakkrId);
// }
// catch (Exception ex)
// {
// clsError.WriteException(ex);
// }
// return Json(eventdata, JsonRequestBehavior.AllowGet);
//}
public ActionResult GetEventListByEventType(string EventType)
{
EduData = new EducationManagerData();
StaffEventCreation evt = new StaffEventCreation();
try
{
evt.events = EventType == "1"?EduData.GetStaffEventList((int)FingerprintsModel.Enums.StaffEventListType.OpenEvents): EduData.GetStaffEventList((int)FingerprintsModel.Enums.StaffEventListType.CompletedEvents);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(Json(evt.events, JsonRequestBehavior.AllowGet));
}
public ActionResult CompletedEvents()
{
EduData = new EducationManagerData();
StaffEventCreation evt = new StaffEventCreation();
ViewBag.EventType = "completed";
try
{
evt.events = EduData.GetStaffEventList((int)FingerprintsModel.Enums.StaffEventListType.CompletedEvents);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View("EventsList", evt));
}
public ActionResult EventsList()
{
ViewBag.EventType = "future";
EduData = new EducationManagerData();
StaffEventCreation evt = new StaffEventCreation();
try
{
evt.events = EduData.GetStaffEventList((int)FingerprintsModel.Enums.StaffEventListType.UpcomingEvents);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(evt));
}
public ActionResult StaffEventCreation(string Eventid = "")
{
EduData = new EducationManagerData();
StaffEventCreation events = new StaffEventCreation();
try
{
events = Eventid == "" ? EduData.GetStaffEventCreation((int)FingerprintsModel.Enums.StaffEventListType.Initial, Eventid) : EduData.GetStaffEventCreation((int)FingerprintsModel.Enums.StaffEventListType.ByEventId, Eventid);
events.Heading = Eventid == "" ? "Event Creation" : "Edit Event Details";
events.IsEditMode = Eventid == "" ? false : true;
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(events));
}
public ActionResult StaffEventReports()
{
EduData = new EducationManagerData();
StaffEventCreation evt = new StaffEventCreation();
ViewBag.EventType = "completed";
try
{
evt.events = EduData.GetStaffEventList(5);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
return(View(evt));
}
public bool SaveStaffEventDetails(StaffEventCreation evt)
{
bool isInserted = false;
try
{
StaffDetails session = new StaffDetails();
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
if (evt.EventType == 1)
{
command.CommandText = "SP_SaveStaffEventDetails";
}
else if (evt.EventType == 2)
{
command.CommandText = "SP_SaveHistoricalStaffEventDetails";
}
command.Connection = Connection;
command.Parameters.Clear();
command.Parameters.AddWithValue("@Agencyid", session.AgencyId);
command.Parameters.AddWithValue("@UserId", session.UserId);
command.Parameters.AddWithValue("@EventName", evt.EventName);
command.Parameters.AddWithValue("@EventDescription", evt.EventDescription);
command.Parameters.AddWithValue("@EventDate", evt.EventDate);
command.Parameters.AddWithValue("@EventAddress", evt.EvenitAddress);
command.Parameters.AddWithValue("@Centerid", evt.CenterIds != null ? String.Join(",", evt.CenterIds) : "");
command.Parameters.AddWithValue("@ContinuingEdu", evt.ContinuingEdu);
command.Parameters.AddWithValue("@TotalHours", evt.TotalHours);
command.Parameters.AddWithValue("@Trainer", evt.Trainer);
command.Parameters.AddWithValue("@EventTime", evt.StartTime);
command.Parameters.AddWithValue("@ChangesOn", evt.EventChangesOn);
command.Parameters.AddWithValue("@EventId", evt.Eventid);
command.Parameters.AddWithValue("@isCancelled", evt.IsEventCancelled);
command.Parameters.AddWithValue("@CancellReason", evt.CancelReason);
command.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[1] {
new DataColumn("RoleId", typeof(string)),
});
if (evt.RolesList != null && evt.RolesList.Count > 0)
{
foreach (string roles in evt.RolesList)
{
if (roles != "")
{
dt.Rows.Add(roles);
}
}
command.Parameters.AddWithValue("@RolesList", dt);
}
if (evt.EventType == 2)
{
DataTable dt1 = new DataTable();
dt1.Columns.AddRange(new DataColumn[1] {
new DataColumn("UserId", typeof(string)),
});
if (evt.UsersList != null && evt.UsersList.Count > 0)
{
foreach (string userid in evt.UsersList)
{
if (userid != "")
{
dt1.Rows.Add(userid);
}
}
}
command.Parameters.AddWithValue("@UserList", dt1);
}
int res = command.ExecuteNonQuery();
if (res > 1)
{
isInserted = true;
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
if (Connection != null && Connection.State == ConnectionState.Open)
{
Connection.Close();
command.Dispose();
}
}
return(isInserted);
}
public StaffEventCreation GetStaffEventCreation(int Mode, string Eventid = "")
{
StaffEventCreation evt = new StaffEventCreation();
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
StaffDetails staff = new StaffDetails();
_dataset = new DataSet();
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", staff.AgencyId));
command.Parameters.Add(new SqlParameter("@userid", staff.UserId));
command.Parameters.Add(new SqlParameter("@Mode", Mode));
command.Parameters.Add(new SqlParameter("@Eventid", Eventid));
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SP_EventCreation";
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(_dataset);
if (_dataset != null && _dataset.Tables[1] != null && _dataset.Tables[1].Rows.Count > 0)
{
//evt.CenterList = new List<SelectListItem>();
//evt.CenterList = (from DataRow dr5 in _dataset.Tables[1].Rows
// select new SelectListItem
// {
// Text = dr5["Centername"].ToString(),
// Value = dr5["centerid"].ToString()
// }).ToList();
evt.CenterList = new List <StaffEventCreation.CenterListItem>();
evt.CenterList = (from DataRow dr5 in _dataset.Tables[1].Rows
select new StaffEventCreation.CenterListItem
{
Text = dr5["Centername"].ToString(),
Value = dr5["centerid"].ToString(),
HomeBased = Convert.ToBoolean(dr5["homebased"])
}).ToList();
evt.ActiveRoles = new List <SelectListItem>();
evt.ActiveRoles = (from DataRow dr5 in _dataset.Tables[2].Rows
select new SelectListItem
{
Text = dr5["RoleName"].ToString(),
Value = dr5["RoleId"].ToString()
}).ToList();
if (Eventid != "")
{
evt.EventDescription = _dataset.Tables[0].Rows[0]["Description"].ToString();
evt.EvenitAddress = _dataset.Tables[0].Rows[0]["EventAddress"].ToString();
evt.EventDate = _dataset.Tables[0].Rows[0]["TrainingDate"].ToString();
evt.Eventid = Convert.ToInt32(_dataset.Tables[0].Rows[0]["EventId"]);
evt.EventName = _dataset.Tables[0].Rows[0]["TrainingName"].ToString();
evt.InitialEventDate = _dataset.Tables[0].Rows[0]["TrainingDate"].ToString();
evt.InitialEventTime = _dataset.Tables[0].Rows[0]["EventTime"].ToString();
evt.ContinuingEdu = _dataset.Tables[0].Rows[0]["ContinuingEducation"].ToString();
evt.TotalHours = _dataset.Tables[0].Rows[0]["TotalHours"].ToString();
evt.StartTime = _dataset.Tables[0].Rows[0]["EventTime"].ToString();
evt.Trainer = _dataset.Tables[0].Rows[0]["Trainer"].ToString();
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(evt);
}
