public DataSet StudentForgotPassword(InstituteMaster _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("UpdateForgotPassword", _cn); _cmd.Parameters.AddWithValue("@random", _obj.DefaultPassword); _cmd.Parameters.AddWithValue("@Email", _obj.Email); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
public DataSet Institute_password_change(InstituteMaster _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_institute_password_change", _cn); _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); _cmd.Parameters.AddWithValue("@Password", _obj.Password); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _cn.Close(); } }
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 )); }
public async Task <IActionResult> Create(InstituteMaster model, IFormFile InstituteLogo) { model.IsActive = 1; model.IsDeleted = 0; model.CreatedBy = 1; model.CreatedDate = DateTime.Now; model.InstituteLogo = await UploadImage(InstituteLogo); var result = await _IGenericRepo.CreateEntity(model); return(Json("Institute Detail Created Successfully.")); }
// 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")); }
public DataSet Update_Institute_Details(InstituteMaster _obj) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("sp_Update_Institute_Details", _cn); _cmd.Parameters.AddWithValue("@ID", _obj.ID); _cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID); _cmd.Parameters.AddWithValue("@InstituteName", _obj.InstituteName); _cmd.Parameters.AddWithValue("@Address", _obj.Address); _cmd.Parameters.AddWithValue("@State", _obj.State); _cmd.Parameters.AddWithValue("@City", _obj.City); _cmd.Parameters.AddWithValue("@Pin", _obj.Pin); _cmd.Parameters.AddWithValue("@YOE", _obj.YOE); _cmd.Parameters.AddWithValue("@Description", _obj.Description); _cmd.Parameters.AddWithValue("@Email", _obj.Email); //_cmd.Parameters.AddWithValue("@History", _obj.History); //_cmd.Parameters.AddWithValue("@Awards", _obj.Awards); //_cmd.Parameters.AddWithValue("@Fellows", _obj.Fellows); //_cmd.Parameters.AddWithValue("@News", _obj.News); //_cmd.Parameters.AddWithValue("@Area", _obj.Area); // _cmd.Parameters.AddWithValue("@ProgramOffered", _obj.ProgramOffered); _cmd.Parameters.AddWithValue("@AcademicCourses", _obj.AcademicCourses); _cmd.Parameters.AddWithValue("@AreaOfExcellence", _obj.AreaOfExcellence); _cmd.Parameters.AddWithValue("@ResearchCapability", _obj.ResearchCapability); // _cmd.Parameters.AddWithValue("@FacultyOverview", _obj.FacultyOverview); _cmd.Parameters.AddWithValue("@NotableResearchPublication", _obj.NotableResearchPublication); _cmd.Parameters.AddWithValue("@NIRFRanking", _obj.NIRFRanking); _cmd.Parameters.AddWithValue("@NBANAACAccreditation", _obj.NBANAACAccreditation); _cmd.Parameters.AddWithValue("@instituteweburl", _obj.instituteweburl); _cmd.Parameters.AddWithValue("@ModifiedIP", _obj.ModifiedIP); _cmd.Parameters.AddWithValue("@Edited_by", _obj.Edited_by); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return(_ds); } catch (Exception) { throw; } finally { _obj = null; _cn.Close(); } }
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 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 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 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 )); }