// Updating a event
protected void gvwDash_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string eventId = ((Label)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtEventId")).Text;
string eventSchedule = ((TextBox)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtSchedule")).Text;
string eventLocation = ((TextBox)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtLocation")).Text;
string eventPrice = ((TextBox)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtPrice")).Text;
string eventStartDttm = ((TextBox)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtStartDttm")).Text;
string eventEndDttm = ((TextBox)gvwCourseEvents.Rows[e.RowIndex].FindControl("txtEndDttm")).Text;
// update event start
BIZCourseDataSet eventDS = _bc.getEventDataSetById(eventId);
BIZCourseDataSet.T_BIZ002_COURSE_EVENTRow eventRow = (BIZCourseDataSet.T_BIZ002_COURSE_EVENTRow)eventDS.T_BIZ002_COURSE_EVENT.Rows[0];
eventRow.SCHEDULE = eventSchedule;
eventRow.LOCATION = eventLocation;
eventRow.PRICE = eventPrice;
eventRow.START_DTTM = DateTimeUtil.parseToDateTime(eventStartDttm);
eventRow.END_DTTM = DateTimeUtil.parseToDateTime(eventEndDttm);
_bc.UpdateTable(eventDS.T_BIZ002_COURSE_EVENT);
// end of add new event
gvwCourseEvents.EditIndex = -1;
// Rebind Grid view
this.EventDataBind();
}
protected void btnUpdateCourse_Click(object sender, EventArgs e)
{
string courseId = ViewState["CourseId"].ToString();
if (!string.IsNullOrEmpty(courseId))
{
BIZCourseDataSet courseDS = (BIZCourseDataSet)_bc.getCourseDataSetById(courseId);
BIZCourseDataSet.T_BIZ001_COURSERow courseRow = (BIZCourseDataSet.T_BIZ001_COURSERow)courseDS.T_BIZ001_COURSE.Rows[0];
if (fileUpload.HasFile)
{
string fileName = fileUpload.FileName;
string filePath = SaveFileToDisk(fileUpload.FileBytes, fileName, courseRow.USERID);
courseRow.COURSE_FILENAME = fileName;
courseRow.COURSE_IMAGEPATH = filePath;
}
courseRow.COURSE_DETAIL = this.description.Text;
courseRow.COURSE_NAME = this.courseName.Text;
courseRow.COURSE_TAG = this.courseTag.Text;
courseRow.COURSE_REG_URL = this.regURL.Text;
_bc.UpdateTable(courseDS.T_BIZ001_COURSE);
ShowMessage("Update Successfully!", MessageSeverity.Information);
Response.Redirect("~/Secure/Course/Courses.aspx");
}
}
// Adding new Event
protected void AddNewEvent(object sender, EventArgs e)
{
string eventSchedule = ((TextBox)gvwCourseEvents.FooterRow.FindControl("txtNewSchedule")).Text;
string eventLocation = ((TextBox)gvwCourseEvents.FooterRow.FindControl("txtNewLocation")).Text;
string eventPrice = ((TextBox)gvwCourseEvents.FooterRow.FindControl("txtNewPrice")).Text;
string eventStartDttm = ((TextBox)gvwCourseEvents.FooterRow.FindControl("txtNewStartDttm")).Text;
string eventEndDttm = ((TextBox)gvwCourseEvents.FooterRow.FindControl("txtNewEndDttm")).Text;
// below to add new event
string courseId = ViewState["CourseId"].ToString();
BIZCourseDataSet courseDS = new BIZCourseDataSet();
BIZCourseDataSet.T_BIZ002_COURSE_EVENTRow courseRow = courseDS.T_BIZ002_COURSE_EVENT.NewT_BIZ002_COURSE_EVENTRow();
courseRow.COURSEEVENTID = Utility.NewDataKey();
courseRow.COURSEID = courseId;
courseRow.SCHEDULE = eventSchedule;
courseRow.LOCATION = eventLocation;
courseRow.PRICE = eventPrice;
courseRow.START_DTTM = DateTimeUtil.parseToDateTime(eventStartDttm);
courseRow.END_DTTM = DateTimeUtil.parseToDateTime(eventEndDttm);
Utility.UpdateCommonFields(courseRow);
courseDS.T_BIZ002_COURSE_EVENT.AddT_BIZ002_COURSE_EVENTRow(courseRow);
_bc.UpdateTable(courseDS.T_BIZ002_COURSE_EVENT);
// end of add new event
// Rebind Grid view
this.EventDataBind();
}
protected void btnAddCourse_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(HttpContext.Current.User.Identity.Name))
{
ShowMessage("Please login to proceed this function!", MessageSeverity.Error);
}
else
{
BIZCourseDataSet courseDS = new BIZCourseDataSet();
BIZCourseDataSet.T_BIZ001_COURSERow courseRow = courseDS.T_BIZ001_COURSE.NewT_BIZ001_COURSERow();
courseRow.COURSEID = Utility.NewDataKey();
courseRow.USERID = HttpContext.Current.User.Identity.Name;
courseRow.COURSE_NAME = this.courseName.Text;
courseRow.COURSE_DETAIL = this.description.Text;
courseRow.COURSE_TAG = this.courseTag.Text;
courseRow.STATUS = Constants.CourseStatus.PENDING;
courseRow.COURSE_REG_URL = this.regURL.Text;
if (fileUpload.HasFile)
{
string fileName = fileUpload.FileName;
string filePath = SaveFileToDisk(fileUpload.FileBytes, fileName, courseRow.USERID);
courseRow.COURSE_FILENAME = fileName;
courseRow.COURSE_IMAGEPATH = filePath;
}
Utility.UpdateCommonFields(courseRow);
courseDS.T_BIZ001_COURSE.AddT_BIZ001_COURSERow(courseRow);
_bc.UpdateTable(courseDS.T_BIZ001_COURSE);
RedirectToCourseList();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
IList <CalendarDTO> tasksList = new List <CalendarDTO>();
CourseBCService _bc = new CourseBCService();
BIZCourseDataSet eventDS = (BIZCourseDataSet)_bc.getAllCourseEvents();
foreach (BIZCourseDataSet.T_BIZ002_COURSE_EVENTRow eventRow in eventDS.T_BIZ002_COURSE_EVENT.Rows)
{
tasksList.Add(new CalendarDTO
{
id = 1,
title = eventRow.SCHEDULE,
start = ConvertToDateString(eventRow.START_DTTM),
end = ConvertToDateString(eventRow.END_DTTM),
url = ""
});
}
System.Web.Script.Serialization.JavaScriptSerializer oSerializer =
new System.Web.Script.Serialization.JavaScriptSerializer();
string sJSON = oSerializer.Serialize(tasksList);
context.Response.Write(sJSON);
}
internal DataTable getCoursesByCriteriaAdmin(String searchKey, String startDttm, String endDttm)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPNameConstants.P_QUERY_COURSE_BY_ADMIN);
this.Helper.AssignParameterValues(cmd, searchKey, startDttm, endDttm);
this.Helper.Fill(ds.T_BIZ001_COURSE, cmd);
return(ds.T_BIZ001_COURSE);
}
internal DataTable getCoursesByParameter(String category, String location, String orderby)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPNameConstants.P_QUERY_COURSE_BY_PARAMETER);
this.Helper.AssignParameterValues(cmd, category, location, orderby);
this.Helper.Fill(ds.T_BIZ001_COURSE, cmd);
return(ds.T_BIZ001_COURSE);
}
public BIZCourseDataSet getCourseDSEventByCourseId(string courseId)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPNameConstants.P_QUERY_COURSE_EVENTS_BY_ID_FOR_VIEW);
this.Helper.AssignParameterValues(cmd, courseId);
this.Helper.Fill(ds.T_BIZ002_COURSE_EVENT, cmd);
return(ds);
}
public Onecalendar.BusinessEntity.BIZCourseDataSet getEventDataSetById(string eventId)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPNameConstants.P_QUERY_EVENT_BY_EVENT_ID);
this.Helper.AssignParameterValues(cmd, eventId);
this.Helper.Fill(ds.T_BIZ002_COURSE_EVENT, cmd);
return(ds);
}
internal DataTable getCoursesByFreetext(string searchKey)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPNameConstants.P_QUERY_COURSE_BY_FREE_TEXT);
this.Helper.AssignParameterValues(cmd, searchKey);
this.Helper.Fill(ds.T_BIZ001_COURSE, cmd);
return(ds.T_BIZ001_COURSE);
}
public DataSet QueryEventDataSetWithParameters(string SPName)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPName);
this.Helper.AssignParameterValues(cmd);
this.Helper.Fill(ds.T_BIZ002_COURSE_EVENT, cmd);
return(ds);
}
// below is the general query method with dynamic parameters passed in up to 3
public DataSet QueryDataSetWithParameters(string SPName, params string[] paramsArray)
{
BIZCourseDataSet ds = new BIZCourseDataSet();
DbCommand cmd = this.Helper.BuildDbCommand(SPName);
this.Helper.AssignParameterValues(cmd, paramsArray);
this.Helper.Fill(ds.T_BIZ001_COURSE, cmd);
return(ds);
}
private void UpdateCourse(CommandEventArgs e, String action)
{
String courseId = e.CommandArgument.ToString();
if (!String.IsNullOrEmpty(courseId))
{
BIZCourseDataSet courseDS = (BIZCourseDataSet)_bc.getCourseDataSetById(courseId);
if (courseDS.T_BIZ001_COURSE.Rows.Count > 0)
{
BIZCourseDataSet.T_BIZ001_COURSERow courseRow = (BIZCourseDataSet.T_BIZ001_COURSERow)courseDS.T_BIZ001_COURSE.Rows[0];
courseRow.STATUS = action;
_bc.UpdateTable(courseDS.T_BIZ001_COURSE);
ShowMessage("Record Updated!", MessageSeverity.Information);
}
}
CourseDataBind();
}
public void CastDataTable2TaskList(DataTable courseDT, IList <CourseDTO> tasksList, CourseBCService _bc)
{
foreach (DataRow item in courseDT.Rows)
{
if (item["COURSEID"] == null || String.IsNullOrEmpty(item["COURSEID"].ToString()))
{
continue;
}
CourseDTO course = new CourseDTO
{
CourseID = item["COURSEID"].ToString(),
CourseName = item["COURSE_NAME"].ToString(),
CourseDetail = item["COURSE_DETAIL"].ToString(),
CourseRegURL = item["COURSE_REG_URL"].ToString()
};
BIZCourseDataSet eventDS = (BIZCourseDataSet)_bc.getCourseDSEventByCourseId(item["COURSEID"].ToString());
List <EventDTO> eventList = new List <EventDTO>();
foreach (BIZCourseDataSet.T_BIZ002_COURSE_EVENTRow eventRow in eventDS.T_BIZ002_COURSE_EVENT.Rows)
{
if (!String.IsNullOrEmpty(eventRow.COURSEEVENTID))
{
EventDTO eventTO = new EventDTO
{
Id = eventRow.COURSEEVENTID,
Schedule = eventRow.SCHEDULE,
Location = eventRow.LOCATION,
Startdttm = ConvertToDateString(eventRow.START_DTTM),
Enddttm = ConvertToDateString(eventRow.END_DTTM),
};
eventList.Add(eventTO);
}
}
course.EventList = eventList;
tasksList.Add(course);
}
}
