protected void LoadData()
{
try
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBEAuditor.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]);
objBAuditor.BProcessedExamRequest(objBEAuditor);
if (objBEAuditor.DtResult.Rows.Count > 0)
{
// trGridPages.Visible = true;
Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
gvProcessedExamRequest.DataSource = objBEAuditor.DtResult;
//ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
//this.BindGrid("LOAD");
}
else
{
// trGridPages.Visible = false;
Session[BaseClass.EnumPageSessions.DATATABLE] = null;
//ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
gvProcessedExamRequest.DataSource = new string[] { };
//gvProcessedExamRequest.DataBind();
//this.SetDefaultPagingImages();
}
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void LoadData(int studentID)
{
try
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBEAuditor.IntStudentID = studentID;
objBEAuditor.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);
objBAuditor.BGetAuditorCourseDetails(objBEAuditor);
if (objBEAuditor.DtResult.Rows.Count > 0)
{
gvExamStatus.DataSource = objBEAuditor.DtResult;
}
else
{
gvExamStatus.DataSource = new object[] { };
}
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void LoadData()
{
try
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBAuditor.BSearchStudentDetails(objBEAuditor);
if (objBEAuditor.DtResult.Rows.Count > 0)
{
Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
//ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
//this.BindGrid("LOAD");
gvStudentLookUp.DataSource = objBEAuditor.DtResult;
}
else
{
Session[BaseClass.EnumPageSessions.DATATABLE] = objBEAuditor.DtResult;
//ViewState[BaseClass.EnumPageSessions.CurrentPage] = CurrentPage;
//this.BindGrid("LOAD");
gvStudentLookUp.DataSource = new object[] { };;
}
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void GetStudentDetails(int StudentID)
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
//objBEUser.IntStudentID = StudentID;
objBEAuditor.IntStudentID = StudentID;
objBAuditor.BGetStudentDetails(objBEAuditor);
if (objBEAuditor.DtResult != null)
{
if (objBEAuditor.DtResult.Rows.Count > 0)
{
lblstudentfirstname.Text = objBEAuditor.DtResult.Rows[0]["studentName"].ToString();
lblEmail.Text = objBEAuditor.DtResult.Rows[0]["EmailAddress"].ToString();
lblPhoneNumber.Text = objBEAuditor.DtResult.Rows[0]["PhoneNumber"].ToString();
lblTimeZone.Text = objBEAuditor.DtResult.Rows[0]["TimeZone"].ToString();
string imgpath = objBEAuditor.DtResult.Rows[0]["PhotoIdentity"].ToString();
//imgstudent.ImageUrl = "~/Student/Student_Identity/" + imgpath.Substring(3).ToString();
imgstudent.ImageUrl = new AppSecurity().ImageToBase64(imgpath.Substring(3).ToString());
lblSpecialNeeds.Text = objBEAuditor.DtResult.Rows[0]["SpecialNeeds"].ToString();
if (objBEAuditor.DtResult.Rows[0]["Comments"].ToString() != null && objBEAuditor.DtResult.Rows[0]["Comments"].ToString() != string.Empty)
{
lblComments.Text = objBEAuditor.DtResult.Rows[0]["Comments"].ToString();
}
else
{
lblComments.Text = "N/A";
}
}
}
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
objBAuditor.BDeleteAlertImage(objBEAuditor);
objBEAuditor = null;
objBAuditor = null;
trDeleteImage.Visible = false;
}
protected void GetAddedBydropdown()
{
try
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBAuditor.BGetAddedBy(objBEAuditor);
ddlAddedBy.DataSource = objBEAuditor.DsResult;
ddlAddedBy.DataValueField = "UserID";
ddlAddedBy.DataTextField = "Name";
ddlAddedBy.DataBind();
}
catch
{
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
string strTransID = string.Empty;
//foreach (GridViewRow row in gvAuditorInbox.Rows)
//{
// CheckBox chk = (CheckBox)row.Cells[0].FindControl("chkSelect");
// if (chk.Checked == true)
// {
// Label lbl = (Label)row.Cells[1].FindControl("lblExamID");
// strTransID = strTransID + lbl.Text.ToString() + "$";
// }
//}
foreach (GridDataItem item in gvAutoProctorInbox.Items)
{
CheckBox chk = (CheckBox)item.Cells[0].FindControl("chkSelect");
if (chk.Checked == true)
{
Label lbl = (Label)item.Cells[1].FindControl("lblExamID");
strTransID = strTransID + lbl.Text.ToString() + "$";
}
}
if (strTransID != string.Empty)
{
strTransID = strTransID.Substring(0, strTransID.Length - 1);
BEProctor objBEProctor = new BEProctor();
BProctor objBProctor = new BProctor();
objBEProctor.strTransID = strTransID;
objBEProctor.IntEmployeeID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);
objBProctor.BApproveAutoProcTransaction(objBEProctor);
objBEProctor = null;
objBEProctor = null;
//foreach (GridDataItem item in gvAuditorInbox.Items)
//{
// CheckBox chk = (CheckBox)item.Cells[0].FindControl("chkSelect");
// //EmailMsg obj;
// if (chk.Checked == true)
// {
//BEAuditor objBEAuditor1 = new BEAuditor();
BAuditor objBAuditor1 = new BAuditor();
BEProctor objBEProctor1 = new BEProctor();
BProctor objBProctor1 = new BProctor();
objBEProctor1.strTransID = strTransID;
objBProctor1.BGetAutoProctorProviderDetails(objBEProctor1);
if (objBEProctor1.DsResult.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < objBEProctor1.DsResult.Tables[0].Rows.Count; i++)
{
DataTable objDT = new DataTable();
objDT = objBEProctor1.DsResult.Tables[0];
objBEProctor1.IntUserID = Convert.ToInt32(objDT.Rows[i]["ExamProviderID"]);
objBEProctor1.IntProviderID = Convert.ToInt32(objDT.Rows[i]["UserID"]);
objBEProctor1.IntTransID = Convert.ToInt64(objDT.Rows[i]["TransID"]);
//BEMail objBEMail = new BEMail();
//BMail objBMail = new BMail();
//objBEMail.IntTransID = objBEProctor1.IntTransID;
//string FYI = "FYI";
//string mail = "Mail";
//if (mail == "Mail")
//{
// objBEMail.IntUserID = objBEAuditor1.IntUserID;
// objBEMail.StrTemplateName = BaseClass.EnumEmails.ExamApprovedbyAuditor.ToString();
// objBMail.BSendEmail(objBEMail);
//}
//if (FYI == "FYI")
//{
// BECommon objBECommon = new BECommon();
// BCommon objBCommon = new BCommon();
// objBECommon.IntTransID = objBEProctor1.IntTransID;
// objBCommon.BAuditorCheckEmailForApproval(objBECommon);
// if (objBECommon.IntstatusFlag == 1)
// {
// objBEMail.IntUserID = objBEProctor1.IntUserID;
// objBEMail.StrTemplateName = BaseClass.EnumEmails.ExamApprovedbyAuditorFYI.ToString();
// objBMail.BSendEmail(objBEMail);
// }
//}
}
// Label lbl = (Label)item.Cells[1].FindControl("lblExamID");
}
lblSuccess.Text = Resources.ResMessages.Audit_TransApprove;
// this.LoadData();
gvAutoProctorInbox.Rebind();
}
else
{
lblSuccess.Text = Resources.ResMessages.Audit_TransSelect;
}
}
protected void GetComments()
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
objBEAuditor.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]);
objBAuditor.BGetComments(objBEAuditor);
if (objBEAuditor.DsResult != null && objBEAuditor.DsResult.Tables[0].Rows.Count > 0)
{
ddlFlags.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTypeID"].ToString();
txtComments.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["Comments"].ToString();
//if (objBEAuditor.DsResult.Tables[0].Rows[0]["Type"].ToString() != "0")
//{
// txtComments.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["Comments"].ToString();
// DivTextBox.Visible = true;
//}
//else
// DivTextBox.Visible = false;
if (objBEAuditor.DsResult.Tables[1] != null)
{
ddlAlerts.DataSource = objBEAuditor.DsResult.Tables[1];
ddlAlerts.DataValueField = "AlertID";
ddlAlerts.DataTextField = "AlertText";
ddlAlerts.DataBind();
}
ddlAlerts.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["AlertID"].ToString();
if (ddlAlerts.SelectedItem.Text.ToString().ToUpper() == "OTHER")
{
RequiredFieldValidator11.Enabled = true;
RequiredFieldValidator11.ValidationGroup = "Edit";
}
else
{
RequiredFieldValidator11.Enabled = false;
RequiredFieldValidator11.ValidationGroup = string.Empty;
}
txtAddedOn.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["AddedOn"].ToString();
ddlAddedBy.SelectedValue = objBEAuditor.DsResult.Tables[0].Rows[0]["CommenterID"].ToString();
string CommentTime = string.Empty;
CommentTime = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTime"].ToString();
if (CommentTime != null && CommentTime != string.Empty)
{
char[] separator = { ':' };
//string[] time=new string[3];
string[] time = CommentTime.Split(separator);
ddlHours.SelectedValue = time[0];
ddlMinutes.SelectedValue = time[1];
ddlsec.SelectedValue = time[2];
}
//txtincidenttimestamp.Text = objBEAuditor.DsResult.Tables[0].Rows[0]["CommentTime"].ToString();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (ddlAlerts.SelectedItem.Text.ToString().ToUpper() == "OTHER" && txtComments.Text == string.Empty)
{
RequiredFieldValidator11.Enabled = true;
RequiredFieldValidator11.ValidationGroup = "Edit";
}
else
{
BEAuditor objBEAuditor = new BEAuditor();
BAuditor objBAuditor = new BAuditor();
objBEAuditor.IntCommentID = Convert.ToInt32(Request.QueryString["CommentID"].ToString());
objBEAuditor.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]);
objBEAuditor.IntAletID = Convert.ToInt32(ddlAlerts.SelectedValue.ToString());
//if (DivTextBox.Visible)
//{
objBEAuditor.StrComments = txtComments.Text;
objBEAuditor.IntstatusFlag = 1;
//}
//else
//{
// objBEAuditor.StrComments = ddlAlerts.SelectedValue.ToString();
// objBEAuditor.IntstatusFlag = 0;
//}
//objBEAuditor.TimeStamp = txtincidenttimestamp.Text;
string TimeChoosed = string.Empty;
if (ddlHours.SelectedIndex != 0 && ddlHours.SelectedIndex != 1)
{
TimeChoosed = ddlHours.SelectedValue.ToString();
if (ddlMinutes.SelectedIndex != 0)
{
TimeChoosed = TimeChoosed + ":" + ddlMinutes.SelectedValue.ToString();
}
else
{
TimeChoosed = TimeChoosed + ":00";
}
if (ddlsec.SelectedIndex != 0)
{
TimeChoosed = TimeChoosed + ":" + ddlsec.SelectedValue.ToString();
}
else
{
TimeChoosed = TimeChoosed + ":00";
}
}
else if (ddlMinutes.SelectedIndex != 0 && ddlMinutes.SelectedIndex != 1)
{
TimeChoosed = "00:" + ddlMinutes.SelectedValue.ToString();
if (ddlsec.SelectedIndex != 0)
{
TimeChoosed = TimeChoosed + ":" + ddlsec.SelectedValue.ToString();
}
else
{
TimeChoosed = TimeChoosed + ":00";
}
}
else if (ddlsec.SelectedIndex != 0 && ddlsec.SelectedIndex != 1)
{
TimeChoosed = "00:00:" + ddlsec.SelectedValue.ToString();
}
else
{
TimeChoosed = string.Empty;
}
objBEAuditor.TimeStamp = TimeChoosed;
objBEAuditor.IntFlag = Convert.ToInt32(ddlFlags.SelectedValue);
objBEAuditor.strAddedBy = ddlAddedBy.SelectedValue.ToString();
objBEAuditor.strAddedOn = Convert.ToDateTime(txtAddedOn.Text);
objBAuditor.BUpdateComments(objBEAuditor);
trMessage.Visible = true;
if (objBEAuditor.IntResult == 1)
{
lblInfo.Text = Resources.ResMessages.Auditor_Edit_Success_CommentsUpdated;
lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success);
ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success;
tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success);
//if (DivTextBox.Visible)
//{
lblComments.Text = txtComments.Text;
//DivTextBox_View.Visible = true;
//DivDropdown_View.Visible = false;
//}
//else
//{
lblDescription.Text = ddlAlerts.SelectedItem.Text.ToString();
// DivTextBox_View.Visible = false;
// DivDropdown_View.Visible = true;
//}
lblIncidentTimeStamp.Text = TimeChoosed;
lblAddedBy.Text = ddlAddedBy.SelectedItem.Text.ToString();
lblAddedOn.Text = txtAddedOn.Text;
lblflag.Text = ddlFlags.SelectedItem.Text.ToString();
trCommentsEdit.Visible = false;
trCommentsView.Visible = true;
}
else
{
lblInfo.Text = Resources.ResMessages.Auditor_EditComments_Error_Comments;
lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error);
ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error;
tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error);
}
}
}
catch (Exception Ex)
{
ErrorHandlers.ErrorLog.WriteError(Ex);
}
}