public List<DataEntity> GetAllPosition() { try { SqlDataReader dr; List<DataEntity> lstPosition = new List<DataEntity>(); dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetPosition", null); while (dr.Read()) { DataEntity objlocation = new DataEntity(); objlocation.PositionID = dr.GetInt32(0); objlocation.Position = dr.GetString(1); lstPosition.Add(objlocation); } return lstPosition; } catch (Exception ex) { throw ex; } }
public List <DataEntity> SetQuestionValue(Int32 I, Int32 J, string cat, Int32 CanId, string ExamDate) { try { List <DataEntity> lst = new List <DataEntity>(); SqlParameter[] param = { new SqlParameter("@FQuNo", SqlDbType.Int), new SqlParameter("@TQuNo", SqlDbType.Int), new SqlParameter("@Catgory", SqlDbType.NVarChar), new SqlParameter("@CandidateId", SqlDbType.Int), new SqlParameter("@TDate", SqlDbType.NVarChar) }; param[0].Value = I; param[1].Value = J; param[2].Value = cat; param[3].Value = CanId; param[4].Value = ExamDate; SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "SetQuestionValue", param); while (dr.Read()) { DataEntity DE = new DataEntity(); DE.FQuNo = dr.GetInt32(0); DE.Quvalue = dr.GetInt32(1); DE.QueGrade = dr.GetString(2); lst.Add(DE); } return(lst); } catch (Exception ex) { throw ex; } }
public List <DataEntity> GetCandidateDetails(Int32 CanId, string Pdate) { try { SqlDataReader dr; List <DataEntity> lstEmail = new List <DataEntity>(); SqlParameter[] param = { new SqlParameter("@canid", SqlDbType.Int), new SqlParameter("@Examdate", SqlDbType.NVarChar) }; param[0].Value = CanId; param[1].Value = Pdate; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "Email_GetCandidateDetails", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); objlocation.FirstNameTodisplayExampage = dr.GetString(0); objlocation.FirstName = dr.GetString(1); objlocation.EmailId = dr.GetString(2); objlocation.MobileNo = dr.GetString(3); objlocation.Position = dr.GetString(4); objlocation.ExamDate = dr.GetString(5); objlocation.StartTime = Convert.ToDateTime(dr.GetString(6)).ToString("HH:mm tt"); objlocation.EndTime = System.DateTime.Now.ToString("HH:mm tt"); lstEmail.Add(objlocation); } return(lstEmail); } catch (Exception ex) { throw ex; } }
public string GetCAFScore(Int32 CanId, string Pdate) { try { SqlDataReader dr; string CAFScore = string.Empty; SqlParameter[] param = { new SqlParameter("@Examdate", SqlDbType.NVarChar), new SqlParameter("@candidateid", SqlDbType.Int) }; param[0].Value = Pdate; param[1].Value = CanId; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetCAFScore", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); if (dr.GetValue(0) != DBNull.Value) { CAFScore = dr.GetDecimal(0).ToString(); } else { CAFScore = "0"; } } return(CAFScore); } catch (Exception ex) { throw ex; } }
private void SaveUpdateRecords(List <DataEntity> objSaveLst) { //string strQuery = string.Empty; //SqlConnection conn = new SqlConnection(DataConstant.SqlConn); //conn.Open(); try { foreach (DataEntity de in objSaveLst) { DataEntity InsertCAFAns = new DataEntity(); InsertCAFAns.QNo = de.QNo; InsertCAFAns.SelectedAns = de.SelectedAns; //strQuery = "IF NOT EXISTS(select * from dbo.MHRI_PSI_RSI_CAF_Scores where Candidateid=" + Session["Candidateid"] + " and Category='CAF' and QuesNo='" + de.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)) " + //" Insert into MHRI_PSI_RSI_CAF_Scores values(" + Session["Candidateid"] + ",getdate(),'" + de.QNo + "','X','" + de.SelectedAns + "','CAF')" + //" else " + //" Update MHRI_PSI_RSI_CAF_Scores set value='" + de.SelectedAns + "' where Candidateid=" + Session["Candidateid"] + " and Category='CAF' and QuesNo='" + de.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)"; DE.InsertCAFAnswer(InsertCAFAns, Convert.ToInt32(Session["Candidateid"])); //SqlCommand cmd = new SqlCommand(strQuery, conn); //cmd.ExecuteNonQuery(); } lblmsg.Text = "Record saved sucessfully"; } catch (Exception ex) { lblmsg.Text = ex.Message; } finally { //conn.Close(); } }
public List <DataEntity> GetCAFQuestion() { List <DataEntity> lstCAFquestion = new List <DataEntity>(); string sqlquery = "select QNo,Q1,COALESCE(Q2,''),A1,A2,A3,A4,COALESCE(ImageURL,'') from CAF"; //SqlCommand cmd = new SqlCommand("select QNo,Q1,COALESCE(Q2,''),A1,A2,A3,A4,COALESCE(ImageURL,'') from CAF", con); SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.Text, sqlquery, null); while (dr.Read()) { DataEntity obj = new DataEntity(); obj.QNo = dr.GetInt32(0); obj.Q1 = dr.GetString(1); if (dr.GetString(2) != null) { obj.Q2 = dr.GetString(2); } obj.A1 = dr.GetString(3); obj.A2 = dr.GetString(4); obj.A3 = dr.GetString(5); obj.A4 = dr.GetString(6); if (dr.GetString(7) != null) { obj.strImageURL = dr.GetString(7); } obj.SelectedAns = 0; lstCAFquestion.Add(obj); } return(lstCAFquestion); }
public void BindOptionButton(DataEntity X) { if (X.SelectedAns == 1) { RadioButton rd1 = (RadioButton)Repeater1.Items[0].FindControl("RadioButton1"); rd1.Checked = true; } else if (X.SelectedAns == 2) { RadioButton rd2 = (RadioButton)Repeater1.Items[0].FindControl("RadioButton2"); rd2.Checked = true; } else if (X.SelectedAns == 3) { RadioButton rd3 = (RadioButton)Repeater1.Items[0].FindControl("RadioButton3"); rd3.Checked = true; } else if (X.SelectedAns == 4) { RadioButton rd4 = (RadioButton)Repeater1.Items[0].FindControl("RadioButton4"); rd4.Checked = true; } }
public Boolean AuthencateCandidate(DataEntity objCan) { try { Boolean CandidateFlag; CandidateFlag = false; SqlParameter[] param = { new SqlParameter("@Fname", SqlDbType.NVarChar), new SqlParameter("@Lname", SqlDbType.NVarChar), new SqlParameter("@MobileNo", SqlDbType.NVarChar), new SqlParameter("@EmailId", SqlDbType.NVarChar), }; param[0].Value = objCan.FirstName; param[1].Value = objCan.LastName; param[2].Value = objCan.MobileNo; param[3].Value = objCan.EmailId; SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "AuthenticateCandidate", param); while (dr.Read()) { if (dr.GetInt32(0) == 1) { CandidateFlag = true; } } return(CandidateFlag); } catch (Exception ex) { throw ex; } }
public List <DataEntity> GetAllPosition() { try { SqlDataReader dr; List <DataEntity> lstPosition = new List <DataEntity>(); dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetPosition", null); while (dr.Read()) { DataEntity objlocation = new DataEntity(); objlocation.PositionID = dr.GetInt32(0); objlocation.Position = dr.GetString(1); lstPosition.Add(objlocation); } return(lstPosition); } catch (Exception ex) { throw ex; } }
public string GetPSIScore(Int32 CanId, string Pdate) { try { SqlDataReader dr; string maxchar=string.Empty ; SqlParameter[] param ={ new SqlParameter ("@Examdate",SqlDbType.NVarChar), new SqlParameter ("@candidateid",SqlDbType.Int) }; param[0].Value = Pdate; param[1].Value = CanId; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetcharectorScore", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); maxchar = maxchar+ dr.GetString(0); } return maxchar; } catch (Exception ex) { throw ex; } }
public List<DataEntity> GetRSIScore(Int32 CanId, string Pdate) { try { SqlDataReader dr; List<DataEntity> lstRSI = new List<DataEntity>(); SqlParameter[] param ={ new SqlParameter ("@Examdate",SqlDbType.NVarChar), new SqlParameter ("@candidateid",SqlDbType.Int) }; param[0].Value = Pdate; param[1].Value = CanId; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetRSIScore", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); objlocation.QChar = dr.GetString(0); objlocation.Quvalue = dr.GetInt32(1); lstRSI.Add(objlocation); } return lstRSI; } catch (Exception ex) { throw ex; } }
public List<DataEntity> GetCandidateDetails(Int32 CanId,string Pdate) { try { SqlDataReader dr; List<DataEntity> lstEmail = new List<DataEntity>(); SqlParameter[] param ={ new SqlParameter ("@canid",SqlDbType.Int), new SqlParameter ("@Examdate",SqlDbType.NVarChar) }; param[0].Value = CanId; param[1].Value = Pdate; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "Email_GetCandidateDetails", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); objlocation.FirstNameTodisplayExampage = dr.GetString(0); objlocation.FirstName = dr.GetString(1); objlocation.EmailId = dr.GetString(2); objlocation.MobileNo = dr.GetString(3); objlocation.Position = dr.GetString(4); objlocation.ExamDate = dr.GetString(5); objlocation.StartTime = Convert.ToDateTime(dr.GetString(6)).ToString("HH:mm tt"); objlocation.EndTime = System.DateTime.Now.ToString("HH:mm tt"); lstEmail.Add(objlocation); } return lstEmail; } catch (Exception ex) { throw ex; } }
public List<DataEntity> SetQuestionValue(Int32 I, Int32 J, string cat,Int32 CanId,string ExamDate) { try { List<DataEntity> lst = new List<DataEntity>(); SqlParameter[] param = { new SqlParameter ("@FQuNo",SqlDbType.Int), new SqlParameter ("@TQuNo",SqlDbType.Int), new SqlParameter ("@Catgory",SqlDbType.NVarChar), new SqlParameter ("@CandidateId",SqlDbType.Int), new SqlParameter ("@TDate",SqlDbType.NVarChar) }; param[0].Value = I; param[1].Value = J; param[2].Value = cat; param[3].Value = CanId; param[4].Value = ExamDate; SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "SetQuestionValue", param); while (dr.Read()) { DataEntity DE = new DataEntity(); DE.FQuNo = dr.GetInt32(0); DE.Quvalue = dr.GetInt32(1); DE.QueGrade = dr.GetString(2); lst.Add(DE); } return lst; } catch (Exception ex) { throw ex; } }
public Int32 InsertCandidateDetails(DataEntity objCan) { try { Int32 CandidateID; CandidateID = 0; SqlParameter[] param = { new SqlParameter ("@Fname",SqlDbType.NVarChar), new SqlParameter ("@Lname",SqlDbType.NVarChar), new SqlParameter ("@MobileNo",SqlDbType.NVarChar), new SqlParameter ("@EmailId",SqlDbType.NVarChar), new SqlParameter ("@LocationId",SqlDbType.Int), new SqlParameter ("@PositionId",SqlDbType.Int), new SqlParameter ("@Day",SqlDbType.NVarChar), new SqlParameter ("@month",SqlDbType.NVarChar), new SqlParameter ("@year",SqlDbType.NVarChar), new SqlParameter ("@qualificationid",SqlDbType.Int), new SqlParameter ("@ExperinceId",SqlDbType.Int), new SqlParameter ("@Accdec",SqlDbType.Bit), new SqlParameter ("@panNo",SqlDbType.NVarChar) }; param[0].Value = objCan.FirstName; param[1].Value = objCan.LastName; param[2].Value = objCan.MobileNo; param[3].Value = objCan.EmailId; param[4].Value = objCan.LocationID; param[5].Value = objCan.PositionID; param[6].Value = objCan.Day; param[7].Value = objCan.Month; param[8].Value = objCan.Year; param[9].Value = objCan.QualificationId; param[10].Value = objCan.ExperienceId; param[11].Value = objCan.AcceptDec; param[12].Value = objCan.PanNo; SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "InsetCandidateDetails", param); while (dr.Read()) { CandidateID = dr.GetInt32(0); } return CandidateID; } catch (Exception ex) { throw ex; } }
public void SendEmail(Int32 Canid, string pdate) { DataAccess DEmail = new DataAccess(); List <DataEntity> lst = new List <DataEntity>(); List <DataEntity> lstrsi = new List <DataEntity>(); if (MHRISesstion.HREmailid != "") { Int32 Canditeid = Canid; String Pdate = pdate; lst = DEmail.GetCandidateDetails(Canditeid, Pdate); string body = "<html> Hi </br></br> Please find the report of the pre-employment test below:</br></br></br> Name :[Name]</br> Email ID :[Emailid]</br> Mobile Number :[Mobile]</br> Position :[Position]</br> Exam Date :[ExamDate]</br>Exam Start Time :[StartTime]</br>Exam End Time :[EndTime] "; if (lst.Count > 0) { body = body.Replace("[Name]", lst[0].FirstName); Candidatename = lst[0].FirstName; body = body.Replace("[Emailid]", lst[0].EmailId); body = body.Replace("[Mobile]", lst[0].MobileNo); body = body.Replace("[Position]", lst[0].Position); body = body.Replace("[ExamDate]", lst[0].ExamDate); body = body.Replace("[StartTime]", lst[0].StartTime); body = body.Replace("[EndTime]", lst[0].EndTime); } string CAFscore = DEmail.GetCAFScore(Canditeid, Pdate); //body = body + "</br></br></br></br> Section 1: CAF </br> Score obtained is " + CAFscore + " out of " + 15 + "</br></br> Section 2: RSI</br> The score of various career anchor are below : <table > "; body = body + "</br></br></br></br> Section 1: CAF </br> Score obtained is " + CAFscore + " out of " + 15; body = body + "</br> CAF Examination Duration is " + MHRISesstion.CandidateCAFduration.ToString() + "mins"; body = body + "</br></br> Section 2: RSI</br> The score of various career anchor are below : <table > "; lstrsi = DEmail.GetRSIScore(Canditeid, Pdate); if (lstrsi.Count > 0) { foreach (var obj in lstrsi) { DataEntity D1 = new DataEntity(); body = body + "<tr> <td>" + obj.QChar + "</td>" + "<td>" + obj.Quvalue + "</td></tr>"; } } body = body + "</table>"; body = body + " </br></br> Section 3: PSI </br> The Profile according of PSI is :";// +</html>"; string psiscore = DEmail.GetPSIScore(Canditeid, Pdate); body = body + psiscore; string StrAbbreviations = DEmail.GetPSIAbbreviations(psiscore); if (StrAbbreviations != "") { string bodypart = " </br> A short description of the same is below :- </br> <table > <tr> <td > </td> <td >" + StrAbbreviations + "</td <td > </td> </tr> </table></html>"; body = body + bodypart; } else { body = body + "</html>"; } if (Candidatename != "") { Subject = "Pre-Employment test score for candidate:-" + " " + Candidatename; } else { Subject = "Pre-Employment test score for candidate:-" + " "; } EmailUtil.MHRISendMail(null, MHRISesstion.HREmailid, null, null, Subject, body, null, null, null, null, null); //EmailUtil.MHRISendMailTest(null, MHRISesstion.HREmailid, null, null, Subject, body, null, null, null, null, null); } }
public List<DataEntity> GetCAFQuestion() { List<DataEntity> lstCAFquestion = new List<DataEntity>(); string sqlquery="select QNo,Q1,COALESCE(Q2,''),A1,A2,A3,A4,COALESCE(ImageURL,'') from CAF"; //SqlCommand cmd = new SqlCommand("select QNo,Q1,COALESCE(Q2,''),A1,A2,A3,A4,COALESCE(ImageURL,'') from CAF", con); SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.Text, sqlquery, null); while (dr.Read()) { DataEntity obj = new DataEntity(); obj.QNo = dr.GetInt32(0); obj.Q1 = dr.GetString(1); if (dr.GetString(2) != null) obj.Q2 = dr.GetString(2); obj.A1 = dr.GetString(3); obj.A2 = dr.GetString(4); obj.A3 = dr.GetString(5); obj.A4 = dr.GetString(6); if (dr.GetString(7) != null) obj.strImageURL = dr.GetString(7); obj.SelectedAns = 0; lstCAFquestion.Add(obj); } return lstCAFquestion; }
public string GetCAFScore(Int32 CanId, string Pdate) { try { SqlDataReader dr; string CAFScore = string.Empty; SqlParameter[] param ={ new SqlParameter ("@Examdate",SqlDbType.NVarChar), new SqlParameter ("@candidateid",SqlDbType.Int) }; param[0].Value = Pdate; param[1].Value = CanId; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetCAFScore", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); if (dr.GetValue(0) != DBNull.Value) { CAFScore = dr.GetDecimal(0).ToString(); } else { CAFScore = "0"; } } return CAFScore; } catch (Exception ex) { throw ex; } }
protected void BtnLogin_Click(object sender, ImageClickEventArgs e) { try { bool IsvalidMobile, IsvalidEmial, IsvalidPAN; IsvalidMobile = ValidateMobileControl(); IsvalidEmial = ValidateEmailControl(); IsvalidPAN = ValidatePANControl(); if (IsvalidMobile && IsvalidEmial && IsvalidPAN) { Boolean Flag; Flag = false; DataAccess AuthenCandidate = new DataAccess(); DataEntity DE = new DataEntity(); DE.FirstName = txtfirstname.Text; DE.LastName = txtlastname.Text; DE.MobileNo = txtmobile.Text; DE.EmailId = txtEmail.Text; //Flag = AuthenCandidate.AuthencateCandidate(DE); Flag = true; if (Flag == true) { DE.LocationID = Convert.ToInt32(ddllocation.SelectedValue); DE.PositionID = Convert.ToInt32(ddlposition.SelectedValue); DE.QualificationId = Convert.ToInt32(ddlQualification.SelectedValue); DE.ExperienceId = Convert.ToInt32(ddlExpeience.SelectedValue); DE.Day = ddlday.SelectedItem.Text; DE.Month = ddldobmonth.SelectedItem.Text; DE.Year = txtyear.Text; if (chkdeclaration.Checked == true) { DE.AcceptDec = 1; } else { DE.AcceptDec = 0; } DE.PanNo = txtpanno.Text; if (vadidateDOB(DE.Day, DE.Month, DE.Year)) { if (chkdeclaration.Checked == true) { //Int32 can = AuthenCandidate.InsertCandidateDetails(DE); MHRISesstion.CandidateId = Convert.ToString(AuthenCandidate.InsertCandidateDetails(DE)); MHRISesstion.HRCandidateFirstName = txtfirstname.Text; //MHRISesstion.TimeLeftofCAFTest = null; Session["TimeLeftofCAFTest"] = null; Response.Redirect("../Forms/CAF.aspx", false); } else { lblErrorMessage.Visible = true; lblErrorMessage.Text = "Please accept the declaration."; } } else { lblErrorMessage.Visible = true; lblErrorMessage.Text = "DOB Not Proper Format And Year Should be >=1753 !!!!"; } } else { lblErrorMessage.Visible = true; lblErrorMessage.Text = "You Are Not Authorised,Please Contact HR !!!!"; } } } catch (Exception ex) { throw ex; } }
public string GetPSIAbbreviations(string score ) { try { SqlDataReader dr; string Abbreviations = string.Empty; SqlParameter[] param ={ new SqlParameter ("@qchar",SqlDbType.NVarChar) }; param[0].Value = score; dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "Get_PSI_Abbreviations", param); while (dr.Read()) { DataEntity objlocation = new DataEntity(); if (dr.GetValue(0) != DBNull.Value) { Abbreviations = dr.GetString(0); } } return Abbreviations; } catch (Exception ex) { throw ex; } }
public List<DataEntity> GetAllExperience() { try { SqlDataReader dr; List<DataEntity> lstExperience = new List<DataEntity>(); dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "GetAllExperience", null); while (dr.Read()) { DataEntity objExperience = new DataEntity(); objExperience.ExperienceId = dr.GetInt32(0); objExperience.Experience = dr.GetString(1); lstExperience.Add(objExperience); } return lstExperience; } catch (Exception ex) { throw ex; } }
public void InsertCAFAnswer(DataEntity ObjCAFAnswer,Int32 CandidateId) { string strQuery = "IF NOT EXISTS(select * from dbo.MHRI_PSI_RSI_CAF_Scores where Candidateid=" + CandidateId + " and Category='CAF' and QuesNo='" + ObjCAFAnswer.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)) " + " Insert into MHRI_PSI_RSI_CAF_Scores values(" + CandidateId + ",getdate(),'" + ObjCAFAnswer.QNo + "','X','" + ObjCAFAnswer.SelectedAns + "','CAF')" + " else " + " Update MHRI_PSI_RSI_CAF_Scores set value='" + ObjCAFAnswer.SelectedAns + "' where Candidateid=" + CandidateId + " and Category='CAF' and QuesNo='" + ObjCAFAnswer.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)"; SqlHelper.ExecuteNonQuery(DataConstant.SqlConn, CommandType.Text, strQuery, null); }
public Boolean AuthencateCandidate(DataEntity objCan) { try { Boolean CandidateFlag; CandidateFlag = false; SqlParameter[] param = { new SqlParameter ("@Fname",SqlDbType.NVarChar), new SqlParameter ("@Lname",SqlDbType.NVarChar), new SqlParameter ("@MobileNo",SqlDbType.NVarChar), new SqlParameter ("@EmailId",SqlDbType.NVarChar), }; param[0].Value = objCan.FirstName; param[1].Value = objCan.LastName; param[2].Value = objCan.MobileNo; param[3].Value = objCan.EmailId; SqlDataReader dr = SqlHelper.ExecuteReader(DataConstant.SqlConn, CommandType.StoredProcedure, "AuthenticateCandidate", param); while (dr.Read()) { if (dr.GetInt32(0) == 1) { CandidateFlag = true; } } return CandidateFlag; } catch (Exception ex) { throw ex; } }
private void SaveUpdateRecords(List<DataEntity> objSaveLst) { //string strQuery = string.Empty; //SqlConnection conn = new SqlConnection(DataConstant.SqlConn); //conn.Open(); try { foreach (DataEntity de in objSaveLst) { DataEntity InsertCAFAns=new DataEntity (); InsertCAFAns.QNo = de.QNo; InsertCAFAns.SelectedAns = de.SelectedAns; //strQuery = "IF NOT EXISTS(select * from dbo.MHRI_PSI_RSI_CAF_Scores where Candidateid=" + Session["Candidateid"] + " and Category='CAF' and QuesNo='" + de.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)) " + //" Insert into MHRI_PSI_RSI_CAF_Scores values(" + Session["Candidateid"] + ",getdate(),'" + de.QNo + "','X','" + de.SelectedAns + "','CAF')" + //" else " + //" Update MHRI_PSI_RSI_CAF_Scores set value='" + de.SelectedAns + "' where Candidateid=" + Session["Candidateid"] + " and Category='CAF' and QuesNo='" + de.QNo + "' and QuestionChar='X' and convert(date,Examdate,101)=convert(date,GETDATE(),101)"; DE.InsertCAFAnswer(InsertCAFAns,Convert.ToInt32(Session["Candidateid"])); //SqlCommand cmd = new SqlCommand(strQuery, conn); //cmd.ExecuteNonQuery(); } lblmsg.Text = "Record saved sucessfully"; } catch (Exception ex) { lblmsg.Text = ex.Message; } finally { //conn.Close(); } }
public void SendEmail( Int32 Canid, string pdate) { DataAccess DEmail = new DataAccess(); List<DataEntity> lst = new List<DataEntity>(); List<DataEntity> lstrsi = new List<DataEntity>(); if (MHRISesstion.HREmailid != "") { Int32 Canditeid = Canid; String Pdate = pdate; lst = DEmail.GetCandidateDetails(Canditeid, Pdate); string body = "<html> Hi </br></br> Please find the report of the pre-employment test below:</br></br></br> Name :[Name]</br> Email ID :[Emailid]</br> Mobile Number :[Mobile]</br> Position :[Position]</br> Exam Date :[ExamDate]</br>Exam Start Time :[StartTime]</br>Exam End Time :[EndTime] "; if (lst.Count > 0) { body = body.Replace("[Name]", lst[0].FirstName); Candidatename = lst[0].FirstName; body = body.Replace("[Emailid]", lst[0].EmailId); body = body.Replace("[Mobile]", lst[0].MobileNo); body = body.Replace("[Position]", lst[0].Position); body = body.Replace("[ExamDate]", lst[0].ExamDate); body = body.Replace("[StartTime]", lst[0].StartTime); body = body.Replace("[EndTime]", lst[0].EndTime); } string CAFscore=DEmail.GetCAFScore(Canditeid, Pdate); //body = body + "</br></br></br></br> Section 1: CAF </br> Score obtained is " + CAFscore + " out of " + 15 + "</br></br> Section 2: RSI</br> The score of various career anchor are below : <table > "; body = body + "</br></br></br></br> Section 1: CAF </br> Score obtained is " + CAFscore + " out of " + 15; body = body + "</br> CAF Examination Duration is " + MHRISesstion.CandidateCAFduration.ToString() + "mins" ; body = body + "</br></br> Section 2: RSI</br> The score of various career anchor are below : <table > "; lstrsi = DEmail.GetRSIScore(Canditeid, Pdate); if (lstrsi.Count > 0) { foreach (var obj in lstrsi) { DataEntity D1 = new DataEntity(); body = body + "<tr> <td>" + obj.QChar + "</td>" + "<td>" + obj.Quvalue + "</td></tr>"; } } body = body + "</table>"; body = body + " </br></br> Section 3: PSI </br> The Profile according of PSI is :";// +</html>"; string psiscore = DEmail.GetPSIScore(Canditeid, Pdate); body = body + psiscore; string StrAbbreviations = DEmail.GetPSIAbbreviations(psiscore); if (StrAbbreviations != "") { string bodypart = " </br> A short description of the same is below :- </br> <table > <tr> <td > </td> <td >" + StrAbbreviations + "</td <td > </td> </tr> </table></html>"; body = body + bodypart; } else { body = body + "</html>"; } if (Candidatename != "") { Subject = "Pre-Employment test score for candidate:-" + " " + Candidatename; } else { Subject = "Pre-Employment test score for candidate:-" + " "; } EmailUtil.MHRISendMail(null, MHRISesstion.HREmailid, null, null, Subject, body, null, null, null, null, null); //EmailUtil.MHRISendMailTest(null, MHRISesstion.HREmailid, null, null, Subject, body, null, null, null, null, null); } }