public void GetOnlineTrainingSchedule()
{
objTraining = new clsOnlineTraining();
DataSet dsSchedule = objTraining.GetOnlineTrainingSchedule();
if (dsSchedule.Tables[0].Rows.Count > 0)
{
GRVScheduels.DataSource = dsSchedule.Tables[0];
GRVScheduels.DataBind();
}
}
public void GetOfficerInfoForOnlineTraining()
{
objTraining = new clsOnlineTraining();
string ScheduleId = Request.QueryString["ScheduleId"].ToString();
objTraining.ScheduleId = ScheduleId;
DataSet dsOfficer = objTraining.GetOfficerInfoForOnlineTraining();
if (dsOfficer.Tables[0].Rows.Count > 0)
{
DVAuthor.DataSource = dsOfficer.Tables[0];
DVAuthor.DataBind();
}
GetVideoFile();
}
public void GetOnlineTraining()
{
objTraining = new clsOnlineTraining();
DataSet dsTraining = objTraining.GetTrainingVideos();
if (dsTraining.Tables[0].Rows.Count > 0)
{
GRVTraining.DataSource = dsTraining.Tables[0];
GRVTraining.DataBind();
}
else
{
GRVTraining.EmptyDataText = "No Training Schedue Arranged for Today.";
GRVTraining.DataBind();
}
}
public void GetVideoFile()
{
objTraining = new clsOnlineTraining();
string ScheduleId = Request.QueryString["ScheduleId"].ToString();
objTraining.ScheduleId = ScheduleId;
DataSet dsTitle = objTraining.GetVideoTitle();
lblVideo.Text = "You Are Watching: " + dsTitle.Tables[0].Rows[0][0].ToString() + "!! Duration: " + dsTitle.Tables[0].Rows[0][1].ToString();
DataSet dsVideo = objTraining.GetVideoFile();
if (dsVideo.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = dsVideo.Tables[0];
GridView1.DataBind();
}
}
public void InsertOnLineTrainingSchedule()
{
objTraining = new clsOnlineTraining();
objTraining.Title = txtTitle.Text.Trim();
objTraining.ArrangeDate = Convert.ToDateTime(txtDate.Text.Trim());
objTraining.Duration = txtDuration.Text.Trim();
objTraining.Description = txtDescription.Text;
objTraining.TrainingVideo = (byte[])Session["VideoFileContent"];
objTraining.VideoFileName = Session["VideoFileName"].ToString();
objTraining.UserId = Convert.ToInt32(Session["UserLoginId"]);
int i = objTraining.InsertTrainingVideo();
if (i > 0)
{
Page.RegisterClientScriptBlock("Officer", "<script>alert('Schedule Announced')</script>");
}
else
{
Page.RegisterClientScriptBlock("Officer", "<script>alert('Bad Server Request')</script>");
}
}
