public void DUpdateScreenshotDetails(BEProctor objBEProctor)
{
try
{
SqlParameter[] objSqlParam = new SqlParameter[10];
objSqlParam[0] = new SqlParameter("@V_OriginalProctorFileName", SqlDbType.VarChar, 200);
objSqlParam[0].Value = objBEProctor.strOriginalFileName;
objSqlParam[1] = new SqlParameter("@V_StoredProctorFileName", SqlDbType.VarChar, 200);
objSqlParam[1].Value = objBEProctor.strUploadPath;
objSqlParam[2] = new SqlParameter("@I_CheckCam", SqlDbType.Bit);
objSqlParam[2].Value = objBEProctor.boolcam;
objSqlParam[3] = new SqlParameter("@I_CheckAudio", SqlDbType.Bit);
objSqlParam[3].Value = objBEProctor.boolaudio;
objSqlParam[4] = new SqlParameter("@I_CheckDesktop", SqlDbType.Bit);
objSqlParam[4].Value = objBEProctor.booldesktop;
objSqlParam[5] = new SqlParameter("@I_CheckIDValid", SqlDbType.Bit);
objSqlParam[5].Value = objBEProctor.boolidvalid;
objSqlParam[6] = new SqlParameter("@I_OS", SqlDbType.VarChar, 50);
objSqlParam[6].Value = objBEProctor.strOs;
objSqlParam[7] = new SqlParameter("@I_Browser", SqlDbType.VarChar, 50);
objSqlParam[7].Value = objBEProctor.strBrowser;
objSqlParam[8] = new SqlParameter("@I_TransID", SqlDbType.BigInt);
objSqlParam[8].Value = objBEProctor.IntTransID;
objSqlParam[9] = new SqlParameter("@I_Comments", SqlDbType.VarChar);
objSqlParam[9].Value = objBEProctor.strProctorComments;
//SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_SaveIdentityValidation, objSqlParam);
objBEProctor.IntResult = SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_UpdateScreenshotDetails, objSqlParam);
}
catch (Exception Ex)
{
throw Ex;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
BEProctor objBEProctor = new BEProctor();
BProctor objBProctor = new BProctor();
objBEProctor.IntTransID = Convert.ToInt64(Request.QueryString["TransID"].ToString());
objBEProctor.ProctorID = Convert.ToInt16(ddlProctorName.SelectedValue);
objBProctor.BAddProctor(objBEProctor);
if (objBEProctor.IntResult == 1)
{
trMessage.Visible = true;
trAddProctor.Visible = false;
trViewProctor.Visible = true;
lblProctorName.Text = ddlProctorName.SelectedItem.Text.ToString();
lblInfo.Text = Resources.ResMessages.Proctor_AddProctor;
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);
}
else
{
trMessage.Visible = true;
lblInfo.Text = Resources.ResMessages.Proctor_Error_AddProctor;
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);
}
}
public void DGetWebExMeetingCredentials(BEProctor objBEProctor)
{
SqlParameter[] objSqlParam = new SqlParameter[10];
objSqlParam[0] = new SqlParameter("@UserID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntUserID;
objSqlParam[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 100);
objSqlParam[1].Direction = ParameterDirection.Output;
objSqlParam[2] = new SqlParameter("@Password", SqlDbType.VarChar, 100);
objSqlParam[2].Direction = ParameterDirection.Output;
objSqlParam[3] = new SqlParameter("@TransID", SqlDbType.BigInt);
objSqlParam[3].Value = objBEProctor.IntTransID;
objSqlParam[4] = new SqlParameter("@ExamSessionID", SqlDbType.VarChar, 100);
objSqlParam[4].Direction = ParameterDirection.Output;
objSqlParam[5] = new SqlParameter("@ExamToken", SqlDbType.VarChar, 100);
objSqlParam[5].Direction = ParameterDirection.Output;
objSqlParam[6] = new SqlParameter("@ExamDuration", SqlDbType.VarChar, 10);
objSqlParam[6].Direction = ParameterDirection.Output;
objSqlParam[7] = new SqlParameter("@ExamBufferTime", SqlDbType.Int);
objSqlParam[7].Direction = ParameterDirection.Output;
objSqlParam[8] = new SqlParameter("@StudentName", SqlDbType.VarChar, 100);
objSqlParam[8].Direction = ParameterDirection.Output;
objSqlParam[9] = new SqlParameter("@StudentEmailID", SqlDbType.VarChar, 100);
objSqlParam[9].Direction = ParameterDirection.Output;
SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "usp_Proctor_GetWebExMeetingCredentials", objSqlParam);
objBEProctor.strMeetingUserName = objSqlParam[1].Value.ToString();
objBEProctor.strMeetingPassword = objSqlParam[2].Value.ToString();
objBEProctor.strExamSessionID = objSqlParam[4].Value.ToString();
objBEProctor.strMeetingToken = objSqlParam[5].Value.ToString();
objBEProctor.strExamDuration = objSqlParam[6].Value.ToString();
objBEProctor.intExamBufferTime = Convert.ToInt32(objSqlParam[7].Value.ToString());
objBEProctor.strStudentName = objSqlParam[8].Value.ToString();
objBEProctor.StrEmailID = objSqlParam[9].Value.ToString();
}
public void DGetZoomCredentials(BEProctor objBEProctor)
{
SqlParameter[] sqlParameter = new SqlParameter[5];
SqlParameter _paramUserId = new SqlParameter("@UserID", SqlDbType.BigInt);
_paramUserId.Value = objBEProctor.IntUserID;
sqlParameter[0] = _paramUserId;
sqlParameter[1] = new SqlParameter("@TransID", SqlDbType.BigInt);
sqlParameter[1].Value = objBEProctor.IntTransID;
sqlParameter[2] = new SqlParameter("@MeetingUsername", SqlDbType.VarChar, 100);//added for passing the username for wfm dashboard on 8.8.2017
sqlParameter[2].Value = objBEProctor.Uname;
sqlParameter[3] = new SqlParameter("@StationId", SqlDbType.Int);//added for passing the username for wfm dashboard on 8.8.2017
sqlParameter[3].Value = objBEProctor.intID;
SqlParameter _zoomHostId = new SqlParameter("@ZoomHostId", SqlDbType.VarChar, 250);
_zoomHostId.Direction = ParameterDirection.Output;
sqlParameter[4] = _zoomHostId;
SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "usp_Proctor_GetZoomMeetingCredentials", sqlParameter);
objBEProctor.strZoomHostId = sqlParameter[4].Value.ToString();
}
public void DUpdateEnableNextButtonTime(BEProctor objBEProctor)
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@TransID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntTransID;
SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_Proctor_UpdateEnableNextButton", objSqlParam);
}
//BLOCKED DATES : START
public void DGetBlockedDates(BEProctor objBEProctor)
{
SqlParameter[] objSqlParam = new SqlParameter[5];
objSqlParam[0] = new SqlParameter("@UserID", SqlDbType.Int);
objSqlParam[0].Value = objBEProctor.IntUserID;
objBEProctor.DtResult = SQLHelper.ExecuteDataset(DConConfig.ConnectionString, CommandType.StoredProcedure, "USP_BlockSlots_GetSlots", objSqlParam).Tables[0];
}
public void DSetexamiFACETransactionStatus(BEProctor objBEProctor)
{
SqlParameter[] objSqlParam = new SqlParameter[3];
objSqlParam[0] = new SqlParameter("@TransID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntTransID;
SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, "usp_SetexamiFACEStatus", objSqlParam);
}
protected void SetFlags(string strType, int intValue)
{
BEProctor objBEProctor = new BEProctor();
BProctor objBProctor = new BProctor();
objBEProctor.IntTransID = Convert.ToInt64(AppSecurity.Decrypt(Request.QueryString["TransID"].ToString()));
objBEProctor.strStatus = strType;
objBEProctor.IntResult = intValue;
objBProctor.BSetTransactionFlags(objBEProctor);
}
protected void lnkFile_Click(object sender, EventArgs e)
{
BEProctor objBEProctor = new BEProctor();
BProctor objBProctor = new BProctor();
objBEProctor.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]);
objBEProctor.IntExamID1 = Convert.ToInt64(GetTransID());
objBProctor.BGetExamDetails(objBEProctor);
if (objBEProctor.DsResult.Tables[0].Rows.Count > 0)
{
if (objBEProctor.DsResult.Tables[0].Rows[0]["StoredFileName"] != null && objBEProctor.DsResult.Tables[0].Rows[0]["StoredFileName"].ToString() != "")
{
string UploadedFile = objBEProctor.DsResult.Tables[0].Rows[0]["StoredFileName"].ToString();
string MapPath = System.Web.HttpContext.Current.Server.MapPath("../Provider/Provider_Uploads");
string fullPath = MapPath + '\\' + UploadedFile;
FileInfo fi = new FileInfo(fullPath);
if (fi.Exists)
{
long sz = fi.Length;
Response.ClearContent();
Response.ContentType = MimeType(Path.GetExtension(fullPath));
Response.AddHeader("Content-Disposition", string.Format("attachment; filename = {0}", System.IO.Path.GetFileName(fullPath))); Response.AddHeader("Content-Length", sz.ToString("F0"));
Response.TransmitFile(fullPath);
Response.End();
}
else
{
//lblError.Visible = true;
//lblError.ForeColor = System.Drawing.Color.Red;
//lblError.Text = "File doesnot exist";
//ScriptManager.RegisterStartupScript(this, this.GetType(), "NotSaved", "alert('File doesnot exist');", true);
Page.ClientScript.RegisterStartupScript(GetType(), "MyScript", "alert('File doesnot exist');", true);
}
}
else
{
lnkProviderFile.Visible = false;
lblError.Visible = true;
lblError.Text = "N/A";
}
}
}
public void DresetExamSession(BEProctor objBEProctor)
{
SqlParameter[] objSqlParam = new SqlParameter[1];
objSqlParam[0] = new SqlParameter("@TransID", SqlDbType.BigInt);
objSqlParam[0].Value = objBEProctor.IntTransID;
SQLHelper.ExecuteNonQuery(DConConfig.ConnectionString, CommandType.StoredProcedure, StoredProcedures.USP_Proctor_ResetExamSession, objSqlParam);
}
public void BStudentIdentityVerification(BEProctor objBEProctor)
{
try
{
new DProctor().DStudentIdentityVerification(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BApproveAutoProcTransaction(BEProctor objBEProctor)
{
try
{
new DProctor().DApproveAutoProcTransaction(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetExamTime(BEProctor objBEProctor)
{
try
{
new DProctor().DGetExamTime(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetZoomCredentials(BEProctor objBEProctor)
{
try
{
(new DProctor()).DGetZoomCredentials(objBEProctor);
}
catch (Exception exception)
{
throw exception;
}
}
public void BDeleteBlockedDates(BEProctor objBEProctor)
{
try
{
new DProctor().DDeleteBlockedDates(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetAutoProctorInbox(BEProctor objBEProctor)
{
try
{
new DProctor().GetAutoProctorInbox(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BSetexamiFACEDownLoadStatus(BEProctor objBEProctor)
{
try
{
new DProctor().DSetexamiFACEDownLoadStatus(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetWebExMeetingCredentials(BEProctor objBEProctor)
{
try
{
new DProctor().DGetWebExMeetingCredentials(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BresetExamSession(BEProctor objBEProctor)
{
try
{
new DProctor().DresetExamSession(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetBrowserInfo(BEProctor objBEProctor)
{
try
{
new DProctor().DGetBrowserInfo(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
//BLOCKED DATES : END
public void BGetMeetingID(BEProctor objBEProctor)
{
try
{
new DProctor().DGetMeetingID(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetBlockedDatesForSelectedDate(BEProctor objBEProctor)
{
try
{
new DProctor().DGetBlockedDatesForSelectedDate(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
//public void BGetFlagStatusNext(BEProctor objBEProctor)
//{
// try
// {
// objBEProctor.strStatus = "NEXT";
// new DProctor().DGetFlagStatusNext(objBEProctor);
// }
// catch (Exception Ex)
// {
// throw Ex;
// }
//}
public void BSetTransactionFlags(BEProctor objBEProctor)
{
try
{
new DProctor().DSetTransactionFlags(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetProctorExamLookUp(BEProctor objBEProctor)
{
try
{
new DProctor().DGetProctorExamLookUp(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetFlagStatus_DownLoadStatusExam(BEProctor objBEProctor)
{
try
{
new DProctor().DGetDownLoadFlagStatus(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetExamTransactionStatus(BEProctor objBEProctor)
{
try
{
new DProctor().DGetExamTransactionStatus(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetAutoProctorProviderDetails(BEProctor objBEProctor1)
{
try
{
new DProctor().DGetAutoProctorProviderDetails(objBEProctor1);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BAddProctor(BEProctor objBEProctor)
{
try
{
new DProctor().DAddProctor(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BUpdateEnableNextButtonTime(BEProctor objBEProctor)
{
try
{
new DProctor().DUpdateEnableNextButtonTime(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BSetExamSessionID(BEProctor objBEProctor)
{
try
{
new DProctor().DSetExamSessionID(objBEProctor);
}
catch (Exception Ex)
{
throw Ex;
}
}
