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
));
}
