public HtmlSelect FetchCollegeWiseConfirmedFacultyListNew(string UniID, string InstID, string ddlFacDescID)
{
InstituteRepository oInstituteRepository = new InstituteRepository();
HtmlSelect htmlSel = new HtmlSelect();
DataTable listFaculty = oInstituteRepository.AssignedConfirmedFaculties(UniID, InstID.Split('|')[0]);
try
{
if (listFaculty != null)
{
htmlSel.ID = ddlFacDescID;
htmlSel.Attributes.Add("class", "selectbox");
htmlSel.Attributes.Add("onchange", "setValue(hid_Fac_id,this.value);FillCourse(this.value);ClearDropDowns(1,5)");
htmlSel.DataSource = listFaculty;
htmlSel.DataTextField = "Fac_Desc";
htmlSel.DataValueField = "pk_Fac_ID";
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(htmlSel);
}
public HtmlSelect FetchCoursePartWiseCoursePartChildList(string UniID, string InstID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrDetails_ID, string HtmlSelCrBrnID)
{
InstituteRepository oInstituteRepository = new InstituteRepository();
DataTable dt = oInstituteRepository.AssignCoursePartTerm(UniID, InstID, FacID, CrID, MoLrnID, PtrnID, BrnID, CrPrDetails_ID);
HtmlSelect htmlSel = new HtmlSelect();
htmlSel.ID = HtmlSelCrBrnID;
htmlSel.Attributes.Add("class", "selectbox");
// htmlSel.Attributes.Add("onchange", "FetchCourseMoLrnPtrnBrnWiseCoursePartList('tdCrPrDesc', hidUniID.value, hidFacID.value, hidCrID.value, hidMoLrnID.value, hidPtrnID.value, hidBrnID.value, 'ddlCrPrDesc'); ");//ClearDropDowns(5," + levelflag + ");");
//htmlSel.Attributes.Add("onchange", "setValue('hidCrPrID',this.value);");
htmlSel.Attributes.Add("onchange", "setCrPartTerm(this.value);");
//hCrPart.Attributes.Add("onchange", "setCrPart(this.value);");
htmlSel.DataSource = dt;
htmlSel.DataTextField = "text";
htmlSel.DataValueField = "value";
htmlSel.Style.Add("width", "230px");
htmlSel.DataBind();
ListItem li = new ListItem("--- Select ---", "-1");
htmlSel.Items.Insert(0, li);
return(htmlSel);
}
public JsonResult SelectApproveReject(string studentid = "", string choiceid = "")
{
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.Addmiited_Student_List("", "SelectApproveSeat", "", "", studentid, "", Session["InstituteID"].ToString(), "", "", "", "", "");
string SeatApprove = "", SeatApproveReason = "", IsRequireSkypeInterview = "", IsSkypeInterviewComplete = "", IsStudentAcceptSeat = ""; /*SkypeInterviewRemarks = "",*/
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
SeatApprove = _dr["SeatApprove"].ToString();
SeatApproveReason = _dr["SeatApproveReason"].ToString();
IsRequireSkypeInterview = _dr["IsRequireSkypeInterview"].ToString();
IsSkypeInterviewComplete = _dr["IsSkypeInterviewComplete"].ToString();
IsStudentAcceptSeat = _dr["IsStudentAcceptSeat"].ToString();
//SkypeInterviewRemarks = _dr["SkypeInterviewRemarks"].ToString();
}
}
}
return(Json(new
{
SeatApprove = SeatApprove,
SeatApproveReason = SeatApproveReason,
IsRequireSkypeInterview = IsRequireSkypeInterview,
IsSkypeInterviewComplete = IsSkypeInterviewComplete,
IsStudentAcceptSeat = IsStudentAcceptSeat
// SkypeInterviewRemarks = SkypeInterviewRemarks
},
JsonRequestBehavior.AllowGet
));
}
public ActionResult Index(string u = "")
{
ViewBag.InstituteAvailable = "No";
try
{
string InstituteID = StringCipher.Decrypt(u);
InstituteRepository _objRepository = new InstituteRepository();
DataSet _dsInstituteListForGeneration = _objRepository.Select_Institute_By_InstituteID(InstituteID);
if (_dsInstituteListForGeneration != null)
{
if (_dsInstituteListForGeneration.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _dsInstituteListForGeneration.Tables[0].Rows)
{
ViewBag.ID = _dr["ID"].ToString();
ViewBag.InstituteID = _dr["InstituteID"].ToString();
ViewBag.InstituteName = _dr["InstituteName"].ToString();
ViewBag.InstituteAvailable = "Yes";
}
}
}
}
catch (Exception)
{
ViewBag.InstituteAvailable = "No";
}
return(View());
}
public ActionResult ViewNicheDetails(string instituteid = "", string For = "", string Category = null, string NicheCourseId = null)
{
if (instituteid == "")
{
TempData["instituteid"] = "";
}
else
{
TempData["instituteid"] = instituteid;
}
if (NicheCourseId == "")
{
TempData["NicheCourseId"] = "";
}
else
{
TempData["NicheCourseId"] = NicheCourseId;
}
TempData.Keep("NicheCourseId");
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.Select_Institute_By_InstituteID(instituteid);
string InstituteName = "[Institute Name]";
string TotalCourses = "0";
string TotalSeats = "0";
string IsNICHECourse = "0";
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
DataRow _dr = _ds.Tables[0].Rows[0];
InstituteName = _dr["InstituteName"].ToString() + ", " + _dr["City"].ToString().Trim();
IsNICHECourse = _dr["IsNicheAllowed"].ToString().Trim();
}
if (_ds.Tables[1].Rows.Count > 0)
{
DataRow _dr = _ds.Tables[1].Rows[0];
TotalCourses = _dr["TotalCourses"].ToString();
TotalSeats = _dr["TotalSeats"].ToString();
}
}
ViewBag.InstituteName = InstituteName;
TempData["TotalCourses"] = TotalCourses;
TempData["TotalSeats"] = TotalSeats;
TempData["IsNICHECourse"] = IsNICHECourse;
TempData.Keep("instituteid");
ViewBag.DetailsFor = For;
if (Category == "")
{
TempData["Category"] = "";
}
else
{
TempData["Category"] = Category;
}
return(View());
}
public JsonResult Select_Institute_Details()
{
List <InstituteMaster> _list = new List <InstituteMaster>();
InstituteRepository _objRepository = new InstituteRepository();
//using (IInstituteMaster _objRepository = new RInstituteMaster())
//{
DataSet ds = _objRepository.Search_Institute_By_Id(Session["InstituteID"].ToString());
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
InstituteMaster _objList = new InstituteMaster();
_objList.ID = row["ID"].ToString();
_objList.InstituteID = row["InstituteID"].ToString();
_objList.InstituteName = row["InstituteName"].ToString();
_objList.Email = row["Email"].ToString();
_objList.Address = row["Address"].ToString();
_objList.State = row["State"].ToString();
_objList.City = row["City"].ToString();
_objList.Pin = row["Pin"].ToString();
_objList.YOE = row["YOE"].ToString();
_objList.Description = row["Description"].ToString();
//_objList.History = row["History"].ToString();
//_objList.Awards = row["Awards"].ToString();
//_objList.Fellows = row["Fellows"].ToString();
//_objList.News = row["News"].ToString();
//_objList.Area = row["Area"].ToString();
//_objList.ProgramOffered = row["ProgramOffered"].ToString();
_objList.IsSubmited = row["IsSubmited"].ToString();
_objList.Description = row["Description"].ToString();
_objList.AcademicCourses = row["AcademicCourses"].ToString();
_objList.AreaOfExcellence = row["AreaOfExcellence"].ToString();
_objList.ResearchCapability = row["ResearchCapability"].ToString();
// _objList.FacultyOverview = row["FacultyOverview"].ToString();
_objList.NotableResearchPublication = row["NotableResearchPublication"].ToString();
_objList.NIRFRanking = row["NIRFRanking"].ToString();
_objList.NBANAACAccreditation = row["NBANAACAccreditation"].ToString();
_objList.instituteweburl = row["instituteweburl"].ToString();
_list.Add(_objList);
}
}
// }
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
// GET: Institute/LandingPage
public ActionResult Index(string InstituteID = "", string User_id = "0")
{
InstituteRepository _objRepository = new InstituteRepository();
InstituteMaster _obj = new InstituteMaster();
_obj.InstituteID = InstituteID;
DataSet ds = _objRepository.Login_Institute(_obj);
if (ds != null)
{
Session["IsChangePwd"] = null;
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
Session["InstituteID"] = dr["InstituteID"].ToString();
Session["InstituteName"] = dr["InstituteName"].ToString();
Session["Email"] = dr["Email"].ToString();
Session["User_id"] = User_id;
Session["IsAdminFLag"] = "True";
Session["IsAdminEdit"] = "True";
Session["IsNicheAllowed"] = dr["IsNicheAllowed"].ToString();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
Session["localIP"] = localIP;
Session["InstituteType"] = dr["InstituteType"].ToString();
Session["ParticipatedYear"] = ConfigurationManager.AppSettings["ParticipatedYear"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in ds.Tables[1].Rows)
{
Session["AR_StartDate"] = _dr["MinDate"].ToString();
Session["AR_EndDate"] = _dr["MaxDate"].ToString();
}
}
if (ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow _dr in ds.Tables[2].Rows)
{
Session["ParticipatedYear"] = _dr["ParticipatedYear"].ToString();
}
}
else
{
Session["ParticipatedYear"] = "";
}
}
//return RedirectToAction("Index", "Dashboard", new { area = "Institute" });
return(Redirect("~/Institute/ParticipationYears"));
}
// GET: Institute/Dashboard
public ActionResult Index()
{
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.Get_Dashboard_Data(Session["InstituteID"].ToString(), ConfigurationManager.AppSettings["ParticipatedYear"].ToString());
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
ViewBag.InstituteProfile = _dr["InstituteProfile"].ToString();
ViewBag.Courses = _dr["Courses"].ToString();
ViewBag.NicheCourses = _dr["NicheCourses"].ToString();
ViewBag.Campus = _dr["Campus"].ToString();
ViewBag.CostOfLiving = _dr["CostOfLiving"].ToString();
ViewBag.InternationalStudents = _dr["InternationalStudents"].ToString();
ViewBag.FacultyAlumni = _dr["FacultyAlumni"].ToString();
ViewBag.HowToReach = _dr["HowToReach"].ToString();
ViewBag.Gallery = _dr["Gallery"].ToString();
}
}
if (_ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[1].Rows)
{
ViewBag.HeadName = _dr["HeadPrefix"].ToString() + " " + _dr["HeadFirstName"].ToString() + " " + _dr["HeadLastName"].ToString() + " (" + _dr["HeadDesignation"].ToString() + ")";
ViewBag.HeadEmail = _dr["HeadEmail"].ToString();
ViewBag.HeadMobile = _dr["HeadMobile"].ToString();
ViewBag.HeadPhone = _dr["HeadPhone"].ToString();
ViewBag.NodalName = _dr["NodalPrefix"].ToString() + " " + _dr["NodalFirstName"].ToString() + " " + _dr["NodalLastName"].ToString() + " (" + _dr["NodalDesignation"].ToString() + ")";
ViewBag.NodalEmail = _dr["NodalEmail"].ToString();
ViewBag.NodalMobile = _dr["NodalMobile"].ToString();
ViewBag.NodalPhone = _dr["NodalPhone"].ToString();
}
}
}
//ViewBag.InstituteProfile = "100";
//ViewBag.Courses = "10";
//ViewBag.Campus = "35";
//ViewBag.CostOfLiving = "33";
//ViewBag.InternationalStudents = "65";
//ViewBag.FacultyAlumni = "70";
//ViewBag.HowToReach = "19";
//ViewBag.Gallery = "80";
return(View());
}
public HtmlSelect FillAssignedCourses(string Uni_ID, string InstId, string FacultyID, string CourseNm)
{
DataTable dtCr = new DataTable();
dtCr = InstituteRepository.InstituteWiseAllAssignedCourse(Uni_ID, InstId, FacultyID);
HtmlSelect hCourseNm = new HtmlSelect();
hCourseNm.ID = CourseNm;
hCourseNm.Attributes.Add("class", "selectbox");
hCourseNm.Attributes.Add("onchange", "FillCrPrDD(this.value);");
clsCommon common = new clsCommon();
common.fillDropDown(hCourseNm, dtCr, "", "Text", "value", "---- Select ----");
dtCr.Dispose();
return(hCourseNm);
}
public ActionResult SkypeInterview(string id = "", string u = "")
{
if (Convert.ToDateTime(Session["AR_StartDate"].ToString()) <= DateTime.Now && Convert.ToDateTime(Session["AR_EndDate"].ToString()) >= DateTime.Now)
{
}
else
{
return(RedirectToAction("Index", "Dashboard", new { Area = "Institute" }));
}
TempData.Keep("ProgrammeLevel");
//Session["InstituteID"] = "SII-I-0207";
try
{
ViewBag.id = id;
ViewBag.U = StringCipher.Decrypt(u);
InstituteRepository _objRepo = new InstituteRepository();
DataSet _ds = _objRepo.SKYPE_INTERVIEW_PHASE2_ALLOTED_STUDENTS_SELECT(ViewBag.U);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
DataRow _dr = _ds.Tables[0].Rows[0];
if (_dr["SkypeInterviewStatus"] != null)
{
if (_dr["SkypeInterviewStatus"].ToString() != "")
{
ViewBag.SkypeInterviewStatus = _dr["SkypeInterviewStatus"].ToString();
}
}
if (_dr["SkypeInterviewDate"] != null)
{
if (_dr["SkypeInterviewDate"].ToString() != "")
{
ViewBag.SkypeInterviewDate = Convert.ToDateTime(_dr["SkypeInterviewDate"].ToString()).ToString("dd-MM-yyyy");
}
}
}
}
}
catch (Exception)
{
throw;
//return RedirectToAction("StudentsList", "AdmittedStudent", new { Area = "Institute" });
}
return(View());
}
public HtmlSelect FillCoursePart(string UniID, string InstID, string CrMoLrnPtrnID, string CrPart)
{
DataTable dtCp = new DataTable();
//dtCp = CourseRepository.coursewiseCourseParts(CrMoLrnPtrnID);
dtCp = InstituteRepository.Get_AllCoursePartOnly(UniID, InstID, CrMoLrnPtrnID);
HtmlSelect hCrPart = new HtmlSelect();
hCrPart.ID = CrPart;
hCrPart.Attributes.Add("class", "selectbox");
hCrPart.Attributes.Add("onchange", "setCrPart(this.value);");
clsCommon common = new clsCommon();
common.fillDropDown(hCrPart, dtCp, "", "Text", "value", "---- Select ----");
dtCp.Dispose();
return(hCrPart);
}
// GET: Admin/PreviewInstitute
public ActionResult Index(string instituteid = "", string Name = "")
{
TempData["InstituteID"] = instituteid;
TempData["InstituteName"] = Name;
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.Get_Dashboard_Data(instituteid);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
ViewBag.InstituteProfile = _dr["InstituteProfile"].ToString();
ViewBag.Courses = _dr["Courses"].ToString();
ViewBag.NicheCourses = _dr["NicheCourses"].ToString();
ViewBag.Campus = _dr["Campus"].ToString();
ViewBag.CostOfLiving = _dr["CostOfLiving"].ToString();
ViewBag.InternationalStudents = _dr["InternationalStudents"].ToString();
ViewBag.FacultyAlumni = _dr["FacultyAlumni"].ToString();
ViewBag.HowToReach = _dr["HowToReach"].ToString();
ViewBag.Gallery = _dr["Gallery"].ToString();
}
}
if (_ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[1].Rows)
{
ViewBag.HeadName = _dr["HeadPrefix"].ToString() + " " + _dr["HeadFirstName"].ToString() + " " + _dr["HeadLastName"].ToString() + " (" + _dr["HeadDesignation"].ToString() + ")";
ViewBag.HeadEmail = _dr["HeadEmail"].ToString();
ViewBag.HeadMobile = _dr["HeadMobile"].ToString();
ViewBag.HeadPhone = _dr["HeadPhone"].ToString();
ViewBag.NodalName = _dr["NodalPrefix"].ToString() + " " + _dr["NodalFirstName"].ToString() + " " + _dr["NodalLastName"].ToString() + " (" + _dr["NodalDesignation"].ToString() + ")";
ViewBag.NodalEmail = _dr["NodalEmail"].ToString();
ViewBag.NodalMobile = _dr["NodalMobile"].ToString();
ViewBag.NodalPhone = _dr["NodalPhone"].ToString();
}
}
}
TempData.Keep("InstituteID");
TempData.Keep("InstituteName");
return(View());
}
public JsonResult UpdateApproveReject(string studentid = "", string choiceid = "", string SeatApprove = "", string SeatApproveReason = "", string IsRequireSkypeInterview = "", string SkypeInterviewRemarks = "", string IsSkypeInterviewComplete = "", string IsStudentAcceptSeat = "")
{
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.Addmiited_Student_List("", "ApproveSeat", "", "", studentid, "", Session["InstituteID"].ToString(), choiceid, SeatApprove, SeatApproveReason, IsRequireSkypeInterview, SkypeInterviewRemarks, IsSkypeInterviewComplete, IsStudentAcceptSeat);
bool flag = false;
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
flag = true;
}
}
return(Json(new
{
Flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult FillDowndowns(string Type = "", string Discipline_ID = "0", string ProgramLevel_Id = "0", string Qualification_ID = "0")
{
string Code = string.Empty, Message = string.Empty;
List <InstituteSearchDropdowns> _list = new List <InstituteSearchDropdowns>();
try
{
InstituteRepository _objRepo = new InstituteRepository();
DataSet _ds = _objRepo.SELECT_INSTITUTE_SEARCH_DROPDOWNS(Type, Discipline_ID, ProgramLevel_Id, Qualification_ID);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
}
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
return(Json(new
{
List = _list,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
#pragma warning disable SCS0016 // Controller method is vulnerable to CSRF
public JsonResult ParticipateInCurrentYear()
#pragma warning restore SCS0016 // Controller method is vulnerable to CSRF
{
string Code = string.Empty, Message = string.Empty, Error = string.Empty;
try
{
Session["localIP"] = "";
InstituteRepository _objRepository = new InstituteRepository();
DataSet _ds = _objRepository.SP_PARTICIPATE_INSTITUTE(Session["InstituteID"].ToString(), Session["localIP"].ToString(), ConfigurationManager.AppSettings["ParticipatedYear"].ToString());
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Session["ParticipatedYear"] = ConfigurationManager.AppSettings["ParticipatedYear"].ToString();
Message = "Successfully participated in " + ConfigurationManager.AppSettings["ParticipatedYear"].ToString() + "!";
Code = "success";
}
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
c = Code,
m = Message,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SaveSkypeInterview(string id = "", string SkypeInterviewStatus = "", string SkypeInterviewDate = "")
{
string Code = string.Empty, Message = string.Empty, Error = string.Empty;
try
{
InstituteRepository _objRepo = new InstituteRepository();
DataSet _ds = _objRepo.SKYPE_INTERVIEW_PHASE2_ALLOTED_STUDENTS(id, Session["InstituteID"].ToString(), SkypeInterviewStatus, SkypeInterviewDate);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Message = "Interview scheduled!";
Code = "success";
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.!";
Code = "servererror";
}
}
}
catch (NullReferenceException)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
}
catch (Exception)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
}
return(Json(new
{
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult Save_Institute_Details(InstituteMaster _obj)
{
bool flag = false;
bool flagExists = false;
try
{
InstituteRepository _objRepository = new InstituteRepository();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.ModifiedIP = localIP;
_obj.Edited_by = Session["User_id"].ToString();
DataSet _ds = _objRepository.Update_Institute_Details(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "-1")
{
flagExists = true;
}
else if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "1")
{
flag = true;
}
}
}
}
catch (System.Exception)
{
throw;
}
return(Json(new
{
flag = flag,
flagExists = flagExists
},
JsonRequestBehavior.AllowGet
));
}
public HtmlSelect FillTaluka(string DistrictID, string Taluka, int i)
{
DataTable dt = new DataTable();
dt = InstituteRepository.displayTalukaWithinDistrict(DistrictID, "E");
HtmlSelect hTaluka = new HtmlSelect();
hTaluka.ID = Taluka;
hTaluka.Attributes.Add("class", "selectbox");
if (i == 0) //for all drop downs except for 'OfficeIncharge' in OtherInformation
{
hTaluka.Attributes.Add("onblur", "setTaluka(this.value);");
}
else //for drop down of 'OfficeIncharge' in OtherInformation
{
hTaluka.Attributes.Add("onblur", "setTalukaSec(this.value);");
}
clsCommon common = new clsCommon();
common.fillDropDown(hTaluka, dt, "", "Text", "Value", "---- Select ----");
dt.Dispose();
return(hTaluka);
}
public HtmlSelect FillDistrict(string StateID, string District, int i)
{
DataTable dt = new DataTable();
dt = InstituteRepository.stateWiseDistricts(StateID, "E");
HtmlSelect hDistrict = new HtmlSelect();
hDistrict.ID = District;
hDistrict.Attributes.Add("class", "selectbox");
if (i == 0) //for all drop downs except for 'OfficeIncharge' in OtherInformation
{
hDistrict.Attributes.Add("onchange", "FillTalukaDD(this.value);");
}
else //for drop down of 'OfficeIncharge' in OtherInformation
{
hDistrict.Attributes.Add("onchange", "FillTalukaDDSec(this.value);");
}
clsCommon common = new clsCommon();
common.fillDropDown(hDistrict, dt, "", "Text", "Value", "---- Select ----");
dt.Dispose();
return(hDistrict);
}
public ActionResult Clicked(string username, string password)
{
Debug.WriteLine("One");
//creating a user record
/*
* var u = new User()
* {
* Name = "Yash",
* UserName = "******",
* Pass = "******",
* Designation = "HOD",
* Proposals = new List<Proposals>()
* {
* new Proposals()
* {
* Index = null,
* Title = null,
* Institute= null,
* Dept= null,
* Course= null,
* Semester= null,
* Sub_type= null,
* Sub_code= null,
* Others_CC_text = null,
* Others_CC_file=null,
* Full_syll= null,
* Abstract= null,
* Objectives= null,
* Outcome= null,
* References= null,
* Incl_sem= null,
* Incl_sub_type= null,
* Others_CR_text=null,
* Others_CR_file=null,
* Present_split= null,
* Proposed_split= null,
* Present_nomenclature = null,
* New_nomenclature = null,
* With_effect_from=null,
* Modification_requested =null,
* Present_eligibility = null,
* Proposed_eligibility = null,
* Others_CS_text = null,
* Others_CS_file = null,
* Proposed_cname= null,
* Adm_capacity= null,
* Proposed_curriculum= null,
* Proposed_distribution = null
* }
* }
* };
*/
//Working COde for insertion
//-----------
//User a = _repositoryUser.InsertPost(u);
//ViewBag.Result = a.ToJson().ToString();
//-----------
//working code
//---------------------
/*
* string res = null;
* List<User> a = _repositoryUser.SelectAll();
* foreach( User s in a)
* {
* if(res == null)
* res = s.ToJson().ToString();
* else
* res = res + s.ToJson().ToString();
* }
* ViewBag.Result = res;
*/
//---------------------
//Working Code for querying
//-----------------
/*
* string res = null;
* List<User> a = _repositoryUser.Filter("{UserName: '******', Pass:'******'}");
* if (a == null)
* ViewBag.Result = "NotFound";
* else
* {
* foreach (User s in a)
* {
* if (res == null)
* res = s.ToJson().ToString();
* else
* res = res + s.ToJson().ToString();
* }
* if (res == null)
* ViewBag.Result = "NotFound";
* else
* ViewBag.Result = res;
* }
* ViewBag.Result = a.ToString();
*
* ViewBag.xyz = a.ToJson().ToString();
*/
//-------------------
string Entered_Uname = username;
string Entered_Pass = password;
Debug.WriteLine("Two");
if (Entered_Uname == null || Entered_Pass == null)
{
//return JavaScript(alert("please enter username and password"));
Debug.WriteLine("Three");
return(Content("<script language = 'javascript' type = 'text/javascript'>alert('please enter username and password'); window.location.href = 'login'</script>"));
}
Debug.WriteLine("Four");
User curr_user = null;
try
{
Debug.WriteLine("Five");
List <User> Hits = _repositoryUser.Filter("{UserName: '******', Pass: '******'}");
if (Hits == null)
{
//ViewBag.Result = "Error!!";
Debug.WriteLine("Error");
return(Content("<script language = 'javascript' type = 'text/javascript'>alert('ERROR!!'); window.location.href = 'login'</script>"));
}
else
{
foreach (User s in Hits)
{
if (s.ToJson().ToString() == null)
{
//ViewBag.Result = "Invalid Login";
Debug.WriteLine("Invalid");
return(Content("<script language = 'javascript' type = 'text/javascript'>alert('ERROR!!'); window.location.href = 'login'</script>"));
}
else
{
ViewBag.Result = "Welcome " + s.Name.ToString();
string UserName = s.UserName.ToString();
TempData["UserName"] = s.UserName;
Session["UserName"] = s.UserName;
Session["Name"] = s.Name;
//Session["Institute"] = s.Institute;
InstituteRepository i = new InstituteRepository();
Session["Institute"] = i.GetInstitute(s.Institute);
Session["Ins_id"] = i.GetIns_Id(s.Institute);
return(RedirectToAction("Index", "Main"));
}
}
}
}
catch (Exception e)
{
string error = e.ToString();
return(Content("<script language = 'javascript' type = 'text/javascript'>alert('" + e + "'); window.location.href = 'login'</script>"));
}
/*
* if (username.Equals("robby") && password.Equals("singh"))
* {
* // ViewBag.Result = "Right";
*
* }
* else
* {
* //ViewBag.Result = "Wrong";
* }*/
return(Content("<script language = 'javascript' type = 'text/javascript'>alert('Wrong Username/Password!!'); window.location.href = 'login'</script>"));
//return View("login");
}
private void SelectDropdowns()
{
string Code = string.Empty, Message = string.Empty;
List <InstituteSearchDropdowns> _listDiscipline = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listProgrammeLevel = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listQualification = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listCourseOfStudy = new List <InstituteSearchDropdowns>();
List <InstituteSearchDropdowns> _listInstituteType = new List <InstituteSearchDropdowns>();
try
{
InstituteRepository _objRepo = new InstituteRepository();
DataSet _ds = _objRepo.SELECT_INSTITUTE_SEARCH_DROPDOWNS("Dropdowns", "", "", "");
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_listDiscipline.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
if (_ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[1].Rows)
{
_listProgrammeLevel.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
if (_ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[2].Rows)
{
_listQualification.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
if (_ds.Tables[3].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[3].Rows)
{
_listCourseOfStudy.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
if (_ds.Tables[4].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[4].Rows)
{
_listInstituteType.Add(new InstituteSearchDropdowns
{
Id = _dr["ID"].ToString(),
Value = _dr["VALUE"].ToString()
});
}
}
}
}
catch (NullReferenceException)
{
throw;
}
catch (Exception)
{
throw;
}
ViewBag.Disciplines = _listDiscipline;
ViewBag.ProgrammeLevel = _listProgrammeLevel;
ViewBag.Qualification = _listQualification;
ViewBag.CourseOfStudy = _listCourseOfStudy;
ViewBag.InstituteType = _listInstituteType;
}
public JsonResult CheckLogin(InstituteMaster _obj)
{
bool flagCaptcha = false;
bool flagLogin = false;
bool flagPasswordChanged = true;
bool flagValidID = false;
try
{
if (this.Session["CaptchaImageText"].ToString() == _obj.Captchastr)
{
flagCaptcha = true;
InstituteRepository _objRepository = new InstituteRepository();
DataSet ds = _objRepository.Login_Institute(_obj);
if (ds != null)
{
Session["IsChangePwd"] = null;
if (ds.Tables[0].Rows.Count > 0)
{
flagValidID = true;
DataRow dr = ds.Tables[0].Rows[0];
string Password = dr["Password"].ToString();
string random = "";
if (dr["DefaultPassword"] != null)
{
random = dr["DefaultPassword"].ToString();
}
if (dr["IsPasswordChanged"].ToString().ToLower() == "true")
{
//nvNHsQGCNC3Ph/TQRX3dbd4BnGKtXFV/Ow==
string PASSWORD = _obj.Password;
string MD5 = Helper.VerifyHash(PASSWORD, "MD5", Password).ToString();
string SHA1 = Helper.VerifyHash(PASSWORD, "SHA1", Password).ToString();
string sha256 = Helper.VerifyHash(PASSWORD, "SHA256", Password).ToString();
string sha384 = Helper.VerifyHash(PASSWORD, "SHA384", Password).ToString();
string sha512 = Helper.VerifyHash(PASSWORD, "SHA512", Password).ToString();
if (MD5 != "True" || SHA1 == "True" || sha256 == "True" || sha384 == "True" || sha512 == "True")
{
TempData["old_password"] = PASSWORD;
flagLogin = true;
}
}
else
{
if (random != "")
{
if (random == _obj.Password)
{
flagLogin = true;
flagPasswordChanged = false;
TempData["old_password"] = random;
}
}
}
if (flagLogin)
{
Session["InstituteID"] = dr["InstituteID"].ToString();
Session["InstituteName"] = dr["InstituteName"].ToString();
Session["Email"] = dr["Email"].ToString();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
Session["localIP"] = localIP;
Session["User_id"] = "0";
Session["IsAdminFLag"] = dr["IsAdminFLag"].ToString();
Session["IsAdminEdit"] = dr["IsAdminEdit"].ToString();
Session["IsNicheAllowed"] = dr["IsNicheAllowed"].ToString();
Session["InstituteType"] = dr["InstituteType"].ToString();
Session["ParticipatedYear"] = ConfigurationManager.AppSettings["ParticipatedYear"].ToString();
flagLogin = true;
}
}
if (flagLogin)
{
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow _dr in ds.Tables[1].Rows)
{
Session["AR_StartDate"] = _dr["MinDate"].ToString();
Session["AR_EndDate"] = _dr["MaxDate"].ToString();
}
}
if (ds.Tables[2].Rows.Count > 0)
{
foreach (DataRow _dr in ds.Tables[2].Rows)
{
Session["ParticipatedYear"] = _dr["ParticipatedYear"].ToString();
}
}
}
}
}
}
catch (Exception)
{
throw;
}
return(Json(new
{
flagCaptcha = flagCaptcha,
flagLogin = flagLogin,
flagPasswordChanged = flagPasswordChanged,
flagValidID = flagValidID
},
JsonRequestBehavior.AllowGet
));
}
public InstituteController()
{
instituteRepository = new InstituteRepository();
admissionCriteriaRepository = new AdmissionCriteriaRepository();
}
public JsonResult Save_Nodal_Head_Details(mNodalHeadOfficers _obj)
{
string flag = "0";
try
{
#region Encript Password
Random rn = new Random();
#pragma warning disable SCS0005 // Weak random generator
int month = rn.Next(1, 6);
#pragma warning restore SCS0005 // Weak random generator
StringBuilder hashPassword = new StringBuilder();
string new_password = _obj.Password;
switch (month)
{
case 1:
hashPassword.Append(Helper.ComputeHash(new_password, "MD5", null));
break;
case 2:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA1", null));
break;
case 3:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA256", null));
break;
case 4:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA384", null));
break;
case 5:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA512", null));
break;
}
_obj.Password = hashPassword.ToString();
#endregion
//_obj.Password = StringCipher.Encrypt(_obj.Password);
InstituteRepository _objRepository = new InstituteRepository();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.CreatedIP = localIP;
DataSet _ds = _objRepository.Save_Preamble_Data(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
flag = _ds.Tables[0].Rows[0]["FLAG"].ToString();
}
}
}
catch (System.Exception)
{
throw;
}
return(Json(new
{
flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult Check_And_ChangePassword(InstituteMaster _obj)
{
bool flagCheckPassword = false;
bool flagCaptcha = false;
bool flagPwdChanged = false;
if (this.Session["CaptchaImageText"].ToString() == _obj.Captchastr)
{
flagCaptcha = true;
_obj.InstituteID = Session["InstituteID"].ToString();
InstituteRepository _objRepository = new InstituteRepository();
DataSet ds = _objRepository.Login_Institute(_obj);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
string actualPassword = dr["Password"].ToString();
string random = "";
if (dr["DefaultPassword"] != null)
{
random = dr["DefaultPassword"].ToString();
}
if (dr["IsPasswordChanged"].ToString().ToLower() == "true")
{
string password = _obj.DefaultPassword;
string MD5 = Helper.VerifyHash(password, "MD5", actualPassword).ToString();
string SHA1 = Helper.VerifyHash(password, "SHA1", actualPassword).ToString();
string sha256 = Helper.VerifyHash(password, "SHA256", actualPassword).ToString();
string sha384 = Helper.VerifyHash(password, "SHA384", actualPassword).ToString();
string sha512 = Helper.VerifyHash(password, "SHA512", actualPassword).ToString();
if (MD5 == "True" || SHA1 == "True" || sha256 == "True" || sha384 == "True" || sha512 == "True")
{
flagCheckPassword = true;
}
}
else
{
if (random != "")
{
if (random == _obj.DefaultPassword)
{
flagCheckPassword = true;
}
}
}
if (flagCheckPassword)
{
Random rn = new Random();
#pragma warning disable SCS0005 // Weak random generator
int month = rn.Next(1, 6);
#pragma warning restore SCS0005 // Weak random generator
StringBuilder hashPassword = new StringBuilder();
string new_password = _obj.Password;
switch (month)
{
case 1:
hashPassword.Append(Helper.ComputeHash(new_password, "MD5", null));
break;
case 2:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA1", null));
break;
case 3:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA256", null));
break;
case 4:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA384", null));
break;
case 5:
hashPassword.Append(Helper.ComputeHash(new_password, "SHA512", null));
break;
}
_obj.Password = hashPassword.ToString();
DataSet _dsChngPwd = _objRepository.Institute_password_change(_obj);
if (_dsChngPwd != null)
{
if (_dsChngPwd.Tables[0].Rows.Count > 0)
{
flagPwdChanged = true;
Session["IsPasswordChanged"] = "true";
}
}
}
}
}
}
return(Json(new
{
flagCaptcha = flagCaptcha,
flagPwdChanged = flagPwdChanged
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult ForgotPassword(InstituteMaster _obj)
{
bool flag = false;
bool flagHead = false;
bool flagCaptcha = false;
string Email = "";
string Error = string.Empty;
InstituteRepository _objRepository = new InstituteRepository();
try
{
if (this.Session["CaptchaImageText"].ToString() == _obj.Captchastr)
{
flagCaptcha = true;
string password = Membership.GeneratePassword(8, 1);
_obj.DefaultPassword = password;
DataSet ds = _objRepository.InstituteForgotPassword(_obj);
SendEmail _objseedemail = new SendEmail();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1")
{
//string strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername"];
string strform = string.Empty;
#region Code to send mails simultaneously in a loop (By Amit: 14-06-2019 11:45 AM)
if (System.Web.HttpContext.Current.Application["UserCountForMail"] == null)
{
System.Web.HttpContext.Current.Application["UserCountForMail"] = 1;
}
else
{
}
int UserCountForMail = Convert.ToInt32(System.Web.HttpContext.Current.Application["UserCountForMail"]);
if (UserCountForMail < 4)
{
UserCountForMail++;
}
else
{
UserCountForMail = 1;
}
System.Web.HttpContext.Current.Application["UserCountForMail"] = UserCountForMail;
if (System.Web.HttpContext.Current.Application["UserCountForMail"] == null)
{
System.Web.HttpContext.Current.Application["UserCountForMail"] = 1;
}
else
{
}
//int UserCountForMail = Convert.ToInt32(System.Web.HttpContext.Current.Application["UserCountForMail"]);
if (UserCountForMail < 4)
{
UserCountForMail++;
}
else
{
UserCountForMail = 1;
}
if (System.Web.HttpContext.Current.Application["UserCountForMail"] == null)
{
System.Web.HttpContext.Current.Application["UserCountForMail"] = 1;
}
if (UserCountForMail == 1)
{
strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername1"];
}
else if (UserCountForMail == 2)
{
strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername2"];
}
else if (UserCountForMail == 3)
{
strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername3"];
}
else if (UserCountForMail == 4)
{
strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername4"];
}
#endregion
string Subject = "Forgot Password: Study in India";
StringBuilder MailBody = new StringBuilder();
MailBody.Append("<br/>Dear Sir/Madam <br/>");
MailBody.Append("<br/>You may now login with below credentials:");
MailBody.Append("<br/>Username: "******"InstituteID"].ToString());
MailBody.Append("<br/>Password: "******"<br/><br/><a target='_blank' href='" + FullyQualifiedApplicationPath(ControllerContext.RequestContext.HttpContext.Request) + "admission/login' style='color:blue;'>click here</a> to reset your Student Portal password." + "<br/>");
MailBody.Append("<br/>Please note: This is an auto generated email.<br/>");
MailBody.Append("<br/>Regards,<br/>");
MailBody.Append("Team Study in India (SII)<br/>");
string bcc = "";
string cc = "";
Email = ds.Tables[0].Rows[0]["Email"].ToString();
//Email = "*****@*****.**";
//_objseedemail.SendEmailInBackgroundThread(strform, Email, bcc, cc, Subject, MailBody.ToString(), "", true);
_objseedemail.SendEmailForRegistration(strform, Email, bcc, cc, Subject, MailBody.ToString(), "", true);
flag = true;
flagHead = true;
}
else if (ds.Tables[0].Rows[0]["COUNTS"].ToString() == "-1")
{
flag = true;
flagHead = false;
}
else
{
flag = false;
}
}
}
}
catch (Exception ex)
{
//throw;
Error = ex.Message;
}
return(Json(new
{
flag = flag,
flagCaptcha = flagCaptcha,
flagHead = flagHead,
Email = Email,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult ListOfStudents(string PL = "", string StartIndex = "", string PageSize = "", string SearchByText = "")
{
string Code = string.Empty, Message = string.Empty, Error = string.Empty;
try
{
InstituteRepository _objRepo = new InstituteRepository();
DataSet _ds = _objRepo.SELECT_PHASE2_ALLOTED_STUDENTS_FOR_INSTITUTES(Session["InstituteID"].ToString(), "PrgList", PL, StartIndex, PageSize, SearchByText);
List <mAdmittedStudentsList> _list = new List <mAdmittedStudentsList>();
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mAdmittedStudentsList
{
ID = _dr["ID"].ToString(),
StudentName = _dr["StudentName"].ToString(),
Email = _dr["Email"].ToString(),
Mobile = _dr["Mobile"].ToString(),
Country_Name = _dr["Country_Name"].ToString(),
Discipline = _dr["Discipline"].ToString(),
ProgrammeLevel = _dr["ProgrammeLevel"].ToString(),
Qualification = _dr["Qualification"].ToString(),
CourseOfStudy = _dr["CourseOfStudy"].ToString(),
Nationality = _dr["Nationality"].ToString(),
StudentID = _dr["StudentID"].ToString(),
StudentGender = _dr["StudentGender"].ToString(),
IsSeatAlloted = _dr["IsSeatAlloted"].ToString(),
InstituteID_Alloted = _dr["InstituteID_Alloted"].ToString(),
InstituteCourseID_Alloted = _dr["InstituteCourseID_Alloted"].ToString(),
InstituteName = _dr["InstituteName"].ToString(),
FeeWaiver = _dr["FeeWaiver"].ToString(),
FeeWaiverRemarks = _dr["FeeWaiverRemarks"].ToString(),
ProgramLevel = _dr["ProgramLevel"].ToString(),
ISApprovebyInstitute = _dr["ISApprovebyInstitute"].ToString(),
ApprovebyInstituteRemarks = _dr["ApprovebyInstituteRemarks"].ToString(),
ApprovebyInstituteDate = _dr["ApprovebyInstituteDate"].ToString(),
Doc_AllotmentLetter = _dr["Doc_AllotmentLetter"].ToString(),
SkypeInterviewRequired = _dr["SkypeInterviewRequired"].ToString(),
SkypeInterviewDate = _dr["SkypeInterviewDate"].ToString(),
SkypeInterviewStatus = _dr["SkypeInterviewStatus"].ToString(),
StudentStatus = _dr["StudentStatus"].ToString(),
StudentStatusRemarks = _dr["StudentStatusRemarks"].ToString(),
ApplicationNo = _dr["ApplicationNo"].ToString()
});
}
Message = "Student has been approved successfully!";
Code = "success";
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.!";
Code = "servererror";
}
}
}
catch (NullReferenceException)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
}
catch (Exception)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
}
return(Json(new
{
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public DropDownController()
{
_repositoryIns = new InstituteRepository();
allIns = _repositoryIns.GetInstitutes();
formModal = new FormModal();
}
public HomeController()
{
instituteRepository = new InstituteRepository();
newsRepository = new NewsRepository();
}
// GET: Institute/GenerateDataForMail
public ActionResult Index()
{
InstituteRepository _objRepository = new InstituteRepository();
DataSet _dsInstituteListForGeneration = _objRepository.Select_All_Institutes();
if (_dsInstituteListForGeneration != null)
{
if (_dsInstituteListForGeneration.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _dsInstituteListForGeneration.Tables[0].Rows)
{
string InstituteID = "SII-I-" + (Convert.ToInt32(_dr["ID"].ToString())).ToString("D4");
string AccessURL = "";
AccessURL = FullyQualifiedApplicationPath(ControllerContext.RequestContext.HttpContext.Request) + "Institute/Preamble/Index?u=" + StringCipher.Encrypt(InstituteID);
#region Generate Random Password
Random random = new Random();
string combination = "123456789ABCDEFGHJKMNPQRSTUVWXYZabcdefghjkmnpqrstuvwxyz";
StringBuilder captcha = new StringBuilder();
for (int i = 0; i < 8; i++)
#pragma warning disable SCS0005 // Weak random generator
{
captcha.Append(combination[random.Next(combination.Length)]);
}
#pragma warning restore SCS0005 // Weak random generator
string DefaultPassword = captcha.ToString();
#endregion
DataSet _ds = _objRepository.Update_Institute_Data_For_MailSending(_dr["ID"].ToString(), InstituteID, AccessURL, DefaultPassword);
}
}
}
DataSet _dsInstituteListForMailSending = _objRepository.Select_All_Institutes();
if (_dsInstituteListForMailSending != null)
{
if (_dsInstituteListForMailSending.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _dsInstituteListForMailSending.Tables[0].Rows)
{
string strform = "*****@*****.**"; //System.Configuration.ConfigurationManager.AppSettings["formemail"];
string Subject = "Registered successfully for Study In India";
//string strTo = "*****@*****.**";
string strTo = _dr["Email"].ToString();
SendEmail _objseedemail = new SendEmail();
StringBuilder MailBody = new StringBuilder();
MailBody.Append("<br/>Dear Sir/Madam,<br/>");
MailBody.Append("<br/>Greetings from Study in India!<br/>");
MailBody.Append("<br/>Please ");
MailBody.Append("<a target='_blank' href='" + _dr["AccessURL"].ToString() + "' style='color:blue;'>click here</a>");
MailBody.Append(" to open Instiute form to fill for Study In India!" + "<br/>");
MailBody.Append("Your Login Details:" + "<br/>");
MailBody.Append("InstituteID: " + _dr["InstituteID"].ToString() + "<br/>");
MailBody.Append("First time Password: "******"DefaultPassword"].ToString() + "<br/><br/>");
MailBody.Append("<br/>Please note: This is an auto generated email. In case of any technical queries please contact: <br/>");
MailBody.Append("<br/>Regards,<br/>");
MailBody.Append("Study in India<br/>");
string bcc = "";
string cc = "";
_objseedemail.SendEmailInBackgroundThread(strform, strTo, bcc, cc, Subject, MailBody.ToString(), "", true);
//flagSent = true;
}
}
}
ViewBag.Data = _dsInstituteListForMailSending;
return(View());
}
