public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
lbl_CurrentMajor.Text = dtStudentServices.Rows[0]["strCaption"].ToString();
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("SELECT Course_Balance_View_BothSides.iYear, Course_Balance_View_BothSides.Sem, Course_Balance_View_BothSides.Shift, Course_Balance_View_BothSides.Course, Course_Balance_View_BothSides.Class, Course_Balance_View_BothSides.Student, Course_Balance_View_BothSides.FactorBalance, Course_Balance_View_BothSides.IsIncluded_AtRisk, Reg_Courses.IsInternshipCourse FROM Course_Balance_View_BothSides INNER JOIN Reg_Courses ON Course_Balance_View_BothSides.Course = Reg_Courses.strCourse WHERE (Reg_Courses.IsInternshipCourse = 1) AND (Course_Balance_View_BothSides.iYear = " + iYear + ") AND (Course_Balance_View_BothSides.Sem = " + iSem + ") AND (Course_Balance_View_BothSides.Student = N'" + studentid + "')", sc);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
if (dt.Rows.Count > 0)
{
//Continue
}
else
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request (Only for students registered internship courses).";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
}
protected void drp_Course_SelectedIndexChanged(object sender, EventArgs e)
{
if (drp_Course.SelectedItem.Value != "---Select a Course---")
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyCourseId(studentid, connstr.Conn_string, iYear, iSem, drp_Course.SelectedItem.Value);
if (dt.Rows.Count > 0)
{
lbl_CourseCode.Text = drp_Course.SelectedItem.Value;
lbl_Instructor.Text = dt.Rows[0]["strLecturerDescEn"].ToString();
lbl_InstructorEmail.Text = LibraryMOD.GetAdvisorEmail(lbl_Instructor.Text);
}
}
else
{
lbl_CourseCode.Text = "";
lbl_Instructor.Text = "";
lbl_InstructorEmail.Text = "";
}
}
public void bindmyattendancewrnigns()
{
int iCSem = 0;
int iCYear = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out iCSem);
Connection_StringCLS myConnection_String = new Connection_StringCLS(Campus);
SqlConnection sc = new SqlConnection(myConnection_String.Conn_string);
//SqlCommand cmd = new SqlCommand("SELECT [strCourse],max([byteWarningType]) as max FROM [ECTData].[dbo].[Reg_Students_Warning] where intStudyYear=@intStudyYear and byteSemester=@byteSemester and lngStudentNumber=@lngStudentNumber GROUP BY [strCourse] order by strCourse", sc);
SqlCommand cmd = new SqlCommand("SELECT iYear, Sem, Student, Course, Warning FROM Warning_Both_Side WHERE (iYear = @intStudyYear) AND (Sem = @byteSemester) AND (Student=@lngStudentNumber) order by course asc", sc);
cmd.Parameters.AddWithValue("@intStudyYear", iCYear);
cmd.Parameters.AddWithValue("@byteSemester", iCSem);
cmd.Parameters.AddWithValue("@lngStudentNumber", Session["CurrentStudent"].ToString());//BAM1906016 Session["CurrentStudent"].ToString()
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
}
}
public void getsemesters()
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetSemestersbyTerm(iYear, iSem);
if (dt.Rows.Count > 0)
{
drp_Semester.DataSource = dt;
drp_Semester.DataTextField = "LongDesc";
drp_Semester.DataValueField = "Term";
drp_Semester.DataBind();
drp_Semester.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Semester---", "---Select a Semester---"));
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
else
{
drp_Semester.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Semester---", "---Select a Semester---"));
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
}
public void getcourses()
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyStudentId(studentid, connstr.Conn_string, iYear, iSem);
if (dt.Rows.Count > 0)
{
RepterDetails.DataSource = dt;
RepterDetails.DataBind();
//drp_Course.DataSource = dt;
//drp_Course.DataTextField = "Course";
//drp_Course.DataValueField = "Code";
//drp_Course.DataBind();
//drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
//else
//{
// drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
//}
}
private void ExportStudentTimeTable()
{
ReportDocument myReport = new ReportDocument();
try
{
DataSet rptDS = new DataSet();
rptDS = (DataSet)Session["ReportDS"];
string reportPath = Server.MapPath("Reports/StudentTimeTable_eBooksRPT.rpt");
myReport.Load(reportPath);
myReport.SetDataSource(rptDS);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
int iSemester = Convert.ToInt32("0" + iSem.ToString());
int iRegYear = Convert.ToInt32("0" + iYear.ToString());
string sNo = Session["CurrentStudent"].ToString();
TextObject txt;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["txtTitle"];
txt.Text = GetCaption();
txt.Text += " - Total Credit Hours: [ " + LibraryMOD.GetStudentRegisteredCredit(iRegYear, iSemester, sNo, Convert.ToInt32((InitializeModule.EnumCampus) this.Campus)).ToString() + " ]";
txt = (TextObject)myReport.ReportDefinition.ReportObjects["txtMajor"];
txt.Text = LibraryMOD.GetStudentMajor(this.Campus, sNo);
//string sSemester = LibraryMOD.GetSemesterString(iSemester);
txt = (TextObject)myReport.ReportDefinition.ReportObjects["txtAcademicYear"];
txt.Text += " - " + iRegYear.ToString() + " / " + (iRegYear + 1).ToString() + " " + sSemester;
txt = (TextObject)myReport.ReportDefinition.ReportObjects["UserTXT"];
string sUserName = Session["CurrentUserName"].ToString();
txt.Text = "/ " + sUserName;
myReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Page.Response, true, "ECTReport");
}
catch (Exception exp)
{
Console.WriteLine("{0} Exception caught.", exp);
}
finally
{
myReport.Close();
myReport.Dispose();
}
}
public void getcourses()
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyStudentId(studentid, connstr.Conn_string, iYear, iSem);
if (dt.Rows.Count > 0)
{
chk_Courses.DataSource = dt;
chk_Courses.DataTextField = "Course";
chk_Courses.DataValueField = "strLecturerDescEn";
chk_Courses.DataBind();
}
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsIDbyNationality(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
txt_StudentContact1.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
lbl_Major.Text = dtStudentServices.Rows[0]["strCaption"].ToString();
lbl_GraduationSemester.Text = dtStudentServices.Rows[0]["byteGraduationSemester"].ToString();
lbl_GraduationYear.Text = dtStudentServices.Rows[0]["intGraduationYear"].ToString();
lbl_DOB.Text = Convert.ToDateTime(dtStudentServices.Rows[0]["dateBirth"]).ToString("dd/MM/yyyy");
string cancelreason = dtStudentServices.Rows[0]["byteCancelReason"].ToString();
if (cancelreason != "3")
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request at this time (Only for Graduated Students)";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
}
}
//protected void btnReset_Click(object sender, EventArgs e)
//{
//}
public void loadstudentprofile()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentProfile = services.GetStudentDetailsForProfile(studentid, connstr.Conn_string);
string sCampus = Session["CurrentCampus"].ToString();
if (dtStudentProfile.Rows.Count > 0)
{
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
txt_AcademicYear.Text = iYear.ToString();
txt_CurrentSemester.Text = sSemester.ToString();
txtFisrtName.Text = dtStudentProfile.Rows[0]["strLastDescEn"].ToString();
txtDateofBirth.Text = Convert.ToDateTime(dtStudentProfile.Rows[0]["dateBirth"]).ToString("dd/MM/yyyy");
txtEmail.Text = dtStudentProfile.Rows[0]["sECTemail"].ToString();
txtPhoneNumber.Text = dtStudentProfile.Rows[0]["Phone"].ToString();
txt_StudentID.Text = dtStudentProfile.Rows[0]["lngStudentNumber"].ToString();
txt_Major.Text = dtStudentProfile.Rows[0]["strCaption"].ToString();
txt_Nationality.Text = dtStudentProfile.Rows[0]["strNationalityDescEn"].ToString();
string sPic = dtStudentProfile.Rows[0]["strStudentPic"].ToString();
hdfiUnifiedID.Value = dtStudentProfile.Rows[0]["iUnifiedID"].ToString();
string sDir = "Students";
if (sCampus == "Males")
{
txt_Gender.Text = "Male";
}
else
{
txt_Gender.Text = "Female";
}
}
}
private void Retrieve()
{
List <TimeTable> myTimeTables = new List <TimeTable>();
TimeTableDAL myTimeTableDAL = new TimeTableDAL();
DataSet Ds = new DataSet();
try
{
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string sStudentNumber = this.sNo;
int iSemester = Convert.ToInt32("0" + iSem.ToString());
int iRegYear = Convert.ToInt32("0" + iYear.ToString());
lbl_TitleYearSem.Text = " - " + iRegYear.ToString() + " / " + (iRegYear + 1).ToString() + " " + sSemester;
lbl_TitleStudent.Text = GetCaption();
lbl_TitleStudent.Text += " - Total Credit Hours: [ " + LibraryMOD.GetStudentRegisteredCredit(iRegYear, iSemester, sNo, Convert.ToInt32((InitializeModule.EnumCampus) this.Campus)).ToString() + " ]";
lbl_TitleMajor.Text = LibraryMOD.GetStudentMajor(this.Campus, sNo);
myTimeTables = myTimeTableDAL.GetStudentTimeTable(sStudentNumber, iYear, iSem, this.Campus);
Ds = Prepare_TimeTable_Report(myTimeTables);
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
Session["ReportDS"] = Ds;
}
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
lbl_CurrentMajor.Text = dtStudentServices.Rows[0]["strCaption"].ToString();
if (dtStudentServices.Rows[0]["strDegree"].ToString() == "2")
{
//Not allowed for remedial students
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request at this time (Not allowed for remedial students).";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
return;
}
}
}
public void sentdatatoSPLIst()
{
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string login = "******"; //give your username here
string password = "******"; //give your password
var securePassword = new SecureString();
foreach (char c in password)
{
securePassword.AppendChar(c);
}
string siteUrl = "https://ectacae.sharepoint.com/sites/ECTPortal/eservices/studentservices";
ClientContext clientContext = new ClientContext(siteUrl);
Microsoft.SharePoint.Client.List myList = clientContext.Web.Lists.GetByTitle("Students_Requests");
ListItemCreationInformation itemInfo = new ListItemCreationInformation();
Microsoft.SharePoint.Client.ListItem myItem = myList.AddItem(itemInfo);
string refno = Create16DigitString();
myItem["Title"] = refno;
//myItem["RequestID"] = refno;
myItem["Year"] = iYear;
myItem["Semester"] = iSem;
myItem["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )";
myItem["RequestNote"] = txt_Remarks.Text.Trim();
myItem["ServiceID"] = lbl_ServiceID.Text;
myItem["Fees"] = hdf_Price.Value;
//myItem["Requester"] = clientContext.Web.EnsureUser(hdf_StudentEmail.Value);
myItem["Requester"] = clientContext.Web.EnsureUser("*****@*****.**");
myItem["StudentID"] = lbl_StudentID.Text;
myItem["StudentName"] = lbl_StudentName.Text;
myItem["Contact"] = lbl_StudentContact.Text;
myItem["Finance"] = clientContext.Web.EnsureUser("*****@*****.**");
myItem["FinanceAction"] = "Initiate";
myItem["FinanceNote"] = "";
myItem["Host"] = clientContext.Web.EnsureUser("*****@*****.**");
myItem["HostAction"] = "Initiate";
myItem["HostNote"] = "";
//myItem["Provider"] = "";
myItem["ProviderAction"] = "Initiate";
myItem["ProviderNote"] = "";
myItem["Status"] = "Finance Approval Needed";
//myItem["Modified"] = DateTime.Now;
//myItem["Created"] = DateTime.Now;
//myItem["Created By"] = hdf_StudentEmail.Value;
//myItem["Modified By"] = hdf_StudentEmail.Value;
try
{
myItem.Update();
//if (flp_Upload.HasFile)
//{
// var attachment = new AttachmentCreationInformation();
// flp_Upload.SaveAs(Server.MapPath("~/Upload/" + flp_Upload.FileName));
// string FileUrl = Server.MapPath("~/Upload/" + flp_Upload.FileName);
// string filePath = FileUrl;
// attachment.FileName = Path.GetFileName(filePath);
// attachment.ContentStream = new MemoryStream(System.IO.File.ReadAllBytes(filePath));
// Attachment att = myItem.AttachmentFiles.Add(attachment);
//}
var onlineCredentials = new SharePointOnlineCredentials(login, securePassword);
clientContext.Credentials = onlineCredentials;
clientContext.ExecuteQuery();
//string FileUrls = Server.MapPath("~/Upload/" + flp_Upload.FileName);
//System.IO.File.Delete(FileUrls);
lbl_Msg.Text = "Request (ID# " + refno + ") Generated Successfully";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//Console.ReadLine();
}
protected void lnk_Generate_Click(object sender, EventArgs e)
{
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string refno = Create16DigitString();
string sACC = "0200000";
if (Session["CurrentCampus"].ToString() == "Males")
{
sACC = "0100000";
}
else
{
sACC = "0200000";
}
string languageoption = "";
if (Session["LanguageOption"].ToString() == "True")
{
languageoption = "<b>Language:</b> " + ddlLanguage.SelectedItem.Text + "";
}
// Create a DataTable
DataTable dtSPList = new DataTable();
dtSPList.Clear();
dtSPList.Columns.Add("Title");
dtSPList.Columns.Add("Year");
dtSPList.Columns.Add("Semester");
dtSPList.Columns.Add("Request");
dtSPList.Columns.Add("RequestNote");
dtSPList.Columns.Add("ServiceID");
dtSPList.Columns.Add("Fees");
dtSPList.Columns.Add("Requester");
dtSPList.Columns.Add("StudentID");
dtSPList.Columns.Add("StudentName");
dtSPList.Columns.Add("Contact");
dtSPList.Columns.Add("Finance");
dtSPList.Columns.Add("FinanceAction");
dtSPList.Columns.Add("FinanceNote");
dtSPList.Columns.Add("Host");
dtSPList.Columns.Add("HostAction");
dtSPList.Columns.Add("HostNote");
dtSPList.Columns.Add("ProviderAction");
dtSPList.Columns.Add("ProviderNote");
dtSPList.Columns.Add("Status");
// Add items using Add method
DataRow dr = dtSPList.NewRow();
dr["Title"] = refno;
dr["Year"] = iYear;
dr["Semester"] = iSem;
dr["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " ) <br/>" + languageoption + "<br/>";
dr["RequestNote"] = txt_Remarks.Text.Trim();
dr["ServiceID"] = lbl_ServiceID.Text;
dr["Fees"] = hdf_Price.Value;
dr["Requester"] = hdf_StudentEmail.Value;
dr["StudentID"] = lbl_StudentID.Text;
dr["StudentName"] = lbl_StudentName.Text;
dr["Contact"] = lbl_StudentContact.Text;
dr["Finance"] = Session["FinanceEmail"].ToString();
dr["FinanceAction"] = "Initiate";
dr["FinanceNote"] = "";
dr["Host"] = Session["HostEmail"].ToString();
dr["HostAction"] = "Initiate";
dr["HostNote"] = "";
dr["ProviderAction"] = "Initiate";
dr["ProviderNote"] = "";
dr["Status"] = "Finance Approval Needed";
dtSPList.Rows.Add(dr);
//sentdatatoSPLIst();
Session["CurrentService"] = "Student Services: " + lbl_ServiceID.Text + "";
Session["CurrentServiceName"] = lbl_ServiceNameEn.Text;
Session["CurrentServiceAmount"] = string.Format("{0:f}", hdf_Price.Value);
Session["CurrentdtSPList"] = dtSPList;
Session["CurrentAccount"] = sACC;
Session["cancelpage"] = "ECT_SAR_SREG_FRM_021.aspx?ServiceID=" + lbl_ServiceID.Text + "";
Response.Redirect("Student_Services_HostedPayment.aspx");
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
InitializeModule.EnumCampus CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
string sSID = Session["CurrentStudent"].ToString();
decimal dAmount = LibraryMOD.GetStudentUptodateBalanceBTS(sSID, CurrentCampus);
lbl_Balance.Text = string.Format("{0:f}", dAmount);
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
string cancelreason = dtStudentServices.Rows[0]["byteCancelReason"].ToString();
if (lbl_ServiceID.Text == "1004")//Service # 1004 this must be for graduated and expected to Graduate only
{
//lbl_En.Text = "Graduation Letter";
//lbl_Ar.Text = "طلب افادة تخرج";
//Non-Graduated Students Check
if (cancelreason != "3" && cancelreason != "25")
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request at this time (Only for Graduated and Expected to Graduate Students).";
lbl_Msg.Visible = true;
div_msg.Visible = true;
hyp_Paynow.Visible = false;
lnk_Generate.Enabled = false;
}
else
{
//If Graduated Checking the Uptodate Balance. If balance <=0 then allow to proceed else proceed for payment.
InitializeModule.EnumCampus CurrentCampus1 = (InitializeModule.EnumCampus)Session["CurrentCampus"];
string sSID1 = Session["CurrentStudent"].ToString();
decimal dAmount1 = LibraryMOD.GetStudentUptodateBalanceBTS(sSID1, CurrentCampus1);
lbl_Balance.Text = string.Format("{0:f}", dAmount1);
if (dAmount1 <= 0)
{
//Proceed for Request Generation
}
else
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request at this time (UpToDate Balance: AED " + string.Format("{0:f}", dAmount1) + " is pending.)";
lbl_Msg.Visible = true;
div_msg.Visible = true;
hyp_Paynow.Visible = true;
hyp_Paynow.NavigateUrl = "Balance?amt=" + string.Format("{0:f}", dAmount1) + "";
lnk_Generate.Enabled = false;
}
}
}
else
{
//Non-Graduated Students Check
//if (cancelreason != "3")
//{
// div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
// lbl_Msg.Text = "You are not allowed to generate this request at this time (Only for Graduated Students)";
// lbl_Msg.Visible = true;
// div_msg.Visible = true;
// hyp_Paynow.Visible = false;
// lnk_Generate.Enabled = false;
//}
//else
//{
//If Graduated Checking the Uptodate Balance. If balance <=0 then allow to proceed else proceed for payment.
InitializeModule.EnumCampus CurrentCampus1 = (InitializeModule.EnumCampus)Session["CurrentCampus"];
string sSID1 = Session["CurrentStudent"].ToString();
decimal dAmount1 = LibraryMOD.GetStudentUptodateBalanceBTS(sSID1, CurrentCampus1);
lbl_Balance.Text = string.Format("{0:f}", dAmount1);
if (dAmount1 <= 0)
{
//Proceed for Request Generation
}
else
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request at this time (UpToDate Balance: AED " + string.Format("{0:f}", dAmount1) + " is pending.)";
lbl_Msg.Visible = true;
div_msg.Visible = true;
hyp_Paynow.Visible = true;
hyp_Paynow.NavigateUrl = "Balance?amt=" + string.Format("{0:f}", dAmount1) + "";
lnk_Generate.Enabled = false;
}
//}
}
//if (lbl_ServiceID.Text == "1005")
//{
// lbl_En.Text = "Transcript";
// lbl_Ar.Text = "طلب كشف علامات";
//}
}
}
protected void lnk_Generate_Click(object sender, EventArgs e)
{
if (drp_Course.SelectedItem.Value != "---Select a Course---")
{
//sentdatatoSPLIst();
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string refno = Create16DigitString();
string sACC = "0200000";
if (Session["CurrentCampus"].ToString() == "Males")
{
sACC = "0100000";
}
else
{
sACC = "0200000";
}
string languageoption = "";
if (Session["LanguageOption"].ToString() == "True")
{
languageoption = "<b>Language:</b> " + ddlLanguage.SelectedItem.Text + "";
}
// Create a DataTable
DataTable dtSPList = new DataTable();
dtSPList.Clear();
dtSPList.Columns.Add("Title");
dtSPList.Columns.Add("Year");
dtSPList.Columns.Add("Semester");
dtSPList.Columns.Add("Request");
dtSPList.Columns.Add("RequestNote");
dtSPList.Columns.Add("ServiceID");
dtSPList.Columns.Add("Fees");
dtSPList.Columns.Add("Requester");
dtSPList.Columns.Add("StudentID");
dtSPList.Columns.Add("StudentName");
dtSPList.Columns.Add("Contact");
dtSPList.Columns.Add("Finance");
dtSPList.Columns.Add("FinanceAction");
dtSPList.Columns.Add("FinanceNote");
dtSPList.Columns.Add("Host");
dtSPList.Columns.Add("HostAction");
dtSPList.Columns.Add("HostNote");
dtSPList.Columns.Add("ProviderAction");
dtSPList.Columns.Add("ProviderNote");
dtSPList.Columns.Add("Status");
// Add items using Add method
DataRow dr = dtSPList.NewRow();
dr["Title"] = refno;
dr["Year"] = iYear;
dr["Semester"] = iSem;
dr["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )<br/><b>Major:</b> " + lbl_CurrentMajor.Text + "<br/><b>Course Semester:</b> " + drp_Semester.SelectedItem.Text + "<br/><b>Course Title:</b> " + drp_Course.SelectedItem.Text + "<br/><b>Course Code:</b> " + lbl_CourseCode.Text + "<br/><b>Instructor’s Name:</b> " + lbl_Instructor.Text + "<br/><b>Request Details:</b> " + txt_Remarks.Text.Trim() + "<br/>" + languageoption + "<br/>";
dr["RequestNote"] = txt_Remarks.Text.Trim();
dr["ServiceID"] = lbl_ServiceID.Text;
dr["Fees"] = hdf_Price.Value;
dr["Requester"] = hdf_StudentEmail.Value;
dr["StudentID"] = lbl_StudentID.Text;
dr["StudentName"] = lbl_StudentName.Text;
dr["Contact"] = lbl_StudentContact.Text;
dr["Finance"] = Session["FinanceEmail"].ToString();
dr["FinanceAction"] = "Initiate";
dr["FinanceNote"] = "";
dr["Host"] = Session["HostEmail"].ToString();
dr["HostAction"] = "Initiate";
dr["HostNote"] = "";
dr["ProviderAction"] = "Initiate";
dr["ProviderNote"] = "";
dr["Status"] = "Finance Approval Needed";
dtSPList.Rows.Add(dr);
//sentdatatoSPLIst();
if (flp_Upload.HasFile)
{
//var attachment = new AttachmentCreationInformation();
flp_Upload.SaveAs(Server.MapPath("~/Upload/" + flp_Upload.FileName));
string FileUrl = Server.MapPath("~/Upload/" + flp_Upload.FileName);
Session["filePath"] = FileUrl;
//string filePath = FileUrl;
//attachment.FileName = Path.GetFileName(filePath);
//attachment.ContentStream = new MemoryStream(System.IO.File.ReadAllBytes(filePath));
//Attachment att = myItem.AttachmentFiles.Add(attachment);
}
Session["CurrentService"] = "Student Services: " + lbl_ServiceID.Text + "";
Session["CurrentServiceName"] = lbl_ServiceNameEn.Text;
Session["CurrentServiceAmount"] = string.Format("{0:f}", hdf_Price.Value);
Session["CurrentdtSPList"] = dtSPList;
Session["CurrentAccount"] = sACC;
Session["cancelpage"] = "ECT_SAR_SARO_FRM_018.aspx?ServiceID=" + lbl_ServiceID.Text + "";
Response.Redirect("Student_Services_HostedPayment.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["CurrentURL"] = HttpContext.Current.Request.Url.AbsoluteUri;
if (Session["isRunning"] != null)
{
if (Convert.ToInt32(Session["isRunning"]) == 0)
{
//setlogin();
//return;
//showErr("Session is expired, Login again please...");
ClearSession();
Response.Redirect("Login.aspx");
}
}
else
{
// showErr("Session is expired, Login again please...");
ClearSession();
Response.Redirect("Login.aspx");
}
if (Session["CurrentCampus"] != null)
{
string sCampus = Session["CurrentCampus"].ToString();
Campus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
//Campus_ddl.SelectedValue = ((int)Campus).ToString();
string sConn = "";
Connection_StringCLS ConnectionString;
switch (Campus)
{
case InitializeModule.EnumCampus.Males:
ConnectionString = new Connection_StringCLS(InitializeModule.EnumCampus.Males);
sConn = ConnectionString.Conn_string;
break;
case InitializeModule.EnumCampus.Females:
ConnectionString = new Connection_StringCLS(InitializeModule.EnumCampus.Females);
sConn = ConnectionString.Conn_string;
break;
}
}
if (!IsPostBack)
{
//Session.RemoveAll();
int iRSem = 0;
int iRYear = LibraryMOD.SeperateTerm(LibraryMOD.GetRegTerm(), out iRSem);
Session["RegYear"] = iRYear;
Session["RegSemester"] = iRSem;
int iCSem = 0;
int iCYear = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out iCSem);
Session["CurrentYear"] = iCYear;
Session["CurrentSemester"] = iCSem;
Generate_Menu();
if (Session["CurrentStudentName"] == null)
{
Session["CurrentStudentName"] = "Student";
}
lblUser.Text = Session["CurrentStudentName"].ToString();
lblUser1.Text = Session["CurrentStudentName"].ToString();
//if (Session["CurrentStudent"] == null)
//{
//}
//else
//{
getprofilepic();
//}
}
if (Session["MainRoot"] != null)
{
// myRoot = (TreeNode)Session["MainRoot"];
}
if (Session["CurrentUserName"] != null)
{
//lnkLogin.Text = "Logout";
}
else
{
//lnkLogin.Text = "Login";
}
}
public void loadstudentprofile()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentProfile = services.GetStudentDetailsForProfile(studentid, connstr.Conn_string);
string sCampus = Session["CurrentCampus"].ToString();
if (dtStudentProfile.Rows.Count > 0)
{
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
//txt_AcademicYear.Text = iYear.ToString();
//txt_CurrentSemester.Text = sSemester.ToString();
//txtFisrtName.Text = dtStudentProfile.Rows[0]["strLastDescEn"].ToString();
//txtDateofBirth.Text = Convert.ToDateTime(dtStudentProfile.Rows[0]["dateBirth"]).ToString("dd/MM/yyyy");
lbl_Email_ID.Text = dtStudentProfile.Rows[0]["sECTemail"].ToString();
//txtPhoneNumber.Text = dtStudentProfile.Rows[0]["Phone"].ToString();
lbl_Student_ID.Text = dtStudentProfile.Rows[0]["lngStudentNumber"].ToString();
lbl_Current_Major.Text = dtStudentProfile.Rows[0]["strCaption"].ToString();
string acceptance_type = "";
string acceptance_condition = "";
if (dtStudentProfile.Rows[0]["iAcceptanceType"].ToString() == "1")
{
acceptance_type = "Permanently Accepted";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceType"].ToString() == "2")
{
acceptance_type = "One Academic Semester(Conditional)";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceType"].ToString() == "3")
{
acceptance_type = "Two Academic Semesters(Conditional)";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceType"].ToString() == "4")
{
acceptance_type = "One Academic Year(Conditional)";
}
if (dtStudentProfile.Rows[0]["iAcceptanceCondition"].ToString() == "1")
{
acceptance_condition = "All conditions have been met";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceCondition"].ToString() == "2")
{
acceptance_condition = "High school equivalency needed";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceCondition"].ToString() == "3")
{
acceptance_condition = "EmSAT needed";
}
else if (dtStudentProfile.Rows[0]["iAcceptanceCondition"].ToString() == "4")
{
acceptance_condition = "Major requirements are not met";
}
lbl_Acceptance_Type.Text = acceptance_type;
lbl_Acceptance_Condition.Text = acceptance_condition;
Session["Student_AT"] = acceptance_type;
Session["Student_AC"] = acceptance_condition;
if (dtStudentProfile.Rows[0]["byteCancelReason"].ToString() == "")
{
lbl_Status.Text = "Active";
}
else
{
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("select strReasonDesc from Lkp_Reasons where byteReason=@byteReason", sc);
cmd.Parameters.AddWithValue("@byteReason", dtStudentProfile.Rows[0]["byteCancelReason"].ToString());
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
if (dt.Rows.Count > 0)
{
lbl_Status.Text = dt.Rows[0]["strReasonDesc"].ToString();;
}
else
{
lbl_Status.Text = "Active";
}
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
//txt_Nationality.Text = dtStudentProfile.Rows[0]["strNationalityDescEn"].ToString();
//string sPic = dtStudentProfile.Rows[0]["strStudentPic"].ToString();
//hdfiUnifiedID.Value = dtStudentProfile.Rows[0]["iUnifiedID"].ToString();
//string sDir = "Students";
//if (sCampus == "Males")
//{
// txt_Gender.Text = "Male";
//}
//else
//{
// txt_Gender.Text = "Female";
//}
}
}
public void sentdatatoSPLIst()
{
string careeractivities = "";
string otheractivities = "";
string prefereddays = "";
string preferedtime = "";
string k = "";
for (int i = 0; i < chk_CareerActivities.Items.Count; i++)
{
if (chk_CareerActivities.Items[i].Selected)
{
k = k + chk_CareerActivities.Items[i].Value + ";";
}
}
careeractivities = k;
string j = "";
for (int n = 0; n < chk_OtherActivities.Items.Count; n++)
{
if (chk_OtherActivities.Items[n].Selected)
{
j = j + chk_OtherActivities.Items[n].Value + ";";
}
}
otheractivities = j;
string a = "";
for (int q = 0; q < chk_PreferedDays.Items.Count; q++)
{
if (chk_PreferedDays.Items[q].Selected)
{
a = a + chk_PreferedDays.Items[q].Value + ";";
}
}
prefereddays = a;
preferedtime = "From: " + Convert.ToDateTime(txt_From.Text).ToString("hh:mm tt") + " To: " + Convert.ToDateTime(txt_To.Text).ToString("hh:mm tt") + "";
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string languageoption = "";
if (Session["LanguageOption"].ToString() == "True")
{
languageoption = "<b>Language:</b> " + ddlLanguage.SelectedItem.Text + "";
}
string login = "******"; //give your username here
string password = "******"; //give your password
var securePassword = new SecureString();
foreach (char c in password)
{
securePassword.AppendChar(c);
}
string siteUrl = "https://ectacae.sharepoint.com/sites/ECTPortal/eservices/studentservices";
ClientContext clientContext = new ClientContext(siteUrl);
Microsoft.SharePoint.Client.List myList = clientContext.Web.Lists.GetByTitle("Students_Requests");
ListItemCreationInformation itemInfo = new ListItemCreationInformation();
Microsoft.SharePoint.Client.ListItem myItem = myList.AddItem(itemInfo);
string refno = Create16DigitString();
myItem["Title"] = refno;
//myItem["RequestID"] = refno;
myItem["Year"] = iYear;
myItem["Semester"] = iSem;
myItem["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )<br/><b>Major:</b> " + lbl_Major.Text + "<br/><b>Student Contact #:</b> " + lbl_StudentContact.Text + "<br/><b>Career Development Activities (Workshop/Seminar):</b> " + careeractivities + "<br/><b>Career Service:</b> " + otheractivities + "<br/><b>Comments:</b> " + txt_Comments.Text + "<br/><b>Prefered Timing:</b> " + preferedtime + "<br/><b>Prefered Days:</b> " + prefereddays + "<br/><b>Other Suggestion for Alumni services & Activities:</b> " + txt_Remarks.Text + "<br/>" + languageoption + "<br/>";
myItem["RequestNote"] = txt_Remarks.Text.Trim();
myItem["ServiceID"] = lbl_ServiceID.Text;
myItem["Fees"] = hdf_Price.Value;
myItem["Requester"] = clientContext.Web.EnsureUser(hdf_StudentEmail.Value);
//myItem["Requester"] = clientContext.Web.EnsureUser("*****@*****.**");
myItem["StudentID"] = lbl_StudentID.Text;
myItem["StudentName"] = lbl_StudentName.Text;
myItem["Contact"] = lbl_StudentContact.Text;
myItem["Finance"] = clientContext.Web.EnsureUser(Session["FinanceEmail"].ToString());
myItem["FinanceAction"] = "Initiate";
myItem["FinanceNote"] = "";
myItem["Host"] = clientContext.Web.EnsureUser(Session["HostEmail"].ToString());//Session["HostEmail"].ToString();
myItem["HostAction"] = "Initiate";
myItem["HostNote"] = "";
//myItem["Provider"] = "";
myItem["ProviderAction"] = "Initiate";
myItem["ProviderNote"] = "";
myItem["Status"] = "Finance Approval Needed";
//myItem["Modified"] = DateTime.Now;
//myItem["Created"] = DateTime.Now;
//myItem["Created By"] = hdf_StudentEmail.Value;
//myItem["Modified By"] = hdf_StudentEmail.Value;
try
{
myItem.Update();
//if (flp_Upload.HasFile)
//{
// var attachment = new AttachmentCreationInformation();
// flp_Upload.SaveAs(Server.MapPath("~/Upload/" + flp_Upload.FileName));
// string FileUrl = Server.MapPath("~/Upload/" + flp_Upload.FileName);
// string filePath = FileUrl;
// attachment.FileName = Path.GetFileName(filePath);
// attachment.ContentStream = new MemoryStream(System.IO.File.ReadAllBytes(filePath));
// Attachment att = myItem.AttachmentFiles.Add(attachment);
//}
var onlineCredentials = new SharePointOnlineCredentials(login, securePassword);
clientContext.Credentials = onlineCredentials;
clientContext.ExecuteQuery();
//string FileUrls = Server.MapPath("~/Upload/" + flp_Upload.FileName);
//System.IO.File.Delete(FileUrls);
lbl_Msg.Text = "Request (ID# " + refno + ") Generated Successfully";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//Console.ReadLine();
}
public void sentdatatoSPLIst()
{
string Dates = "<b>From:</b> " + Convert.ToDateTime(txt_From.Text).ToString("dd/MM/yyyy") + " <b>To:</b> " + Convert.ToDateTime(txt_To.Text).ToString("dd/MM/yyyy") + "";
string letterrequestStatus = "No";
if (chk_Request.Checked == true)
{
letterrequestStatus = "Yes";
}
else
{
letterrequestStatus = "No";
}
String requestedletters = "";
string k = "";
for (int i = 0; i < chk_Courses.Items.Count; i++)
{
if (chk_Courses.Items[i].Selected)
{
k = k + "<b>Course Code:</b> " + chk_Courses.Items[i].Text + " <b>Instructor:</b> " + chk_Courses.Items[i].Value + "<br/>";
}
}
requestedletters = k;
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string languageoption = "";
if (Session["LanguageOption"].ToString() == "True")
{
languageoption = "<b>Language:</b> " + ddlLanguage.SelectedItem.Text + "";
}
string login = "******"; //give your username here
string password = "******"; //give your password
var securePassword = new SecureString();
foreach (char c in password)
{
securePassword.AppendChar(c);
}
string siteUrl = "https://ectacae.sharepoint.com/sites/ECTPortal/eservices/studentservices";
ClientContext clientContext = new ClientContext(siteUrl);
Microsoft.SharePoint.Client.List myList = clientContext.Web.Lists.GetByTitle("Students_Requests");
ListItemCreationInformation itemInfo = new ListItemCreationInformation();
Microsoft.SharePoint.Client.ListItem myItem = myList.AddItem(itemInfo);
string refno = Create16DigitString();
myItem["Title"] = refno;
//myItem["RequestID"] = refno;
myItem["Year"] = iYear;
myItem["Semester"] = iSem;
myItem["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )<br/><b>Major:</b> " + lbl_CurrentMajor.Text + "<br/><b>Excuse Dates:</b> " + Dates + "<br/><b>Re-examination letter requested:</b> " + letterrequestStatus + "<br/><b>Requested Letters:</b><br/>" + requestedletters + "<br/>" + languageoption + "<br/>";
myItem["RequestNote"] = txt_Remarks.Text.Trim();
myItem["ServiceID"] = lbl_ServiceID.Text;
myItem["Fees"] = hdf_Price.Value;
myItem["Requester"] = clientContext.Web.EnsureUser(hdf_StudentEmail.Value);
//myItem["Requester"] = clientContext.Web.EnsureUser("*****@*****.**");
myItem["StudentID"] = lbl_StudentID.Text;
myItem["StudentName"] = lbl_StudentName.Text;
myItem["Contact"] = lbl_StudentContact.Text;
myItem["Finance"] = clientContext.Web.EnsureUser(Session["FinanceEmail"].ToString());
myItem["FinanceAction"] = "Initiate";
myItem["FinanceNote"] = "";
myItem["Host"] = clientContext.Web.EnsureUser(Session["HostEmail"].ToString());//Session["HostEmail"].ToString();
myItem["HostAction"] = "Initiate";
myItem["HostNote"] = "";
//myItem["Provider"] = "";
myItem["ProviderAction"] = "Initiate";
myItem["ProviderNote"] = "";
myItem["Status"] = "Finance Approval Needed";
//myItem["Modified"] = DateTime.Now;
//myItem["Created"] = DateTime.Now;
//myItem["Created By"] = hdf_StudentEmail.Value;
//myItem["Modified By"] = hdf_StudentEmail.Value;
try
{
myItem.Update();
if (flp_Upload.HasFile)
{
var attachment = new AttachmentCreationInformation();
flp_Upload.SaveAs(Server.MapPath("~/Upload/" + flp_Upload.FileName));
string FileUrl = Server.MapPath("~/Upload/" + flp_Upload.FileName);
string filePath = FileUrl;
attachment.FileName = Path.GetFileName(filePath);
attachment.ContentStream = new MemoryStream(System.IO.File.ReadAllBytes(filePath));
Attachment att = myItem.AttachmentFiles.Add(attachment);
}
var onlineCredentials = new SharePointOnlineCredentials(login, securePassword);
clientContext.Credentials = onlineCredentials;
clientContext.ExecuteQuery();
if (flp_Upload.HasFile)
{
string FileUrls = Server.MapPath("~/Upload/" + flp_Upload.FileName);
System.IO.File.Delete(FileUrls);
}
lbl_Msg.Text = "Request (ID# " + refno + ") Generated Successfully";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//Console.ReadLine();
}
protected void lnk_Generate_Click(object sender, EventArgs e)
{
string header = "<table style='width: 100 %; border: 1px solid #000' align='center' id='tblContacts'><tbody><tr><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Has an Exam in<br>(لديه لديها امتحان في مادة)</b></td><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Course Code<br>(رمز المادة)</b></td><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Instructor’s Name<br>(اســم مدرس المادة)</b></td><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Exam Day<br>(يوم الامتحان)</b></td><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Exam Date <br>(الموافق لتاريخ)</b></td><td align='center' style='background-color: #f2f2f2; color: #000;'><b>Time of Exam <br>(الساعة)</b></td></tr>";
string request = "";
string footer = "</tbody></table>";
foreach (RepeaterItem item in RepterDetails.Items)
{
if (((CheckBox)item.FindControl("chk")).Checked)
{
//Do something
var lbl_exam = (Label)item.FindControl("lbl_exam") as Label;
var lbl_code = (Label)item.FindControl("lbl_code") as Label;
var lbl_instructor = (Label)item.FindControl("lbl_instructor") as Label;
var txt_Date = (TextBox)item.FindControl("txt_Date") as TextBox;
string day = Convert.ToDateTime(txt_Date.Text).ToString("dddd");
var txt_Time = (TextBox)item.FindControl("txt_Time") as TextBox;
request = request + "<tr><td align='center'> " + lbl_exam.Text + "</td><td align='center'> " + lbl_code.Text + "</td><td align='center'> " + lbl_instructor.Text + "</td><td align='center'> " + day + "</td><td align='center'> " + txt_Date.Text + "</td><td align='center'> " + txt_Time.Text + "</td></tr>";
}
}
string htmltext = header + request + footer;
//if (drp_Course.SelectedItem.Value != "---Select a Course---")
//{
//sentdatatoSPLIst();
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
string refno = Create16DigitString();
//string day = Convert.ToDateTime(txt_ExamDate.Text).ToString("dddd");
string sACC = "0200000";
if (Session["CurrentCampus"].ToString() == "Males")
{
sACC = "0100000";
}
else
{
sACC = "0200000";
}
string languageoption = "";
if (Session["LanguageOption"].ToString() == "True")
{
languageoption = "<b>Language:</b> " + ddlLanguage.SelectedItem.Text + "";
}
// Create a DataTable
DataTable dtSPList = new DataTable();
dtSPList.Clear();
dtSPList.Columns.Add("Title");
dtSPList.Columns.Add("Year");
dtSPList.Columns.Add("Semester");
dtSPList.Columns.Add("Request");
dtSPList.Columns.Add("RequestNote");
dtSPList.Columns.Add("ServiceID");
dtSPList.Columns.Add("Fees");
dtSPList.Columns.Add("Requester");
dtSPList.Columns.Add("StudentID");
dtSPList.Columns.Add("StudentName");
dtSPList.Columns.Add("Contact");
dtSPList.Columns.Add("Finance");
dtSPList.Columns.Add("FinanceAction");
dtSPList.Columns.Add("FinanceNote");
dtSPList.Columns.Add("Host");
dtSPList.Columns.Add("HostAction");
dtSPList.Columns.Add("HostNote");
dtSPList.Columns.Add("ProviderAction");
dtSPList.Columns.Add("ProviderNote");
dtSPList.Columns.Add("Status");
// Add items using Add method
DataRow dr = dtSPList.NewRow();
dr["Title"] = refno;
dr["Year"] = iYear;
dr["Semester"] = iSem;
dr["Request"] = "<b>Service ID:</b> " + lbl_ServiceID.Text + "<br/> <b>Service Name:</b> " + lbl_ServiceNameEn.Text + " (" + lbl_ServiceNameAr.Text + " )<br/>" + languageoption + "<br/><b><u>Service Request:</u></b><br/><br/>" + htmltext + "";
dr["RequestNote"] = txt_Remarks.Text.Trim();
dr["ServiceID"] = lbl_ServiceID.Text;
dr["Fees"] = hdf_Price.Value;
//dr["Requester"] = "*****@*****.**";
dr["Requester"] = hdf_StudentEmail.Value;
dr["StudentID"] = lbl_StudentID.Text;
dr["StudentName"] = lbl_StudentName.Text;
dr["Contact"] = lbl_StudentContact.Text;
//dr["Finance"] = "*****@*****.**";
dr["Finance"] = Session["FinanceEmail"].ToString();
dr["FinanceAction"] = "Initiate";
dr["FinanceNote"] = "";
//dr["Host"] = "*****@*****.**";
dr["Host"] = Session["HostEmail"].ToString();
dr["HostAction"] = "Initiate";
dr["HostNote"] = "";
dr["ProviderAction"] = "Initiate";
dr["ProviderNote"] = "";
dr["Status"] = "Finance Approval Needed";
dtSPList.Rows.Add(dr);
//sentdatatoSPLIst();
Session["CurrentService"] = "Student Services: " + lbl_ServiceID.Text + "";
Session["CurrentServiceName"] = lbl_ServiceNameEn.Text;
Session["CurrentServiceAmount"] = string.Format("{0:f}", hdf_Price.Value);
Session["CurrentdtSPList"] = dtSPList;
Session["CurrentAccount"] = sACC;
Session["cancelpage"] = "ECT_SAR_SREG_FRM_011.aspx?ServiceID=" + lbl_ServiceID.Text + "";
Response.Redirect("Student_Services_HostedPayment.aspx");
//}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//Security
if (Session["CurrentRole"] != null)
{
CurrentRole = (int)Session["CurrentRole"];
}
else
{
//showErr("Session is expired, Login again...");
ClearSession();
Session["cpage"] = "Balance.aspx";
Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
if (LibraryMOD.isRoleAuthorized(InitializeModule.enumPrivilegeObjects.ECT_Payment,
InitializeModule.enumPrivilege.ShowBrowse, CurrentRole) != true)
{
//showmsg("Sorry, You don't have the permission to view this page...");
//runScr("hidesidebar();");
showErr("Sorry, You don't have the permission to view this page...");
}
CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
sSID = Session["CurrentStudent"].ToString();
sName = Session["CurrentStudentName"].ToString();
getStdAcc();
Session["CurrentAccount"] = sACC;
decimal dAmount = 0;
if (Request.QueryString["amt"] != null && Request.QueryString["amt"] != "")
{
dAmount = Convert.ToDecimal(Request.QueryString["amt"]);
}
else
{
dAmount = LibraryMOD.GetStudentBalanceBTS(sSID, CurrentCampus);
}
int iCurrentTerm = LibraryMOD.GetCurrentTerm();
if (isHidden(sSID, iCurrentTerm))
{
lblOBalanceVATBTS.Text = "-----";
}
else
{
lblOBalanceVATBTS.Text = string.Format("{0:f}", dAmount);
}
if (dAmount < 0)
{
dAmount = 1;
}
txtPayment.Text = string.Format("{0:f}", dAmount);
if (Session["PmtOrder"] != null)
{
cancelonlinepayment(Session["PmtOrder"].ToString());
}
}
//switch(CurrentCampus)
//{
// case InitializeModule.EnumCampus.Females:
// mtvBalance.ActiveViewIndex = 0;
// break;
// case InitializeModule.EnumCampus.Males:
// mtvBalance.ActiveViewIndex = 1;
// break;
//}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
//divMsg.InnerText = ex.Message;
}
}