private void GetMaximumaMarks(int courseId)
{
var objSecurePage = new SecurePage();
DataSet collegeData = null;
var dataStatus = 0;
var errMsg = "";
var objConsulling = new Consulling();
var objDataTable = objConsulling.GetMaximiumMarksByCourseId(courseId, objSecurePage.LoggedInUserId);
if (objDataTable != null && objDataTable.Rows.Count > 0)
{
collegeData = objConsulling.CheckCollegeSeatAvialibity(
Convert.ToInt32(Request.QueryString["collegeId"]),
Convert.ToInt32(
objDataTable.Rows[0]["TotalMarks"].ToString()), out dataStatus, out errMsg);
}
switch (dataStatus)
{
case -1:
UcSeatAvailiablity.CollegeBranchCourseId = Request.QueryString["collegeId"];
UcSeatAvailiablity.DataStatus = errMsg;
break;
case 1:
UcSeatAvailiablity.DataStatus = errMsg;
UcSeatAvailiablity.BindRepesater = collegeData;
break;
}
}
private void UpdateUserTransctionalDetails(string euserEmailId, string efrmNumber, string euserId)
{
var objCrypto = new ClsCrypto(ClsSecurity.GetPasswordPhrase(Common.PassPhraseOne, Common.PassPhraseTwo));
var objConsulling = new Consulling();
var objMailTemplates = new MailTemplates();
var objSecure = new SecurePage();
euserEmailId = euserEmailId.Replace(" ", "+");
string emailId = Convert.ToString(objCrypto.Decrypt(euserEmailId));
try
{
euserId = euserId.Replace(" ", "+");
string userId = Convert.ToString(objCrypto.Decrypt(euserId));
string frmNumber = efrmNumber.Replace(" ", "+");
frmNumber = Convert.ToString(objCrypto.Decrypt(frmNumber));
int i;
i = objConsulling.InsertUpdateUserTransctionalDetails(Convert.ToInt32(userId), frmNumber, true, "online", "PNB", Convert.ToString(frmNumber +
DateTime.Now.ToString(
"hh:mm:ss")), Request.QueryString["Amount"] != null ? objCrypto.Decrypt(Request.QueryString["Amount"]) : "26100");
if (i > 0)
{
var userDetails = UserManagerProvider.Instance.GetUserListById(Convert.ToInt32(userId));
var sp = userDetails.First();
objSecure.LoggedInUserEmailId = emailId;
objSecure.LoggedInUserId = sp.UserId;
objSecure.LoggedInUserName = Common.GetStringProperCase(sp.UserFullName);
objSecure.LoggedInUserType = sp.UserCategoryId;
objSecure.LoggedInUserMobile = sp.MobileNo;
lblName.Text = Common.GetStringProperCase(sp.UserFullName);
var mail = new MailMessage
{
From = new MailAddress(ApplicationSettings.Instance.Email),
Subject = "AdmissionJankari:Direct Admission Payment confirmation for form number:" + frmNumber
};
var body = objMailTemplates.MailBodyForPaymentConformation("http://www.admissionjankari.com/", sp.UserFullName, frmNumber, "Online", Convert.ToString(frmNumber + DateTime.Now.ToString("hh:mm:ss")));
mail.Body = body;
mail.To.Add(emailId);
mail.Bcc.Add(ClsSingelton.bccDirectAdmission);
Utils.SendMailMessageAsync(mail);
sucessMsg.Visible = true;
}
else
{
failureMsg.Visible = true;
}
}
catch (Exception ex)
{
var err = ex.Message;
failureMsg.Visible = true;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateUserTransctionalDetails in PaymentConformation.aspx for user :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
lblMsg.Visible = false;
string Errormsg = "";
var insert = 0;
try
{
insert = new Consulling().InsertUserRefund(txtRefundName.Text.Trim().ToString(), txtRefundEmailId.Text.Trim().ToString(), txtRefundForm.Text.Trim().ToString(), out Errormsg);
if (insert > 0)
{
var userData = UserManagerProvider.Instance.GetUserListByEmailId(txtRefundEmailId.Text.Trim().ToString());
userData = userData.Where(result => result.UserEmailid == txtRefundEmailId.Text.Trim().ToString()).ToList();
sendMailtoUser(userData.First().CourseName.Trim());
sendMailtoAdmin(userData.First().CourseName.Trim());
}
lblMsg.CssClass = insert > 0?"success":"error";
lblMsg.Text = Errormsg;
clearForm();
lblMsg.Visible = true;
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error in Executing btnSubmit_Click in Refund.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
private void UpdateUserTranscationalDetails()
{
var objSecurePage = new SecurePage();
var objCommon = new Common();
var objConsulling = new Consulling();
var formNum = "ADMJ" + System.DateTime.Now.Year + objCommon.CourseId.ToString() + objSecurePage.LoggedInUserId.ToString();
try
{
var i = objConsulling.InsertUpdateUserTransctionalDetails(objSecurePage.LoggedInUserId, formNum, true,
"", "", "", "26100");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing UpdateUserTranscationalDetails in Payment.aspx for user :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method To Bind User Final Intertested List
protected void BindUserIntertestedList(int userId)
{
Consulling ObjConsulling = new Consulling();
DataSet ds = new DataSet();
try
{
ds = ObjConsulling.GetIntertestedCollege(userId);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
hndCollegeList.Value = ds.Tables[0].Rows.Count.ToString();
rptCollegeDetails.DataSource = ds.Tables[0];
rptCollegeDetails.DataBind();
}
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindUserIntertestedList in UcFinalIntertestedCollegeList.ascx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void Finsh(object sender, EventArgs e)
{
var objSecurePage = new SecurePage();
var objConsulling = new Consulling();
_objCommon = new Common();
var objMailTemplates = new MailTemplates();
var ddNumber = string.Empty;
var formNum = "ADMJ" + DateTime.Now.Year + _objCommon.CourseId.ToString() + objSecurePage.LoggedInUserId.ToString();
var tranctionDetails = string.Empty;
if (rbtnPaymentType.SelectedValue == "OnPayment")
{
OnlinePayment();
}
int i = objConsulling.InsertUpdateUserTransctionalDetails(objSecurePage.LoggedInUserId, formNum, false, rbtnPaymentType.SelectedItem.ToString(), "", "", "26100");
var mail = new MailMessage
{
From = new MailAddress(ApplicationSettings.Instance.Email),
Subject = "Direct Admission:Form Number" + formNum
};
var body = objMailTemplates.SendValidationMailForTheBookSeat("http://www.admissionjankari.com/", objSecurePage.LoggedInUserName, formNum, rbtnPaymentType.SelectedItem.ToString(), _objCommon.CourseName);
mail.Body = body;
mail.To.Add(objSecurePage.LoggedInUserEmailId);
mail.Bcc.Add(ClsSingelton.bccDirectAdmission);
Utils.SendMailMessageAsync(mail);
if (rbtnPaymentType.SelectedValue != "OnPayment")
{
Response.Redirect(Utils.AbsoluteWebRoot + "ConformationPage.aspx/");
}
}
// Method to Bind The Laterentry Info
public void BindLateralEntryInfo(int courseId)
{
_ObjConsulling = new Consulling();
_dt = new DataTable();
try
{
_dt = _ObjConsulling.GetCourseAdmissionEligibilty(courseId);
if (_dt.Rows.Count > 0)
{
ltrEntry.Visible = true;
rbtCourseAdmissionEligibilty.DataSource = _dt;
rbtCourseAdmissionEligibilty.DataTextField = "AjCourseCounsellingEligibilityName";
rbtCourseAdmissionEligibilty.DataValueField = "AjCourseCounsellingEligibilityId";
rbtCourseAdmissionEligibilty.DataBind();
}
else
{
ltrEntry.Visible = false;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindLateralEntryInfo in UcStudentAcademic.axcs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// method to Insert Update Exam Appared
protected int InsertUpdateExamApp(int userId)
{
_ObjConsulling = new Consulling();
int i = 0;
try
{
if (!String.IsNullOrEmpty(StudentExamInfo.ExamApp1))
{
i = _ObjConsulling.InsertUpdateStudentExamAppeared(userId, StudentExamInfo.ExamApp1, StudentExamInfo.ExamApp1Rank1);
}
if (!String.IsNullOrEmpty(StudentExamInfo.ExamApp2))
{
i = _ObjConsulling.InsertUpdateStudentExamAppeared(userId, StudentExamInfo.ExamApp2, StudentExamInfo.ExamApp2Rank2);
}
if (!String.IsNullOrEmpty(StudentExamInfo.ExamApp3))
{
i = _ObjConsulling.InsertUpdateStudentExamAppeared(userId, StudentExamInfo.ExamApp3, StudentExamInfo.ExamApp3Rank3);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertUpdateExamApp in StudentCounselling.axpx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(i);
}
// Method to Insert student College prefrance
protected int InsertCollegePrefrance(int userId, int courseId)
{
_ObjConsulling = new Consulling();
int i = 0;
try
{
if (!String.IsNullOrEmpty(UcCollegePrefrance.StudentCollegePrefrance1))
{
i = _ObjConsulling.InsertStudentCollegePrefrance(userId, UcCollegePrefrance.StudentCollegePrefrance1, courseId);
}
if (!String.IsNullOrEmpty(UcCollegePrefrance.StudentCollegePrefrance2))
{
i = _ObjConsulling.InsertStudentCollegePrefrance(userId, UcCollegePrefrance.StudentCollegePrefrance2, courseId);
}
if (!String.IsNullOrEmpty(UcCollegePrefrance.StudentCollegePrefrance3))
{
i = _ObjConsulling.InsertStudentCollegePrefrance(userId, UcCollegePrefrance.StudentCollegePrefrance3, courseId);
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertUpdateExamApp in StudentCounselling.axpx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(i);
}
// Method to Insert update The student Acedmic Info
protected int InsertUpdateAcademicInfo(int userId)
{
_ObjConsulling = new Consulling();
int i = 0;
try
{
StudentHighSchoolInfo objStudentHighSchoolInfo = new
StudentHighSchoolInfo
{
SchoolBoard = StudentAcademicInfo.HighSchoolInfo.SchoolBoard,
SchoolCGPA = StudentAcademicInfo.HighSchoolInfo.SchoolCGPA,
SchoolName = StudentAcademicInfo.HighSchoolInfo.SchoolName,
SchoolYOP = StudentAcademicInfo.HighSchoolInfo.SchoolYOP
};
StudentIntermidateInfo objStudentIntermidateInfo = new
StudentIntermidateInfo
{
CollegeBoard = StudentAcademicInfo.IntermediateInfo.CollegeBoard,
CollegeCGPA = StudentAcademicInfo.IntermediateInfo.CollegeCGPA,
CollegeCourseCombination = StudentAcademicInfo.IntermediateInfo.CollegeCourseCombination,
CollegeCourseCombinationPer = StudentAcademicInfo.IntermediateInfo.CollegeCourseCombinationPer,
CollegeName = StudentAcademicInfo.IntermediateInfo.CollegeName,
CollegePer = StudentAcademicInfo.IntermediateInfo.CollegePer,
CollegeYOP = StudentAcademicInfo.IntermediateInfo.CollegeYOP
};
StudentDicInfo objStudentDicInfo = new
StudentDicInfo
{
DicCGPA = StudentAcademicInfo.DiplomaInfo.DicCGPA,
DicCollegeName = StudentAcademicInfo.DiplomaInfo.DicCollegeName,
DicCourseName = StudentAcademicInfo.DiplomaInfo.DicCourseName,
DicPer = StudentAcademicInfo.DiplomaInfo.DicPer,
DicYOP = StudentAcademicInfo.DiplomaInfo.DicYOP
};
StudentGrdInfo objStudentGrdInfo = new
StudentGrdInfo
{
GrdCGPA = StudentAcademicInfo.GraduateInfo.GrdCGPA,
GrdCollegeName = StudentAcademicInfo.GraduateInfo.GrdCollegeName,
GrdPer = StudentAcademicInfo.GraduateInfo.GrdPer,
GrdSpecialization = StudentAcademicInfo.GraduateInfo.GrdSpecialization,
GrdYOP = StudentAcademicInfo.GraduateInfo.GrdYOP
};
i = _ObjConsulling.InsertUpdateAcademicInfo(userId, StudentAcademicInfo.Eligibilty, objStudentHighSchoolInfo, objStudentIntermidateInfo,
objStudentDicInfo, objStudentGrdInfo);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertUpdateAcademicInfo in StudentCounselling.axpx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(i);
}
//Method to Bind The Borad
protected void BindBoard()
{
_ObjConsulling = new Consulling();
_dt = new DataTable();
try
{
_dt = _ObjConsulling.GetBoradList();
if (_dt.Rows.Count <= 0)
{
return;
}
ddl10Board.DataSource = _dt;
ddl10Board.DataTextField = "AjBoardFullName";
ddl10Board.DataValueField = "AjBoardId";
ddl10Board.DataBind();
ddl10Board.Items.Insert(0, "Select");
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindBoard in UcHighSchoolInfo.axcs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method To Bind User Final Intertested List
private void BindUserIntertestedList(int userId)
{
var objConsulling = new Consulling();
try
{
var ds = objConsulling.GetIntertestedCollege(userId);
if (ds.Tables[0].Rows.Count <= 0)
{
return;
}
rptCollegeDetails.DataSource = ds.Tables[0];
rptCollegeDetails.DataBind();
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex;
}
const string addInfo = "Error while executing BindUserIntertestedList in UcUserFinalList.ascx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected int InsertUserBasicInfo()
{
string ErrMsg = "";
int UserId = 0;
_objSecurePage = new SecurePage();
_ObjUserRegistrationProperty = new UserRegistrationProperty();
try
{
_ObjUserRegistrationProperty = new
UserRegistrationProperty {
UserFullName = studentPerInfo.StudentName,
UserGender = studentPerInfo.StudentGender,
UserEmailid = studentPerInfo.StudentEmaiLid,
MobileNo = studentPerInfo.StudentMobileNo,
PhoneNo = studentPerInfo.StudentAlternameNo,
CourseId = StudentCourseInfo.StudentCourse,
UserCategoryId = Convert.ToInt16(Usertype.Student),
UserDOB = Convert.ToDateTime(studentPerInfo.StudentDOB),
UserFatherName = studentPerInfo.FatherName,
UserStatus = true,
UserPassword = studentPerInfo.StudentMobileNo
};
int i = UserManagerProvider.Instance.InsertUserInfo(_ObjUserRegistrationProperty, 1, out ErrMsg);
UserId = _ObjUserRegistrationProperty.UserId;
if (i <= 0)
{
_ObjUserRegistrationProperty.UserId = UserId;
i = UserManagerProvider.Instance.UpdateUserInfo(_ObjUserRegistrationProperty, 1, out ErrMsg);
}
if (i > 0)
{
_objSecurePage = new SecurePage();
_objSecurePage.LoggedInUserEmailId = studentPerInfo.StudentEmaiLid;
_objSecurePage.LoggedInUserId = UserId;
_objSecurePage.LoggedInUserMobile = studentPerInfo.StudentMobileNo;
_objSecurePage.LoggedInUserName = studentPerInfo.StudentName;
_objSecurePage.LoggedInUserType = Convert.ToInt16(Usertype.Student);
}
_ObjConsulling = new Consulling();
_ObjCommon = new Common();
string formNumber = "ADMJ" + System.DateTime.Now.Year + _ObjCommon.CourseId.ToString() + _objSecurePage.LoggedInUserId.ToString();
i = _ObjConsulling.InsertUpdateUserTransctionalDetails(_objSecurePage.LoggedInUserId, formNumber);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing InsertUserBasicInfo in StudentCounselling.axpx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(UserId);
}
//common method to get booked college list by id or all....
private List <AdmissionJankari.BO.BookSeat> GetBookedCollege(int?bookSeatId)
{
var objCounsulling = new Consulling();
var objBookSeatList = bookSeatId.HasValue
? objCounsulling.GetBookedCollegeByBookSeatId((int)bookSeatId).ToList()
: objCounsulling.GetBookedCollege().ToList();
return(objBookSeatList.ToList());
}
protected void btnUpdateStatus_Click(object sender, EventArgs e)
{
var objConsulling = new Consulling();
_objCommon = new Common();
try
{
var i = objConsulling.InsertUpdateUserTransctionalDetails(Convert.ToInt32(hdnUserId.Value),
hdnForm.Value, chkPaymentStatus.Checked,
ddlTransaction.SelectedValue,
txtBank.Text,
Convert.ToString(hdnForm.Value +
DateTime.Now.ToString(
"hh:mm:ss")),
txtPayment.Text);
if (i > 0)
{
var objmailTemplete = new MailTemplates();
var mail = new MailMessage
{
From = new MailAddress(ApplicationSettings.Instance.Email),
Subject = "AdmissionJankari: Payment information"
};
var url = Utils.AbsoluteWebRoot + "account/login/";
var body = objmailTemplete.MailBodyForPaymentConformation(url, hdnUserName.Value, hdnForm.Value,
ddlTransaction.SelectedValue,
Convert.ToString(hdnForm.Value +
DateTime.Now
.ToString(
"hh:mm:ss")));
mail.Body = body;
mail.To.Add(hdnEmail.Value);
Utils.SendMailMessageAsync(mail);
lblErorrMsg.CssClass = "info";
lblErorrMsg.Visible = true;
lblErorrMsg.Text = string.Format("Transaction status is successfully updated", "ARG0");
BindUserMasterDetail();
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo =
"Error while executing btnUpdateStatus_Click in OnilneCounsellingMember.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method to Get The Participanet College List
protected void BindCollegeParticipentList()
{
var objConsulling = new Consulling();
var data = objConsulling.GetParticipentCollegeListByCourse(UcStudentPersonelInfo.ConsullingCourseId);
if (data.Count > 0)
{
dtlCollegeList.DataSource = data;
dtlCollegeList.DataBind();
}
}
protected void rbtCourseAdmissionEligibilty_SelectedIndexChanged(object sender, EventArgs e)
{
_ObjConsulling = new Consulling();
_dt = new DataTable();
_dt = _ObjConsulling.GetCourseAdmissionEligibiltyById(Convert.ToInt32(rbtCourseAdmissionEligibilty.SelectedValue));
if (_dt.Rows.Count > 0)
{
HideShowAcademicInfo(Convert.ToString(_dt.Rows[0]["AjCollegeCourseEligibiltyName"]));
objElgigibilty = Convert.ToString(_dt.Rows[0]["AjCollegeCourseEligibiltyName"]);
}
}
private void PagerPageIndexChanged(object sender, EventArgs e)
{
var objCounsulling = new Consulling();
lblResult.Visible = false;
try
{
var objBookSeatList = objCounsulling.GetBookedCollege().ToList();
if (objBookSeatList.Count > 0)
{
if (ddlCourseSearch.SelectedIndex > 0)
{
objBookSeatList =
objBookSeatList.Where(
x =>
x.CourseMaster.CourseId == Convert.ToInt32(ddlCourseSearch.SelectedValue))
.ToList();
}
if (objBookSeatList.Count > 0)
{
rptBookSeat.Visible = true;
ucCollegeList.BindDataWithPaging(rptBookSeat, Common.ConvertToDataTable(objBookSeatList));
}
else
{
lblResult.Visible = true;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
else
{
lblResult.Visible = true;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error in Executing Pager_PageIndexChanged in CollegeList.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method to Bind Payment Amount
private void BindPaymentAmount(int courseId)
{
_objConsulling = new Consulling();
var objSecurePage = new SecurePage();
try
{
if (objSecurePage.IsLoggedInUSer)
{
var data = _objConsulling.GetPaymentTransactionStatus(objSecurePage.LoggedInUserId);
if (data != null && data.Count > 0)
{
var data1 = data.FirstOrDefault();
if (data1 != null)
{
lblCheque.Text = data1.PaymentAmount;
lblDemand.Text = data1.PaymentAmount;
lblCash.Text = data1.PaymentAmount;
}
}
else
{
lblCheque.Text = _objConsulling.GetPayemntAmountAccordingToCourse(courseId);
lblDemand.Text = lblCheque.Text;
lblCash.Text = lblCheque.Text;
}
}
else
{
lblCheque.Text = _objConsulling.GetPayemntAmountAccordingToCourse(courseId);
lblDemand.Text = lblCheque.Text;
lblCash.Text = lblCheque.Text;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindPaymentAmount in UcStudentPaymentOption.axcs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void CollegeDetailsItemCommand(object source, RepeaterCommandEventArgs e)
{
Consulling ObjConsulling = new Consulling();
if (e.CommandName == "delete")
{
string errMsg = "";
int i = ObjConsulling.DeleteIntertestedCollege(Convert.ToInt32(e.CommandArgument), out errMsg);
if (i > 0)
{
lblSucess.Visible = true;
lblSucess.Text = errMsg;
lblSucess.Focus();
BindUserIntertestedList(7);
}
}
}
protected void bindRefundRequest(bool parameter = true)
{
lblMsg.Visible = false;
try
{
DataTable data = new Consulling().GetAllRefundRequest();
var newData = data.AsEnumerable();
if (!string.IsNullOrEmpty(hdnCourseId.Value.Trim().ToString()) && hdnCourseId.Value != "0")
{
newData = newData.Where(result => result.Field <Int32>("AjCourseId") == Convert.ToInt32(hdnCourseId.Value));
}
if (!string.IsNullOrEmpty(hdnEmailId.Value.Trim().ToString()))
{
newData = newData.Where(result => result.Field <string>("AjUserEmail") == hdnEmailId.Value.Trim().ToString());
}
if (!string.IsNullOrEmpty(hdnFormNo.Value.Trim().ToString()))
{
newData = newData.Where(result => result.Field <string>("AjStudentFormNumber").StartsWith(hdnFormNo.Value.Trim().ToString(), StringComparison.OrdinalIgnoreCase));
}
if (newData.Count() > 0)
{
UcCustomPaging.BindDataWithPaging(rptRefundRequest, newData.CopyToDataTable(), parameter);
rptRefundRequest.Visible = true;
}
else
{
rptRefundRequest.Visible = false;
lblMsg.CssClass = "error";
lblMsg.Text = "No Records Found.";
lblMsg.Visible = true;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error in Executing bindRefundRequest in RequestforRefund.aspx.cs :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void ddlCourseSearch_SelectedIndexChanged(object sender, EventArgs e)
{
lblResult.Visible = false;
var objCounsulling = new Consulling();
var objBookSeatList = objCounsulling.GetBookedCollege().ToList();
if (ddlCourseSearch.SelectedIndex > 0)
{
objBookSeatList =
objBookSeatList.Where(
x =>
x.CourseMaster.CourseId == Convert.ToInt32(ddlCourseSearch.SelectedValue))
.ToList();
if (objBookSeatList.Count > 0)
{
ucCollegeList.Visible = true;
rptBookSeat.Visible = true;
ucCollegeList.BindDataWithPaging(rptBookSeat, Common.ConvertToDataTable(objBookSeatList));
}
else
{
lblResult.Visible = true;
ucCollegeList.Visible = false;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
else
{
if (objBookSeatList.Count > 0)
{
rptBookSeat.Visible = true;
rptBookSeat.DataSource = objBookSeatList;
rptBookSeat.DataBind();
}
else
{
lblResult.Visible = true;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
}
protected void BtnSearchClick(object sender, EventArgs e)
{
lblResult.Visible = false;
var objCounsulling = new Consulling();
var objBookSeatList = objCounsulling.GetBookedCollege().ToList();
if (!string.IsNullOrEmpty(txtCollegeSearch.Text))
{
objBookSeatList =
objBookSeatList.Where(
x =>
x.CollegeBasicInfo.CollegeBranchName.Trim().ToLower() == txtCollegeSearch.Text.Trim().ToLower())
.ToList();
if (objBookSeatList.Count > 0)
{
ucCollegeList.Visible = true;
rptBookSeat.Visible = true;
ucCollegeList.BindDataWithPaging(rptBookSeat, Common.ConvertToDataTable(objBookSeatList));
}
else
{
lblResult.Visible = true;
ucCollegeList.Visible = false;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
else
{
if (objBookSeatList.Count > 0)
{
rptBookSeat.Visible = true;
rptBookSeat.DataSource = objBookSeatList;
rptBookSeat.DataBind();
}
else
{
lblResult.Visible = true;
lblResult.CssClass = "info";
lblResult.Text = "Sorry,No college found";
rptBookSeat.Visible = false;
}
}
}
// Method To Bind User Final Intertested List
protected void BindUserIntertestedList(int userId)
{
Consulling ObjConsulling = new Consulling();
DataSet ds = new DataSet();
try
{
ds = ObjConsulling.GetIntertestedCollege(userId);
if (ds.Tables[0].Rows.Count > 0)
{
hndCollegeList.Value = ds.Tables[0].Rows.Count.ToString();
rptCollegeDetails.DataSource = ds.Tables[0];
rptCollegeDetails.DataBind();
}
}
catch (Exception ex)
{
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
var objMailTemplates = new MailTemplates();
var collegeName = "";
var objConsulling = new Consulling();
try
{
var ds = objConsulling.GetIntertestedCollege(ObjSecure.LoggedInUserId);
if (ds != null && ds.Tables.Count > 0)
{
for (var i = 0; i < ds.Tables[0].Rows.Count; i++)
{
collegeName += "<div><strong>" + (i + 1) + ". " + ds.Tables[0].Rows[i]["AjCollegeBranchName"] +
"</strong></div><br/>";
}
var mail = new MailMessage
{
From = new MailAddress(ApplicationSettings.Instance.Email),
Subject = "AdmissionJankari:Counselling Information"
};
var body = objMailTemplates.MailBodyForCOunsellingQuery(new SecurePage().LoggedInUserName,
collegeName.TrimEnd(','));
mail.Body = body;
mail.To.Add(new SecurePage().LoggedInUserEmailId);
Utils.SendMailMessageAsync(mail);
Response.Redirect(Utils.ApplicationRelativeWebRoot + "counselling/Payment.aspx");
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex;
}
const string addInfo = "Error while executing btnConfirm_Click in UcUserFinalList.ascx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method to Bind the Participating College..
protected void BindParticipatedCollege()
{
_objConsulling = new Consulling();
try
{
var datalist = GetCollegeListByQuery().ToList();
BindCollege(datalist);
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindParticipatingCollege in UcParticipatedCollegeList.ascx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
//....method to get participated college.....
private IEnumerable <BookSeat> GetCollegeListByQuery()
{
_objConsulling = new Consulling();
var objCollegeBranchProperty = new List <BookSeat>();
try
{
objCollegeBranchProperty =
_objConsulling.GetBookedCollege().Where(result => result.CourseMaster.CourseId == _objCommon.CourseId &&
((!string.IsNullOrEmpty(result.BookSeatStartDate) ? DateTime.Parse(result.BookSeatStartDate) : DateTime.Now) >= DateTime.Now || (!string.IsNullOrEmpty(result.BookSeatEndDate) ? DateTime.Parse(result.BookSeatEndDate) : DateTime.Now) >= DateTime.Now) && result.BookSeatStatus == true).ToList();
if (ddlState.SelectedIndex > 0)
{
objCollegeBranchProperty = _objConsulling.GetBookedCollege().Where(result => result.CityMaster.StateId == Convert.ToInt32(ddlState.SelectedValue) &&
((!string.IsNullOrEmpty(result.BookSeatStartDate) ? DateTime.Parse(result.BookSeatStartDate) : DateTime.Now) >= DateTime.Now || (!string.IsNullOrEmpty(result.BookSeatEndDate) ? DateTime.Parse(result.BookSeatEndDate) : DateTime.Now) >= DateTime.Now) && result.BookSeatStatus == true).ToList();
}
if (ddlCity.SelectedIndex > 0)
{
objCollegeBranchProperty = _objConsulling.GetBookedCollege().Where(result => result.CityMaster.CityId == Convert.ToInt32(ddlCity.SelectedValue) &&
((!string.IsNullOrEmpty(result.BookSeatStartDate) ? DateTime.Parse(result.BookSeatStartDate) : DateTime.Now) >= DateTime.Now || (!string.IsNullOrEmpty(result.BookSeatEndDate) ? DateTime.Parse(result.BookSeatEndDate) : DateTime.Now) >= DateTime.Now) && result.BookSeatStatus == true).ToList();
}
if (objCollegeBranchProperty.Count <= 0)
{
objCollegeBranchProperty =
_objConsulling.GetBookedCollege().Where(result => result.CourseMaster.CourseId == _objCommon.CourseId &&
((!string.IsNullOrEmpty(result.BookSeatStartDate) ? DateTime.Parse(result.BookSeatStartDate) : DateTime.Now) >= DateTime.Now || (!string.IsNullOrEmpty(result.BookSeatEndDate) ? DateTime.Parse(result.BookSeatEndDate) : DateTime.Now) >= DateTime.Now) && result.BookSeatStatus == true).ToList();
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindParticipatingCollege in UcParticipatedCollegeList.ascx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
return(objCollegeBranchProperty);
}
private void CheckPaymentStatus(int userId)
{
var objConsulling = new Consulling();
try
{
var data = objConsulling.GetPaymentTransactionStatus(userId);
if (data.Count > 0)
{
var result = data.First();
if (result.StudentPaymentStatus == true)
{
sucess.Visible = true;
failure.Visible = false;
}
else
{
sucess.Visible = false;
failure.Visible = true;
}
}
else
{
sucess.Visible = false;
failure.Visible = true;
}
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.InnerException.Message;
}
const string addInfo = "Error While fetching CheckPaymentStatus in Confirmation.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
// Method to Bind Payment Amount
private void BindPaymentAmount(int courseId)
{
_objConsulling = new Consulling();
try
{
lblCheque.Text = _objConsulling.GetPayemntAmountAccordingToCourse(courseId);
lblDemand.Text = lblCheque.Text;
lblCash.Text = lblCheque.Text;
}
catch (Exception ex)
{
var err = ex.Message;
if (ex.InnerException != null)
{
err = err + " :: Inner Exception :- " + ex.ToString();
}
const string addInfo = "Error while executing BindPaymentAmount in PaymentOption.aspx :: -> ";
var objPub = new ClsExceptionPublisher();
objPub.Publish(err, addInfo);
}
}
protected void rptFactor_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Select")
{
var packageId = Convert.ToInt32(e.CommandArgument);
var packageDetails = FactorProvider.Instance.GetPackageById(packageId);
if (packageDetails != null && packageDetails.Count > 0)
{
var data = packageDetails.FirstOrDefault();
if (data != null)
{
SecurePage objSecurePage = new SecurePage();
var userid = objSecurePage.LoggedInUserId;
Consulling objConsulling = new Consulling();
int i = objConsulling.InsertUpdateUserTransctionalDetails(objSecurePage.LoggedInUserId, "", false, "", "", " ", Convert.ToString(data.PackageAmount), packageId);
if (data.PackageAmount > 0)
{
Page.ClientScript.RegisterStartupScript(Type.GetType("System.String"), "addScriptdg",
"OpenPoup('divUniversityCategoryInsert','650px','sndAddCollegePresedentSpeechsdasd')", true);
}
}
}
}
}
