//SchoolContext db = new SchoolContext();
public TBLUSERLOGIN GetLoginDetails(ParamLogin userLogin)
{
SchoolMainContext db = new ConcreateContext().GetContext(userLogin.UserName, userLogin.Password);
if (db == null)
{
return(null);
}
string Password = CryptIt.Decrypt("HZy7aySL2L5aIjyVSYQDJw==");
string passecrypt = CryptIt.Encrypt(userLogin.Password);
var logindetail = db.TBLUSERLOGINs.
Where(r => r.UserName == userLogin.UserName && r.Password == passecrypt && r.STATUS == "ACTIVE")
.FirstOrDefault();
return(logindetail);
}
public object UpdateUser(ParamRegistration PR)
{
try
{
tbl_user obj = context.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (PR.Password == null)
{
obj.name = PR.Name;
obj.email = PR.Email;
obj.contact = PR.Contact;
//obj.password = PR.Password;
}
else
{
var oldpassword = context.tbl_user.FirstOrDefault(r => r.UserId == PR.UserId);
if (CryptIt.Decrypt(oldpassword.password) == PR.OldPassword)
{
obj.name = PR.Name;
obj.email = PR.Email;
obj.contact = PR.Contact;
obj.password = CryptIt.Encrypt(PR.Password);
}
else
{
return(new Error()
{
IsError = true, Message = "Please Check old password."
});
}
}
context.SaveChanges();
return(new Result()
{
IsSucess = true, ResultData = "User Updated Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object GetUser()
{
var name = CryptIt.Decrypt("vPelNrzLabeGOYF6LMYvZA==");
try
{
UserCredentialModel userCredentialModel = new UserCredentialModel()
{
UserName = "******"
};
return(userCredentialModel);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public object ForgetPassword(ForgetPassword obj)
{
if (obj.ContactNumber == null)
{
return(new Error()
{
IsError = true, Message = "Contact Number Required"
});
}
GRContext db = new GRContext();
string res = "";
var user = db.tbl_user.Where(r => r.contact == obj.ContactNumber).FirstOrDefault();
if (user == null)
{
return(new Error()
{
IsError = true, Message = "Contact Number Not Found"
});
}
if (user.name.Length > 0)
{
res = "Dear <b>" + user.name + "</b> your User Name is <b>" + user.name + "</b> and Password is <b>" + CryptIt.Decrypt(user.password) + "</b>.";
}
else
{
res = "Sorry we didn't find you in our system.";
return(res);
}
try
{
Email objemail = new Email();
bool IsDelete;
if (user.email.Length > 0)
{
//IsDelete = objSMS.SMSSend(MobNo, res);
IsDelete = objemail.SendEmail(user.email, res, "Forgot Password", "", "", "", "");
res = "User Name and Password Is Send On Your Registred Email ID. ";
return(new Result()
{
IsSucess = true, ResultData = res
});
}
else
{
res = "Sorry we didn't find your Email ID in our system.";
//return new Error() { IsError = true, Message = res };
}
return(res);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
public bool SendEmail(string MailAddress, string msg, string Subject, string UserName, string Password, string Port, string SMTPhost)
{
GRContext db = new GRContext();
try
{
var Hostinfo = db.tbl_emailsettings.FirstOrDefault();
var username = Hostinfo.fromid;
SmtpClient mailSender = new SmtpClient(Hostinfo.host);//"smtp.gmail.com"
//mailSender.Port = Int32.Parse(Port );// 25;
mailSender.Port = 25;
MailMessage message = new MailMessage();
System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(username, CryptIt.Decrypt(Hostinfo.password));
mailSender.Credentials = credentials;
mailSender.EnableSsl = true;
message.From = new MailAddress(username, "GRIEVANCE");
if (MailAddress.Contains(","))//MailAddress
{
string[] Multiple = MailAddress.Split(',');
foreach (string Multi in Multiple)
{
message.To.Add(new MailAddress(Multi));
}
}
else
{
message.To.Add(new MailAddress(MailAddress));//MailAddress
}
message.Subject = Subject;
message.Body = msg;
message.IsBodyHtml = true;
mailSender.Send(message);
return(true);
}
catch (Exception e)
{
return(false);
}
}
