public int DeleteCourseLeader(InitializeModule.EnumCampus Campus, string AcademicYear, string SemesterID, string CourseID)
{
int iEffected = 0;
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
try
{
string sSQL = GetDeleteCommand();
//sSQL += sCondition;
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Cmd.Parameters.Add(new SqlParameter("@AcademicYear", AcademicYear));
Cmd.Parameters.Add(new SqlParameter("@SemesterID", SemesterID));
Cmd.Parameters.Add(new SqlParameter("@CourseID", CourseID));
Conn.Open();
iEffected = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
public List <string> GetElective(string sCollege, string sDegree, string sMajor, int iOrder, InitializeModule.EnumCampus Campus)
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
SqlCommand Cmd;
SqlDataReader Rd;
List <string> Result = new List <string>();
try
{
string sElectSQL = "SELECT sEelecive FROM dbo.Reg_Specialization_Elective AS E";
sElectSQL += " WHERE sMajor ='" + sMajor + "' AND sDegree='" + sDegree + "' AND sCollege ='" + sCollege + "' AND intOrder =" + iOrder;
Cmd = new SqlCommand(sElectSQL, Conn);
Rd = Cmd.ExecuteReader();
while (Rd.Read())
{
Result.Add(Rd["sEelecive"].ToString());
}
Rd.Close();
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(Result);
}
public void bindnewsfeed()
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection sc = new SqlConnection(myConnection_String.Conn_string);
SqlCommand cmd = new SqlCommand("select TOP (5) * from ECT_SIS_News_Feed where isActive=1 order by dDate desc", sc);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
RepeaterNews.DataSource = dt;
RepeaterNews.DataBind();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine("{0} Exception caught.", ex);
}
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();
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();
}
}
}
public void getcourses(int term)
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(term, 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)
{
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---"));
}
}
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(Convert.ToInt32(drp_Semester.SelectedItem.Value), 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();
}
}
else
{
lbl_CourseCode.Text = "";
lbl_Instructor.Text = "";
}
}
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---"));
}
}
private int isPwdChanged(string sSID, string sPWD, InitializeModule.EnumCampus Campus)
{
int iEffected = 0;
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
try
{
string sSQL = "UPDATE Cmn_User SET Password = '******' WHERE UserName='******'";
SqlCommand cmd = new SqlCommand(sSQL, Conn);
iEffected += cmd.ExecuteNonQuery();
Conn.Close();
myConnection_String = new Connection_StringCLS(Campus);
Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
sSQL = "UPDATE Reg_Student_Accounts SET strOnlinePWD = '" + sPWD + "' WHERE lngStudentNumber='" + sSID + "'";
cmd = new SqlCommand(sSQL, Conn);
iEffected += cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
showmsg(ex.Message);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
private static int UpdateMoodleUserNo(int iUserNo, int iMoodleUserNo)
{
int iUpdated = 0;
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection conn = new SqlConnection(myConnection_String.Conn_string);
conn.Open();
try
{
string sSQL = "";
sSQL = "UPDATE Cmn_User";
sSQL += " SET MoodleUserNo =" + iMoodleUserNo;
sSQL += " WHERE UserNo =" + iUserNo;
SqlCommand cmd = new SqlCommand(sSQL, conn);
iUpdated = cmd.ExecuteNonQuery();
return(iUpdated);
}
catch (Exception ex)
{
return(iUpdated);
}
finally
{
conn.Close();
conn.Dispose();
}
}
public void insert_online_payment(string sOrder, string sACC, string sSID, string sService, string amount)
{
CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
Connection_StringCLS connstr = new Connection_StringCLS(CurrentCampus);
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("INSERT INTO [ECTData].[dbo].[Acc_Payment_Order] values (@sOrder,@sACC,@sSID,@sService,@dDate,@isCaptured,@dCaptured,@sVoucherNo,@isCanceled,@cAmount,@cVAT,@tOrder)", sc);
cmd.Parameters.AddWithValue("@sOrder", sOrder);
cmd.Parameters.AddWithValue("@sACC", sACC);
cmd.Parameters.AddWithValue("@sSID", sSID);
cmd.Parameters.AddWithValue("@sService", sService);
cmd.Parameters.AddWithValue("@dDate", DateTime.Now);
cmd.Parameters.AddWithValue("@isCaptured", false);
cmd.Parameters.AddWithValue("@dCaptured", DBNull.Value);
cmd.Parameters.AddWithValue("@sVoucherNo", DBNull.Value);
cmd.Parameters.AddWithValue("@isCanceled", false);
cmd.Parameters.AddWithValue("@cAmount", amount);
cmd.Parameters.AddWithValue("@cVAT", 0);
cmd.Parameters.AddWithValue("@tOrder", DBNull.Value);
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
public List <CourseLeader> GetList(InitializeModule.EnumCampus Campus, string sCondition, bool isDeafaultIncluded)
{
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
string sSQL = GetListSQL(sCondition);
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Conn.Open();
SqlDataReader reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <CourseLeader> results = new List <CourseLeader>();
try
{
//Default Value
CourseLeader myCourseLeader = new CourseLeader();
if (isDeafaultIncluded)
{
//Change the code here
myCourseLeader.AcademicYear = -1;
myCourseLeader.SemesterID = -1;
myCourseLeader.CourseID = "Select Course";
results.Add(myCourseLeader);
}
while (reader.Read())
{
myCourseLeader = new CourseLeader();
if (reader[LibraryMOD.GetFieldName(AcademicYearFN)].Equals(DBNull.Value))
{
myCourseLeader.AcademicYear = 0;
}
else
{
myCourseLeader.AcademicYear = int.Parse(reader[LibraryMOD.GetFieldName(AcademicYearFN)].ToString());
}
if (reader[LibraryMOD.GetFieldName(SemesterIDFN)].Equals(DBNull.Value))
{
myCourseLeader.SemesterID = 0;
}
else
{
myCourseLeader.SemesterID = int.Parse(reader[LibraryMOD.GetFieldName(SemesterIDFN)].ToString());
}
myCourseLeader.CourseID = reader[LibraryMOD.GetFieldName(CourseIDFN)].ToString();
results.Add(myCourseLeader);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
reader.Close();
reader.Dispose();
Conn.Close();
Conn.Dispose();
}
return(results);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["CurrentRole"] != null)
{
CurrentRole = (int)Session["CurrentRole"];
iRegYear = (int)Session["RegYear"];
iRegSem = (int)Session["RegSemester"];
}
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 (Session["CurrentStudent"] != null)
{
sNo = Session["CurrentStudent"].ToString();
sName = Session["CurrentStudentName"].ToString();
if (!IsPostBack)
{
getservicedetails();
getdetails();
if (Session["PmtOrder"] != null)
{
cancelonlinepayment(Session["PmtOrder"].ToString());
}
}
}
}
catch (Exception exp)
{
Console.WriteLine("{0} Exception caught.", exp);
}
finally
{
}
}
public void updateonlinepayment(string sOrder, string sVoucherNo)
{
CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
Connection_StringCLS connstr = new Connection_StringCLS(CurrentCampus);
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("update [ECTData].[dbo].[Acc_Payment_Order] set sVoucherNo=@sVoucherNo,tOrder=@tOrder where sOrder=@sOrder", sc);
//cmd.Parameters.AddWithValue("@isCaptured", true);
//cmd.Parameters.AddWithValue("@dCaptured", DateTime.Now);
cmd.Parameters.AddWithValue("@sVoucherNo", sVoucherNo);
//cmd.Parameters.AddWithValue("@isCanceled", false);
cmd.Parameters.AddWithValue("@sOrder", sOrder);
cmd.Parameters.AddWithValue("@tOrder", DBNull.Value);
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
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 int DeletePrivilegeObjects(InitializeModule.EnumCampus Campus, int ObjectID)
{
int iEffected = 0;
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
try
{
string sSQL = GetDeleteCommand();
//sSQL += sCondition;
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Cmd.Parameters.Add(new SqlParameter("@ObjectID", ObjectID));
Conn.Open();
iEffected = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
public int GetNewOrder(int iLevel, int iSystem)
{
int iOrder = 1;
SqlConnection Conn = new SqlConnection();
try
{
InitializeModule.EnumCampus iCampus = InitializeModule.EnumCampus.ECTNew;
//iCampus = InitializeModule.EnumCampus.ECTNew;
Connection_StringCLS sConn = new Connection_StringCLS(iCampus);
string sSQL = "SELECT Max(ShowOrder) FROM Cmn_PrivilegeObjects";
sSQL += " Where SystemID=" + iSystem + " And iLevel=" + iLevel;
Conn.ConnectionString = sConn.Conn_string.ToString();
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Conn.Open();
iOrder += (int)Cmd.ExecuteScalar();
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
//Conn.Close();
}
return(iOrder);
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["ECTDataNew"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from ECT_SIS_News_Feed where isActive='0'", sc);
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("{0} Exception caught.", ex);
}
finally
{
sc.Close();
}
}
public void bindcount()
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["ECTDataNew"].ConnectionString);
SqlCommand cmd = new SqlCommand("select count(iSerial) as Total from ECT_SIS_News_Feed; select count(iSerial) as Active from ECT_SIS_News_Feed where isActive='1'; select count(iSerial) as Inactive from ECT_SIS_News_Feed where isActive='0'", sc);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(ds);
sc.Close();
lbl_total.Text = ds.Tables[0].Rows[0]["Total"].ToString();
lbl_Active.Text = ds.Tables[1].Rows[0]["Active"].ToString();
lbl_Inactive.Text = ds.Tables[2].Rows[0]["Inactive"].ToString();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine("{0} Exception caught.", ex);
}
finally
{
sc.Close();
}
}
private int add_log(string sUser, string sPCName, string sNtUser, int iUserID, string sURL)
{
int iAdded = 0;
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection conn = new SqlConnection(myConnection_String.Conn_string);
conn.Open();
try
{
string sSQL = "";
sSQL = "INSERT INTO ECT_User_Log (sUser,dTime,sPCName,sNtUser,iUserID,sURL) VALUES ('" + sUser + "',GETDATE(),'" + sPCName + "','" + sNtUser + "'," + iUserID + ",'" + sURL + "')";
SqlCommand cmd = new SqlCommand(sSQL, conn);
iAdded = cmd.ExecuteNonQuery();
return(iAdded);
}
catch (Exception ex)
{
return(iAdded);
}
finally
{
conn.Close();
conn.Dispose();
}
}
public void bindtotal()
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["ECTDataNew"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from ECT_SIS_News_Feed", sc);
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("{0} Exception caught.", ex);
}
finally
{
sc.Close();
}
}
public static bool SetOpportunity(string sSID)
{
bool isSet = false;
//U cannot use var from out of the scope. (Campus)
InitializeModule.EnumCampus campus = InitializeModule.EnumCampus.Males;
if (sSID.Contains("AF") || sSID.Contains("ESF"))
{
campus = InitializeModule.EnumCampus.Females;
}
Connection_StringCLS myConnection_String = new Connection_StringCLS(campus);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
try
{
string sSQL = "UPDATE Reg_Applications SET isOpportunitySet=1";
sSQL += " WHERE (lngStudentNumber = '" + sSID + "')";
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
isSet = (Cmd.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
//divMsg.InnerText = ex.Message;
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(isSet);
}
public void cancelonlinepayment(string sOrder)
{
//CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("update [ECTData].[dbo].[Acc_Payment_Order] set isCanceled=@isCanceled where sOrder=@sOrder", sc);
cmd.Parameters.AddWithValue("@isCanceled", true);
cmd.Parameters.AddWithValue("@sOrder", sOrder);
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
Session["PmtOrder"] = null;
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
public int GetFreeElectiveCoursesCount(string sNo, InitializeModule.EnumCampus Campus)
{
string sSQL = "";
int iResult = 0;
try
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
sSQL = GetFreeElectiveSQL(sNo);
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
SqlDataReader Rd = Cmd.ExecuteReader();
while (Rd.Read())
{
iResult += 1;
}
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
}
return(iResult);
}
public string GetFreeElectiveCourses(string sNo, InitializeModule.EnumCampus Campus)
{
string sSQL = "";
string sResult = "";
try
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
sSQL = GetFreeElectiveSQL(sNo);
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
SqlDataReader Rd = Cmd.ExecuteReader();
while (Rd.Read())
{
sResult += Rd["strCourse"].ToString() + " , ";
}
sResult = sResult.Substring(0, sResult.Length - 3);
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
}
return(sResult);
}
public void insert_online_payment(string sOrder, string sACC, string sSID, string sService, string amount)
{
double dGrossAmount = Convert.ToDouble(amount);
double dPmtAmount = Math.Round((dGrossAmount / 1.05), 2);
double dVAT = Math.Round((dGrossAmount - dPmtAmount), 2);
DataTable CurrentdtSPList = Session["CurrentdtSPList"] as DataTable;
CurrentCampus = (InitializeModule.EnumCampus)Session["CurrentCampus"];
Connection_StringCLS connstr = new Connection_StringCLS(CurrentCampus);
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("INSERT INTO [ECTData].[dbo].[Acc_Payment_Order] values (@sOrder,@sACC,@sSID,@sService,@dDate,@isCaptured,@dCaptured,@sVoucherNo,@isCanceled,@cAmount,@cVAT,@tOrder)", sc);
cmd.Parameters.AddWithValue("@sOrder", sOrder);
cmd.Parameters.AddWithValue("@sACC", sACC);
cmd.Parameters.AddWithValue("@sSID", sSID);
cmd.Parameters.AddWithValue("@sService", sService);
cmd.Parameters.AddWithValue("@dDate", DateTime.Now);
cmd.Parameters.AddWithValue("@isCaptured", false);
cmd.Parameters.AddWithValue("@dCaptured", DBNull.Value);
cmd.Parameters.AddWithValue("@sVoucherNo", DBNull.Value);
cmd.Parameters.AddWithValue("@isCanceled", false);
cmd.Parameters.AddWithValue("@cAmount", dPmtAmount);
cmd.Parameters.AddWithValue("@cVAT", dVAT);
if (CurrentdtSPList.Rows.Count > 0)
{
//Convert Datatable to XML String to DB Save
System.IO.StringWriter writer = new System.IO.StringWriter();
CurrentdtSPList.TableName = "CurrentdtSPList";
CurrentdtSPList.WriteXml(writer, XmlWriteMode.WriteSchema, true);
cmd.Parameters.AddWithValue("@tOrder", writer.ToString());
//StringReader theReader = new StringReader(writer.ToString());
//DataSet theDataSet = new DataSet();
//theDataSet.ReadXml(theReader);
}
else
{
cmd.Parameters.AddWithValue("@tOrder", DBNull.Value);
}
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
public List <Privilege> GetObjectPrivileges(string sCondition)
{
InitializeModule.EnumCampus iCampus = InitializeModule.EnumCampus.ECTNew;
//iCampus = InitializeModule.EnumCampus.ECTNew;
Connection_StringCLS sConn = new Connection_StringCLS(iCampus);
//, OP.ObjectID
string sSQL = "SELECT P.PrivilegeID, P.PriviligeNameEn, P.DefaultEffect";
sSQL += " FROM dbo.Cmn_Privilege AS P INNER JOIN dbo.Cmn_Permissions AS OP ON P.PrivilegeID = OP.PrivilegeID";
sSQL += sCondition;
sSQL = sSQL + " Order By P.PrivilegeID";
SqlConnection Conn = new SqlConnection(sConn.Conn_string.ToString());
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Conn.Open();
SqlDataReader Rd = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <Privilege> results = new List <Privilege>();
//int i = 0;
try
{
while (Rd.Read())
{
Privilege MyPrivilege = new Privilege();
MyPrivilege.PrivilegeID = int.Parse(Rd["PrivilegeID"].ToString());
MyPrivilege.PriviligeNameEn = Rd["PriviligeNameEn"].ToString();
MyPrivilege.DefaultEffect = int.Parse(Rd["DefaultEffect"].ToString());
//MyPrivilege.isDataChanged = false;
//MyPrivilege.iDataStatus = 1;//Old 2:New Recored
results.Add(MyPrivilege);
//i += 1;
}
}
catch (Exception ex)
{
}
finally
{
//'Response.Write(ex.Message)
Rd.Close();
Rd.Dispose();
Conn.Close();
Conn.Dispose();
}
//myStatus.Clear()
return(results);
}
protected void btn_Create_Click(object sender, EventArgs e)
{
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["ECTDataNew"].ConnectionString);
SqlCommand cmd = new SqlCommand("update ECT_SIS_News_Feed set sHeader=@sHeader,sDetail=@sDetail,dDate=@dDate,sLink=@sLink,sAttachment=@sAttachment,isActive=@isActive,sUser=@sUser,dCreated=@dCreated where iSerial=@iSerial", sc);
cmd.Parameters.AddWithValue("@sHeader", txt_Header.Text.Trim());
cmd.Parameters.AddWithValue("@sDetail", txt_Detail.Text.Trim());
DateTime date = DateTime.ParseExact(txt_Date.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
cmd.Parameters.AddWithValue("@dDate", date);
cmd.Parameters.AddWithValue("@sLink", txt_Link.Text.Trim());
string path = "";
if (flp_Upload.HasFile)
{
string extension = Path.GetExtension(flp_Upload.PostedFile.FileName);
string filename = Path.GetFileName(flp_Upload.PostedFile.FileName);
flp_Upload.SaveAs(Server.MapPath("~/NewsFeed/" + filename));
path = "NewsFeed/" + filename;
}
else
{
path = HyperLink1.NavigateUrl;
}
cmd.Parameters.AddWithValue("@sAttachment", path);
cmd.Parameters.AddWithValue("@isActive", drp_Status.SelectedItem.Value);
cmd.Parameters.AddWithValue("@sUser", sName);
cmd.Parameters.AddWithValue("@dCreated", DateTime.Now);
cmd.Parameters.AddWithValue("@iSerial", Request.QueryString["id"]);
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
//txt_Header.Text = "";
//txt_Detail.Text = "";
//txt_Link.Text = "";
//txt_Date.Text = "";
div_msg.Visible = true;
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine("{0} Exception caught.", ex);
}
finally
{
sc.Close();
}
}
private List <Book> getBooks()
{
List <Book> myBooks = new List <Book>();
Connection_StringCLS myConnection_String = new Connection_StringCLS(InitializeModule.EnumCampus.ECTNew);
SqlConnection conn = new SqlConnection(myConnection_String.Conn_string);
conn.Open();
try
{
string sSQL = "SELECT B.BookID, B.AccesstionNo, B.Title, B.Author, B.Publisher, B.Subject, B.Edition, B.PublishedYear, B.Campus AS Library, S.strBookStatusEn AS Status";
sSQL += " FROM Library_Search_Web AS B INNER JOIN LibBooksStatuses AS S ON B.BookStatusID = S.BookStatusID";
sSQL += " ORDER BY B.PublishedYear DESC, B.Title";
SqlCommand cmd = new SqlCommand(sSQL, conn);
SqlDataReader rd = cmd.ExecuteReader();
Book myBook = new Book();
while (rd.Read())
{
myBook = new Book();
myBook.BookID = rd["BookID"].ToString();
myBook.AccNo = rd["AccesstionNo"].ToString();
myBook.Title = rd["Title"].ToString();
myBook.Author = rd["Author"].ToString();
myBook.Publisher = rd["Publisher"].ToString();
myBook.Subject = rd["Subject"].ToString();
myBook.Edition = rd["Edition"].ToString();
myBook.Published = rd["PublishedYear"].ToString();
myBook.Library = rd["Library"].ToString();
myBook.Status = rd["Status"].ToString();
if (rd["Status"].ToString() == "Available")
{
myBook.iStatus = "1";
}
else
{
myBook.iStatus = "0";
}
myBooks.Add(myBook);
}
}
catch (Exception ex)
{
Console.WriteLine("{0} Exception caught.", ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}
return(myBooks);
}
public void getprofilepic()
{
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);
if (dtStudentProfile.Rows.Count > 0)
{
Session["ProfilePIc"] = dtStudentProfile.Rows[0]["strStudentPic"].ToString();
Session["sEmail"] = dtStudentProfile.Rows[0]["sECTemail"].ToString();
}
}
