public JsonResult SavePassword(string Email, string Password)
{
//var HasStudents = (from StudentTable in db.tblStudents
// join StudentRegistration in db.tblStudentRegistrations on StudentTable.Id equals StudentRegistration.StudentId
// where StudentTable.FatherEmail == Email || StudentTable.MotherEmail == Email
// select new
// {
// StudentTable.Id,
// Name = StudentTable.FirstName + " " + StudentTable.MiddleName + " " +
// StudentTable.LastName,
// StudentRegistration.RegistrationCode,
// StudentRegistration.Course,
// StudentRegistration.Batch,
// StudentTable.OrgId,
// StudentTable.FatherName,
// StudentTable.Sex
// }).ToList();
var User = (from tableApplogin in db.tblAppLogins
where tableApplogin.Email == Email
select tableApplogin).FirstOrDefault();
if (User != null)
{
User.Password = SMSDataformatter.EncryptText(Password);
User.IsRegistered = true;
db.Entry(User).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { status = true /*Students = HasStudents */ }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false }, JsonRequestBehavior.AllowGet));
}
}
//[Route("getEmployeePassword")]
public JsonResult getEmployeePassword(string Email, string OrgName)
{
var Password = "";
string message = string.Empty;
var OrgDetails = GetOrgDetails(OrgName.Trim().ToLower());
if (OrgDetails != null)
{
long loggedUserOrgid = Convert.ToInt64(OrgDetails.GetType().GetProperty("OrgId").GetValue(OrgDetails, null));
var loggedUser = db.tblLogins.Where(x => x.UserName.ToLower() == Email.ToLower() &&
x.OrgId == loggedUserOrgid).Select(x => x).SingleOrDefault();
if (loggedUser != null)
{
Password = SMSDataformatter.DecryptText(loggedUser.Password);
string Body = "<html><body> Hi there! <br /><br /> Your Password is:" + Password + "</body></html>";
string subject = "Password";
EmailHelper.TrySendEmail(subject, Body, Email);
message = string.Format("Password Sent your Email!");
return(Json(new { status = true, Message = message }));
}
else
{
message = string.Format("Email Not Exist!");
return(Json(new { status = false, Message = message }));
}
}
else
{
message = string.Format("OrgName Not Exist!");
return(Json(new { status = false, Message = message }));
}
}
public JsonResult EmployeeLogin(string Username, string Password, string OrgName)
{
string message = string.Empty;
try
{
var OrgDetails = GetOrgDetails(OrgName.Trim().ToLower());
if (OrgDetails != null)
{
long loggedUserOrgid = Convert.ToInt64(OrgDetails.GetType().GetProperty("OrgId").GetValue(OrgDetails, null));
var loggedUser = db.tblLogins.Where(x => x.UserName.ToLower() == Username.ToLower() &&
x.OrgId == loggedUserOrgid && x.IsActive == true).Select(x => x).SingleOrDefault();
if (loggedUser != null)
{
if (SMSDataformatter.DecryptText(loggedUser.Password) == Password)
{
return(Json(new { Status = true, User = new { Username = loggedUser.UserName, OrgId = loggedUser.OrgId, UserId = loggedUser.UserId } }, JsonRequestBehavior.AllowGet));
}
else
{
message = string.Format("Password wrong!", Username);
return(Json(new { Status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
else
{
message = string.Format("{0} not exists!", Username);
return(Json(new { Status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
else
{
message = string.Format("Organiztion Name not exists!");
return(Json(new { Status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(new { message = e.ToString(), status = false }, JsonRequestBehavior.AllowGet));
}
}
public IEnumerable <string> GetA(string Username, string Password)
{
try
{
var data = (from tableLogin in db.tblLogins
where tableLogin.UserName == Username
select tableLogin).SingleOrDefault();
if (data != null)
{
if (SMSDataformatter.DecryptText(data.Password) == Password)
{
}
else
{
}
}
}
catch (Exception)
{
}
return(new string[] { "value1", "value2" });
}
public JsonResult Login(string Username, string Password)
{
string message = string.Empty;
try
{
var data = (from tableLogin in db.tblAppLogins
where tableLogin.Email == Username && tableLogin.IsRegistered == true
select new { Password = tableLogin.Password, Username = tableLogin.Email, tableLogin.Id }).SingleOrDefault();
if (data != null)
{
var Pwd = SMSDataformatter.DecryptText(data.Password);
if (SMSDataformatter.DecryptText(data.Password) == Password)
{
var HasStudents = (from StudentTable in db.tblStudents
join StudentRegistration in db.tblStudentRegistrations on StudentTable.Id equals StudentRegistration.StudentId
where StudentTable.FatherEmail == Username || StudentTable.MotherEmail == Username
select new { StudentTable.Id, Name = StudentTable.FirstName + " " + StudentTable.MiddleName + " " +
StudentTable.LastName, StudentRegistration.RegistrationCode, StudentRegistration.Course,
StudentRegistration.Batch, StudentTable.OrgId, StudentTable.FatherName, StudentTable.Sex }).ToList();
return(Json(new { Status = true, User = new { Username = data.Username, UserId = data.Id, }, HasStudents }, JsonRequestBehavior.AllowGet));
}
else
{
message = string.Format("Password wrong!", Username);
return(Json(new { Status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
else
{
message = string.Format("{0} not exists!", Username);
return(Json(new { Status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(new { Status = false, Message = e.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult getPassword(string Email)
{
string message = string.Empty;
var Password = "";
var User = db.tblAppLogins.Where(x => x.Email == Email).Select(x => x).SingleOrDefault();
if (User != null)
{
Password = SMSDataformatter.DecryptText(User.Password);
string Body = "<html><body> Hi there! <br /><br /> Your Password is:" + Password + "</body></html>";
string subject = "Password";
EmailHelper.TrySendEmail(subject, Body, Email);
message = string.Format("Password Sent your Email!");
return(Json(new { status = true, Message = message }));
}
else
{
message = string.Format("Email Not Exist!");
return(Json(new { status = false, Message = message }));
}
}
