public static bool AddSessionCourseMaterialNMember(ATTSessionCourse SC)
{
GetConnection getConn = new GetConnection();
try
{
OracleTransaction Tran = getConn.GetDbConn(Module.DLPDS).BeginTransaction();
try
{
DLLSessionCourseMaterial.AddSessionCourseMaterial(SC.LstSessionCourseMaterial, Tran);
DLLSessionCourseMember.AddSessionCourseMember(SC.LstSessionCourseMember, Tran);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
public static bool AddSessionCourseMaterialNMember(ATTSessionCourse SC)
{
try
{
return(DLLSessionCourse.AddSessionCourseMaterialNMember(SC));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ATTSessionCourse> GetSessionCourseList(int orgID, int programID, int sessionID, int CourseID, string ContainDefSessionCourseValue)
{
List <ATTSessionCourse> SessionCourseLST = new List <ATTSessionCourse>();
foreach (DataRow row in DLLSessionCourse.GetSessionCourseTable(orgID, programID, sessionID, CourseID).Rows)
{
ATTSessionCourse SC = new ATTSessionCourse
(
int.Parse(row["ORG_ID"].ToString()),
int.Parse(row["PROGRAM_ID"].ToString()),
int.Parse(row["SESSION_ID"].ToString()),
int.Parse(row["COURSE_ID"].ToString()),
row["FROM_DATE"].ToString(),
(row["TO_DATE"] == System.DBNull.Value) ? "" : row["TO_DATE"].ToString(),
"",
""
);
SC.CourseName = row["COURSE_TITLE"].ToString();
SC.LstSessionCourseMaterial = BLLSessionCourseMaterial.GetSessionCourseMaretial(SC.OrgID, SC.ProgramID, SC.SessionID, SC.CourseID, -1);
SC.LstSessionCourseMember = BLLSessionCourseMember.GetSessionCourseMember(SC.OrgID, SC.ProgramID, SC.SessionID, SC.CourseID);
SessionCourseLST.Add(SC);
}
if (ContainDefSessionCourseValue == "Y")
{
ATTSessionCourse Default = new ATTSessionCourse();
Default.CourseName = "----- Select Course -----";
SessionCourseLST.Insert(0, Default);
}
return(SessionCourseLST);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.ddlProgram_Rqd.SelectedIndex <= 0)
{
this.lblStatus.Text = "Save status";
this.lblStatusMessage.Text = "Please select program from list.";
this.ddlProgram_Rqd.Focus();
this.programmaticModalPopup.Show();
return;
}
if (this.ddlProgram_Rqd.SelectedIndex <= 0)
{
this.lblStatus.Text = "Save status";
this.lblStatusMessage.Text = "Please select session from list.";
this.ddlSession_Rqd.Focus();
this.programmaticModalPopup.Show();
return;
}
if (this.ddlProgram_Rqd.SelectedIndex <= 0)
{
this.lblStatus.Text = "Save status";
this.lblStatusMessage.Text = "Please select course from list.";
this.ddlSession_Rqd.Focus();
this.programmaticModalPopup.Show(); return;
}
List <ATTProgram> programLst = (List <ATTProgram>)Session["DLPDS_Program_List"];
List <ATTSession> sessionLst = programLst[this.ddlProgram_Rqd.SelectedIndex].SessionLST;
List <ATTSessionCourse> sessionCourseLst = sessionLst[this.ddlSession_Rqd.SelectedIndex].LstSessionCourse;
ATTSessionCourse SC = new ATTSessionCourse();
List <CourseMaterialControls> CMCList = new List <CourseMaterialControls>();
CMCList.Add(new CourseMaterialControls(this.fup1, this.chk1, this.lnkFile1));
CMCList.Add(new CourseMaterialControls(this.fup2, this.chk2, this.lnkFile2));
CMCList.Add(new CourseMaterialControls(this.fup3, this.chk3, this.lnkFile3));
CMCList.Add(new CourseMaterialControls(this.fup4, this.chk4, this.lnkFile4));
CMCList.Add(new CourseMaterialControls(this.fup5, this.chk5, this.lnkFile5));
foreach (CourseMaterialControls cmc in CMCList)
{
if (cmc.FileLink.Text == "Filename" && cmc.FileUploader.HasFile == true)
{
SC.LstSessionCourseMaterial.Add
(
new ATTSessionCourseMaterial
(
int.Parse(Session["OrgID"].ToString()),
int.Parse(this.ddlProgram_Rqd.SelectedValue),
int.Parse(this.ddlSession_Rqd.SelectedValue),
int.Parse(this.ddlCourse_Rqd.SelectedValue),
0,
cmc.FileUploader.FileName,
null,
"A",
cmc.FileUploader
)
);
}
else if (cmc.FileLink.Text != "Filename" && cmc.Checkbox.Checked == true)
{
SC.LstSessionCourseMaterial.Add
(
new ATTSessionCourseMaterial
(
int.Parse(Session["OrgID"].ToString()),
int.Parse(this.ddlProgram_Rqd.SelectedValue),
int.Parse(this.ddlSession_Rqd.SelectedValue),
int.Parse(this.ddlCourse_Rqd.SelectedValue),
int.Parse(cmc.FileLink.CommandArgument),
cmc.FileLink.Text,
null,
"D",
cmc.FileUploader
)
);
}
else if (cmc.FileLink.Text != "Filename" && cmc.FileUploader.HasFile == false)
{
SC.LstSessionCourseMaterial.Add
(
new ATTSessionCourseMaterial
(
int.Parse(Session["OrgID"].ToString()),
int.Parse(this.ddlProgram_Rqd.SelectedValue),
int.Parse(this.ddlSession_Rqd.SelectedValue),
int.Parse(this.ddlCourse_Rqd.SelectedValue),
int.Parse(cmc.FileLink.CommandArgument),
cmc.FileLink.Text,
null,
"N",
cmc.FileUploader
)
);
}
}
#region "Commented code of Course material items"
//List<FileUpload> lstFup = new List<FileUpload>();
//if (this.fup1.HasFile == true)
// lstFup.Add(this.fup1);
//if (this.fup2.HasFile == true)
// lstFup.Add(this.fup2);
//if (this.fup3.HasFile == true)
// lstFup.Add(this.fup3);
//if (this.fup4.HasFile == true)
// lstFup.Add(this.fup4);
//if (this.fup5.HasFile == true)
// lstFup.Add(this.fup5);
//foreach (FileUpload fup in lstFup)
//{
// SC.LstSessionCourseMaterial.Add
// (
// new ATTSessionCourseMaterial
// (
// 1,
// int.Parse(this.ddlProgram_Rqd.SelectedValue),
// int.Parse(this.ddlSession_Rqd.SelectedValue),
// int.Parse(this.ddlCourse_Rqd.SelectedValue),
// 0,
// fup.FileName,
// null,
// "A"
// )
// );
//}
#endregion
bool assigned;
foreach (GridViewRow grow in this.grdFacultymember.Rows)
{
CheckBox chk = ((CheckBox)grow.FindControl("chkSelect"));
if (grow.Cells[10].Text == "Y")
{
assigned = true;
}
else
{
assigned = false;
}
#region "comment"
//assigned = sessionCourseLst[this.ddlCourse_Rqd.SelectedIndex].LstSessionCourseMember.Exists
// (
// delegate(ATTSessionCourseMember mem)
// {
// return mem.OrgID == int.Parse(grow.Cells[1].Text) &&
// //mem.ProgramID == int.Parse(this.ddlProgram_Rqd.SelectedValue) &&
// //mem.SessionID == int.Parse(this.ddlSession_Rqd.SelectedValue) &&
// //mem.CourseID == int.Parse(this.ddlCourse_Rqd.SelectedValue) &&
// mem.FacultyID == int.Parse(grow.Cells[2].Text) &&
// mem.PID == int.Parse(grow.Cells[4].Text) &&
// mem.FromDate == grow.Cells[6].Text;
// //mem.AssignmentDate == grow.Cells[7].Text;
// }
// );
#endregion
if (chk.Checked == true)
{
ATTSessionCourseMember member = new ATTSessionCourseMember();
member.OrgID = int.Parse(grow.Cells[1].Text);
member.ProgramID = int.Parse(this.ddlProgram_Rqd.SelectedValue);
member.SessionID = int.Parse(this.ddlSession_Rqd.SelectedValue);
member.CourseID = int.Parse(this.ddlCourse_Rqd.SelectedValue);
member.FacultyID = int.Parse(grow.Cells[2].Text);
member.PID = int.Parse(grow.Cells[4].Text);;
member.FromDate = grow.Cells[6].Text;
member.AssignmentDate = grow.Cells[6].Text;
member.ToDate = grow.Cells[7].Text;
#region "delegate exists() commented"
//assigned = lstSC.Exists
// (
// delegate(ATTSessionCourseMember mem)
// {
// return mem.OrgID == member.OrgID &&
// mem.ProgramID == member.ProgramID &&
// mem.SessionID == member.SessionID &&
// mem.CourseID == member.CourseID &&
// mem.FacultyID == member.FacultyID &&
// mem.PID == member.PID &&
// mem.FromDate == member.FromDate &&
// mem.AssignmentDate == member.AssignmentDate;
// }
// );
#endregion
if (assigned == true)
{
member.Action = "N";
}
else
{
member.Action = "A";
}
SC.LstSessionCourseMember.Add(member);
}
else
{
if (assigned == true)
{
ATTSessionCourseMember member = new ATTSessionCourseMember();
member.OrgID = int.Parse(grow.Cells[1].Text);
member.ProgramID = int.Parse(this.ddlProgram_Rqd.SelectedValue);
member.SessionID = int.Parse(this.ddlSession_Rqd.SelectedValue);
member.CourseID = int.Parse(this.ddlCourse_Rqd.SelectedValue);
member.FacultyID = int.Parse(grow.Cells[2].Text);
member.PID = int.Parse(grow.Cells[4].Text);;
member.FromDate = grow.Cells[6].Text;
member.AssignmentDate = grow.Cells[6].Text;
member.ToDate = grow.Cells[7].Text;
member.Action = "D";
SC.LstSessionCourseMember.Add(member);
}
}
}
#region "Commented part"
//DataTable tbl = (DataTable)Session["DLPDS_FileTable"];
//foreach (DataRow row in tbl.Rows)
//{
// object raw = row["MaterialByte"];
// SC.LstSessionCourseMaterial.Add
// (
// new ATTSessionCourseMaterial
// (
// int.Parse(row["OrgID"].ToString()),
// int.Parse(row["ProgramID"].ToString()),
// int.Parse(row["SessionID"].ToString()),
// int.Parse(row["CourseID"].ToString()),
// int.Parse(row["MaterialID"].ToString()),
// row["MaterialName"].ToString(),
// (byte[])row["MaterialByte"],
// null,
// row["Action"].ToString()
// )
// );
//}
#endregion
try
{
foreach (ATTSessionCourseMaterial mat in SC.LstSessionCourseMaterial)
{
if (mat.Action == "A")
{
((FileUpload)mat.FileUploader).SaveAs(Server.MapPath("~") + "\\MODULES\\DLPDS\\COURSEMATERIAL\\" + mat.MaterialName);
}
}
BLLSessionCourse.AddSessionCourseMaterialNMember(SC);
foreach (ATTSessionCourseMaterial mat in SC.LstSessionCourseMaterial)
{
if (mat.Action == "D")
{
if (System.IO.File.Exists(Server.MapPath("~") + "\\MODULES\\DLPDS\\COURSEMATERIAL\\" + mat.MaterialName) == true)
{
System.IO.File.Delete(Server.MapPath("~") + "\\MODULES\\DLPDS\\COURSEMATERIAL\\" + mat.MaterialName);
}
}
}
SC.LstSessionCourseMaterial.RemoveAll
(
delegate(ATTSessionCourseMaterial m)
{
return(m.Action == "D");
}
);
sessionCourseLst[this.ddlCourse_Rqd.SelectedIndex].LstSessionCourseMaterial = SC.LstSessionCourseMaterial;
SC.LstSessionCourseMember.RemoveAll
(
delegate(ATTSessionCourseMember m)
{
return(m.Action == "D");
}
);
sessionCourseLst[this.ddlCourse_Rqd.SelectedIndex].LstSessionCourseMember = SC.LstSessionCourseMember;
this.ClearME();
this.lblStatus.Text = "Save status";
this.lblStatusMessage.Text = "Course material and member has been saved.";
this.ddlProgram_Rqd.SelectedIndex = 0;
this.ddlSession_Rqd.SelectedIndex = 0;
this.ddlCourse_Rqd.SelectedIndex = 0;
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
foreach (ATTSessionCourseMaterial mat in SC.LstSessionCourseMaterial)
{
if (mat.Action == "D")
{
if (System.IO.File.Exists(Server.MapPath("~") + "\\MODULES\\DLPDS\\COURSEMATERIAL\\" + mat.MaterialName) == true)
{
System.IO.File.Delete(Server.MapPath("~") + "\\MODULES\\DLPDS\\COURSEMATERIAL\\" + mat.MaterialName);
}
}
}
this.lblStatus.Text = "Save status";
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
finally
{
//Session["DLPDS_SessionCourse"] = new ATTSessionCourse();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.ddlPrograms.SelectedIndex == 0)
{
this.lblStatus.Text = "Save Error";
this.lblStatusMessage.Text = "Please Select Program";
this.programmaticModalPopup.Show();
return;
}
if (this.lstSession.SelectedIndex == -1)
{
this.lblStatusMessage.Text = "Save Error";
this.lblStatusMessage.Text = "Please Select a Session To Assign Course";
this.programmaticModalPopup.Show();
return;
}
int count = 0;
foreach (GridViewRow gvRow in this.grdCourses.Rows)
{
if (((CheckBox)gvRow.FindControl("chkSelect")).Checked == true)
{
count += 1;
}
}
if (count == 0)
{
this.lblStatus.Text = "Save Error";
this.lblStatusMessage.Text = "Please Select a Course To be Assigned in Session";
this.programmaticModalPopup.Show();
return;
}
List <ATTSessionCourse> LstSessionCourse = new List <ATTSessionCourse>();
List <ATTProgram> ProgramLST = (List <ATTProgram>)Session["Programs"];
ATTSession SessionLST = ProgramLST[ddlPrograms.SelectedIndex].SessionLST[lstSession.SelectedIndex];
try
{
foreach (GridViewRow row in grdCourses.Rows)
{
CheckBox CBSelect = (CheckBox)row.Cells[0].FindControl("chkSelect");
if (CBSelect.Checked == true && row.Cells[3].Text != "E")
{
ATTSessionCourse ObjSessionCourse = new ATTSessionCourse
(
(int)Session["OrgID"],
int.Parse(this.ddlPrograms.SelectedValue.ToString()),
int.Parse(this.lstSession.SelectedValue.ToString()),
int.Parse(row.Cells[1].Text.ToString()),
Session["NepDate"].ToString(),
"",
"",
"A"
);
LstSessionCourse.Add(ObjSessionCourse);
}
else if (CBSelect.Checked == false && row.Cells[3].Text == "E")
{
ATTSessionCourse ObjSessionCourse = new ATTSessionCourse
(
(int)Session["OrgID"],
int.Parse(this.ddlPrograms.SelectedValue.ToString()),
int.Parse(this.lstSession.SelectedValue.ToString()),
int.Parse(row.Cells[1].Text.ToString()),
Session["NepDate"].ToString(),
"",
"",
"D"
);
LstSessionCourse.Add(ObjSessionCourse);
}
}
if (BLLSessionCourse.SaveSessionCourse(LstSessionCourse) == true)
{
foreach (GridViewRow row in grdCourses.Rows)
{
CheckBox CBSelect = (CheckBox)row.Cells[0].FindControl("chkSelect");
if (CBSelect.Checked == true && row.Cells[3].Text != "E")
{
ATTSessionCourse ObjSessionCourse = new ATTSessionCourse
(
(int)Session["OrgID"],
int.Parse(this.ddlPrograms.SelectedValue.ToString()),
int.Parse(this.lstSession.SelectedValue.ToString()),
int.Parse(row.Cells[1].Text.ToString()),
Session["NepDate"].ToString(),
"",
"",
"E"
);
SessionLST.LstSessionCourse.Add(ObjSessionCourse);
}
else if (CBSelect.Checked == false && row.Cells[3].Text == "E")
{
SessionLST.LstSessionCourse.RemoveAll(delegate(ATTSessionCourse obj)
{
return(obj.OrgID == (int)Session["OrgID"] &&
obj.ProgramID == int.Parse(this.ddlPrograms.SelectedValue.ToString()) &&
obj.SessionID == int.Parse(this.lstSession.SelectedValue.ToString()) &&
obj.CourseID == int.Parse(row.Cells[1].Text.ToString()));
});
//ATTSessionCourse ObjSessionCourse = new ATTSessionCourse
// (
// (int)Session["OrgID"],
// int.Parse(this.ddlPrograms.SelectedValue.ToString()),
// int.Parse(this.lstSession.SelectedValue.ToString()),
// int.Parse(row.Cells[1].Text.ToString()),
// "12/12/2010",
// "",
// "",
// "D"
// );
//LstSessionCourse.Add(ObjSessionCourse);
}
}
}
ddlPrograms.SelectedIndex = -1;
lstSession.Items.Clear();
grdCourses.DataSource = "";
grdCourses.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
