protected void showTableCertAccredit(string Title, string Inst_Name, string Cat, string TPName, string ClassResultId)
{
string strSPContractorID = objcryptoJS.AES_encrypt(ClassResultId.ToString(), AppConstants.secretKey, AppConstants.initVec).ToString();
bool IsSubmitted = false;
clsCourse_Result objCR = new clsCourse_Result();
objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId));
if (objCR != null)
{
if ((objCR.Acct_Term > 0))
{
IsSubmitted = true;
}
}
StringBuilder strContent = new StringBuilder("<tr>");
strContent.Append("<td width='15%' nowrap><a href='AppCA.aspx?dash=active&cgi=" + System.Web.HttpUtility.UrlEncode(strSPContractorID) + "' >");
strContent.Append(Title);
strContent.Append("</a></td>");
strContent.Append("<td width='10%'nowrap>");
strContent.Append(Inst_Name);
strContent.Append("</td>");
strContent.Append("<td width='10%'nowrap>");
strContent.Append(Cat);
strContent.Append("</td>");
strContent.Append("<td width='10%'nowrap>");
strContent.Append(TPName);
strContent.Append("</td>");
//***************************************
strContent.Append("<td width='5%' nowrap>");
if (IsSubmitted)
{
strContent.Append("<a class='btn btn-xs btn-default' href='#'>Applied for C&A Certification</a>");
}
else
{
strContent.Append("<a class='btn btn-xs btn-primary' href='AppCA.aspx?dash=active&cgi=" + System.Web.HttpUtility.UrlEncode(strSPContractorID) + "'>Apply for C&A</a>");
}
strContent.Append("</td>");
pnlMyCourses.Controls.Add(new LiteralControl(strContent.ToString()));
}
protected void AddTManual_Click(object sender, EventArgs e)
{
Security objSecurity = new Security();
#region "variables"
string vPayment = dropPayment.SelectedItem.Value;
string vBackGround = dropBackGround.SelectedItem.Value;
string vVerify = dropEmpVerify.SelectedItem.Value;
string vComments = string.Empty;
string vFinalStatus = dropFinalStatus.SelectedItem.Value;
#endregion
string strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(strTCSID).Length > 0)
{
strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
}
clsCourse_Result objCR = new clsCourse_Result();
objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(strTCSID));
if (objCR != null)
{
objCR.MDE_AuthorisedUserId = Convert.ToInt32(HttpContext.Current.Session["UserAuthId"].ToString());
objCR.MDE_EmployerVeri = Convert.ToInt32(vVerify);
objCR.MDE_BackGround = Convert.ToInt32(vBackGround);
objCR.MDE_PaymentVeri = Convert.ToInt32(vPayment);
objCR.MDE_F_Decision = Convert.ToInt32(vFinalStatus);
objCR.MDE_F_Notes = vComments;
objCR.Notes = objCR.Notes + " " + DateTime.Now.ToShortDateString();
objCR.IsActive = Convert.ToInt32(vFinalStatus);
if (Course_ResultDAL.UpdateCourse_Result(objCR))
{
//strTCSID = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCSID.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Saved successfully!', '', 'success', 'MDE_ApprCertApps.aspx?approvecertapp=active');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Error: Cannot Save Records!', '', 'danger', '#');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Error: Cannot Save Records!', '', 'danger', '#');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
string ClassResultId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(ClassResultId).Length > 0)
{
ClassResultId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"]), AppConstants.secretKey, AppConstants.initVec).ToString();
}
#region Getting all the Contractors list
List <clsSP_Contractor> lstSPCont = new List <clsSP_Contractor>();
lstSPCont = SP_ContractorDAL.SelectDynamicSP_Contractor("IsActive = 1 and ACRDCatID = 13", "SPContractorID");
if (lstSPCont != null)
{
if (lstSPCont.Count > 0)
{
dropContractors.Items.Add(new ListItem(
String.Format("{0}", "Select Contractor"), String.Format("{0}", "0")));
for (int i = 0; i < lstSPCont.Count; i++)
{
dropContractors.Items.Add(new ListItem(
String.Format("{0}", SQLHelper.TrimAndReplaceEOF(lstSPCont[i].SPName.ToString())), String.Format("{0}", SQLHelper.TrimAndReplaceEOF(objcryptoJS.AES_encrypt(lstSPCont[i].SPContractorID.ToString(), AppConstants.secretKey, AppConstants.initVec).ToString()))));
}
}
}
#endregion
clsCourse_Result objCR = new clsCourse_Result();
objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId));
if (objCR != null)
{
if ((objCR.Acct_Term > 0))
{
btnAddCourse.Enabled = false;
btnAddCourse.Text = "Applied for C&A Certification";
}
}
}
catch (Exception)
{
}
}
}
public static Boolean InsertUpdateCourse_Result(clsCourse_Result objCourse_Result)
{
bool isAdded = false;
string SpName = "usp_InsertUpdateCourse_Result";
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
db.Execute(SpName, objCourse_Result, commandType: CommandType.StoredProcedure);
}
isAdded = true;
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
return(isAdded);
}
public static clsCourse_Result SelectCourse_ResultById(int?ClassResultId)
{
clsCourse_Result objCourse_Result = new clsCourse_Result();
bool isnull = true;
string SpName = "usp_SelectCourse_Result";
var objPar = new DynamicParameters();
if (String.IsNullOrEmpty(ClassResultId.ToString()))
{
throw new ArgumentException("Function parameters cannot be blank!");
}
else
{
try
{
objPar.Add("@ClassResultId", ClassResultId, dbType: DbType.Int32);
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
objCourse_Result = db.Query <clsCourse_Result>(SpName, objPar, commandType: CommandType.StoredProcedure).SingleOrDefault();
isnull = false;
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
}
if (isnull)
{
return(null);
}
else
{
return(objCourse_Result);
}
}
protected void AddTManual_Click(object sender, EventArgs e)
{
Security objSecurity = new Security();
CryptoJS objcryptoJS = new CryptoJS();
string ClassResultId = string.Empty;
#region "variables"
//// string vSPName = objSecurity.KillChars(txtTPName.Text);
// string vContractor = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(dropContractors.SelectedItem.Value), AppConstants.secretKey, AppConstants.initVec).ToString();
// //string vTPPhone = objSecurity.KillChars(txtTPPhone.Text);
// //string vTPMobile = objSecurity.KillChars(txtTPMobile.Text);
// //string vTPWebsite = objSecurity.KillChars(txtTPWebsite.Text);
// //string vTPEmail = objSecurity.KillChars(txtTPEmail.Text);
// int intNewTPID = 0;
// int intNewInstructorId = 0;
#endregion
#region Instructor Info
//string vCategory = objcryptoJS.AES_decrypt(dropCategory.SelectedItem.Value, AppConstants.secretKey, AppConstants.initVec).ToString();
//string vInstructorFName = objSecurity.KillChars(txtInstructorFName.Text);
//string vInstructorLName = objSecurity.KillChars(txtInstructorLName.Text);
//string vInsAccId = objSecurity.KillChars(txtInsAccId.Text);
//string vInsAccExpire = objSecurity.KillChars(txtAccdExpireDate.Text);
//string vInstEmail = objSecurity.KillChars(txtInstEmail.Text);
#endregion
#region Address 1
//string vAddress_1 = objSecurity.KillChars(txtAddress_1.Text);
//string vAddress_2 = objSecurity.KillChars(txtAddress_2.Text);
//string vCity = objSecurity.KillChars(txtCity.Text);
//string vCounty = objSecurity.KillChars(txtCounty.Text);
//string vState = objSecurity.KillChars(txtState.Text);
//string vZipCode = objSecurity.KillChars(txtZipCode.Text);
//string vEmail = objSecurity.KillChars(txtTPEmail.Text);
//string vLocationTitle = objSecurity.KillChars(txtLocTitle.Text);
#endregion
try
{
ClassResultId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(ClassResultId).Length > 0)
{
ClassResultId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"]), AppConstants.secretKey, AppConstants.initVec).ToString();
}
clsCourse_Result objCR = new clsCourse_Result();
objCR = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(ClassResultId));
if (objCR != null)
{
objCR.PaymentAmount = "120.00";
objCR.Acct_Term = Convert.ToInt32(dropYears.SelectedItem.Value);
objCR.Notes = "User Entered Contractor Id: " + dropContractors.SelectedItem.Value;
if (!Course_ResultDAL.UpdateCourse_Result(objCR))
{
}
}
}
catch (Exception)
{
ErrorHandler.ErrorPage();
}
string strResultId = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode("10"), AppConstants.secretKey, AppConstants.initVec).ToString();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Your Application has been submitted successfully!', '', 'success', 'RoleDesc.aspx?Dash=active&cgi=" + strResultId + "');", true);
}
protected void AddTManual_Click(object sender, EventArgs e)
{
Security objSecurity = new Security();
#region "variables"
string vPassFail = dropPassFail.SelectedItem.Value;
string vtxtAttendence = dropAttendence.SelectedItem.Value;
string vScore = dropScore.SelectedItem.Value;
string vAuthorisedUserId = string.Empty;
string vTrainingCourseScheduleId = string.Empty;
string vInstructorId = string.Empty;
string vTPLocationId = string.Empty;
string vTPId = string.Empty;
string vSPContractorID = string.Empty;
#endregion
string strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(strTCSID).Length > 0)
{
strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
}
#region Getting rest of the values.
List <dynamic> lstCourses;
string strSQLC = @"SELECT tbl_LK_Inst_CourseSchedule.Inst_CourseSchId, tbl_LK_Inst_CourseSchedule.AuthorisedUserId, tbl_LK_Inst_CourseSchedule.TrainingCourseScheduleId, tbl_LK_Inst_CourseSchedule.InstructorId,
tbl_LK_Inst_CourseSchedule.TP_AuthorisedUserId, tbl_CourseSchedule.CourseId, tbl_LK_Inst_CourseSchedule.IsApproved, tbl_CourseSchedule.TPLocationId, tbl_CourseSchedule.TPId
FROM tbl_LK_Inst_CourseSchedule INNER JOIN
tbl_CourseSchedule ON tbl_LK_Inst_CourseSchedule.TrainingCourseScheduleId = tbl_CourseSchedule.TrainingCourseScheduleId INNER JOIN
tbl_TrainingProvider ON tbl_CourseSchedule.TPId = tbl_TrainingProvider.TPId
WHERE (tbl_LK_Inst_CourseSchedule.Inst_CourseSchId = @CourseSchId)";
var objParC = new DynamicParameters();
objParC.Add("@CourseSchId", strTCSID, DbType.String);
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstCourses = db.Query <dynamic>(strSQLC, objParC, commandType: CommandType.Text).ToList();
if (lstCourses != null)
{
if (lstCourses.Count > 0)
{
vAuthorisedUserId = GlobalMethods.ValueIsNull(lstCourses[0].AuthorisedUserId);
vTrainingCourseScheduleId = GlobalMethods.ValueIsNull(lstCourses[0].TrainingCourseScheduleId);
vInstructorId = GlobalMethods.ValueIsNull(lstCourses[0].InstructorId);
vTPLocationId = GlobalMethods.ValueIsNull(lstCourses[0].TPLocationId);
vTPId = GlobalMethods.ValueIsNull(lstCourses[0].TPId);
vSPContractorID = GlobalMethods.ValueIsNull(lstCourses[0].SPContractorID);
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Checking if this is IsApproved ... if not Updating the value with TPID to LK_Inst_CourseSchedule
List <clsLK_Inst_CourseSchedule> lstICS = new List <clsLK_Inst_CourseSchedule>();
lstICS = LK_Inst_CourseScheduleDAL.SelectDynamicLK_Inst_CourseSchedule("Inst_CourseSchId = " + strTCSID + " and AuthorisedUserId = " + vAuthorisedUserId + " and IsApproved = 1", "Inst_CourseSchId");
if (lstICS != null)
{
if (lstICS.Count > 0)
{
}
else
{
clsLK_Inst_CourseSchedule objICS = new clsLK_Inst_CourseSchedule();
objICS = LK_Inst_CourseScheduleDAL.SelectLK_Inst_CourseScheduleById(Convert.ToInt32(strTCSID));
if (objICS != null)
{
objICS.IsApproved = 1;
objICS.TP_AuthorisedUserId = Convert.ToInt32(vTPId);
if (!LK_Inst_CourseScheduleDAL.UpdateLK_Inst_CourseSchedule(objICS))
{
}
}
}
}
#endregion
clsCourse_Result objCR = new clsCourse_Result();
objCR.Inst_CourseSchId = Convert.ToInt32(strTCSID);
objCR.AuthorisedUserId = Convert.ToInt32(vAuthorisedUserId);
objCR.TrainingCourseScheduleId = Convert.ToInt32(vTrainingCourseScheduleId);
objCR.InstructorId = Convert.ToInt32(vInstructorId);
objCR.MDE_AuthorisedUserId = 0;
objCR.TPLocationId = Convert.ToInt32(vTPLocationId);
objCR.TPId = Convert.ToInt32(vTPId);
objCR.SPContractorID = 0;
objCR.Inst_PASSFAIL = Convert.ToInt32(vPassFail);
objCR.Inst_Attendence = Convert.ToInt32(vtxtAttendence);
objCR.Inst_ScorePercent = vScore;
objCR.Inst_TrainingCard = "";
objCR.MDE_EmployerVeri = 0;
objCR.MDE_BackGround = 0;
objCR.MDE_PaymentVeri = 0;
objCR.PaymentAmount = "";
objCR.Acct_Term = 0;
objCR.MDE_F_Decision = 0;
objCR.MDE_F_Notes = "";
objCR.MDE_Acct_Certificate = "";
objCR.CreatedDate = DateTime.Now;
objCR.Notes = "";
objCR.IsActive = -1;
if (Course_ResultDAL.InsertCourse_Result(objCR))
{
strTCSID = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCSID.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Saved successfully!', '', 'success', 'Inst_SaveScores.aspx?dash=active&cgi=" + strTCSID + "');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Error: Cannot Save Records!', '', 'danger', '#');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strTCSID = string.Empty;
string strTCid = string.Empty;
try
{
strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(strTCSID).Length > 0)
{
strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
}
#region Getting Class Details
clsCourse_Result objCS = new clsCourse_Result();
objCS = Course_ResultDAL.SelectCourse_ResultById(Convert.ToInt32(strTCSID));
if (objCS != null)
{
#region Getting Employer info
clsSP_Contractor objCont = new clsSP_Contractor();
objCont = SP_ContractorDAL.SelectSP_ContractorById(objCS.SPContractorID);
if (objCont != null)
{
lblEmployerName.Text = objCont.SPName;
lblEmployerEmail.Text = objCont.SPEmail;
lblEmployerPhone.Text = objCont.SPPhone + " / " + objCont.SPMobile;
}
#endregion
lblYearFor.Text = objCS.Acct_Term.ToString();
clsUser objUser = new clsUser();
objUser = UserDAL.SelectUserById(objCS.AuthorisedUserId);
if (objUser != null)
{
lblCrouseName.Text = objUser.FName + " " + objUser.LName;
}
if (objCS.IsActive == 1)
{
// this records already exsistes
btnAddTManual.Enabled = false;
dropEmpVerify.Enabled = false;
dropPayment.Enabled = false;
dropFinalStatus.Enabled = false;
dropBackGround.Enabled = false;
txtNotes.Enabled = false;
//strTCid = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCid.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a class='btn btn-success download' title='Download as PDF' href='/" + objcryptoJS.AES_encrypt("Acct_Certificate", AppConstants.secretKey, AppConstants.initVec) + ".cert' target='_blank' >Generate Accreditation Certificate</a>" + GlobalMethods.ContractorAppStatus(1, "bar", "MDE_ApprCertApps.aspx?approvecertapp=active") + "</div>"));
}
else
{
btnAddTManual.Enabled = true;
dropEmpVerify.Enabled = true;
dropPayment.Enabled = true;
dropFinalStatus.Enabled = true;
dropBackGround.Enabled = true;
txtNotes.Enabled = true;
//strTCid = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCid.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'>" + GlobalMethods.ContractorAppStatus(9, "bar", "MDE_ApprCertApps.aspx?approvecertapp=active") + "</div>"));
}
}
#endregion
}
catch (Exception)
{
ErrorHandler.ErrorPage();
}
}
}
