public string post([FromBody] User_Registration stud)
{
string result = "";
try
{
var data = db.User_Registration.Where(x => x.EmailID == stud.EmailID).FirstOrDefault();
if (data == null)
{
return(result);
}
string OTP = GeneratePassword();
data.ActivationCode = Guid.NewGuid();
data.OTP = OTP;
db.Entry(data).State = System.Data.EntityState.Modified;
var res = db.SaveChanges();
if (res > 0)
{
ForgetPasswordEmailToUser(data.EmailID, data.ActivationCode.ToString(), data.OTP);
result = "success";
return(result);
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AdminLogin(string userid, string password)//to check login credentials for all 3 roles
{
User_Registration l = DBOperations.CheckRegistration(userid, password);
if (l != null)
{
Session["username"] = l.Userid;
if (l.Role_Type == "admin" && l.Status == "Approved")
{
return(RedirectToAction("SuccessfulAdmin"));
}
else if (l.Role_Type == "Customer" && l.Status == "Approved")
{
return(RedirectToAction("SuccessfulCustomer"));
}
else if (l.Role_Type == "BA" && l.Status == "Approved")
{
return(RedirectToAction("SuccessfulBA"));
}
else if (l.Status == "Rejected")
{
return(RedirectToAction("RejectLogin"));
}
else
{
return(View("WrongLogin"));
}
}
else
{
return(View("WrongLogin"));
}
}
private void DataExtract(User_Registration ur)
{
ur.UserID = hfUserID.Value;
ur.UserName = txtUserName.Text.ToLower().Trim();
ur.Password = EncryptedPassword;
ur.EncryptedKey = EncryptionKey;
ur.FirstName = txtFirstName.Text.Trim();
ur.LastName = txtLastName.Text.Trim();
bool checkddl = IsGuid(ddlRole.SelectedValue);
if (checkddl == true)
{
ur.RoleID = ddlRole.SelectedValue;
}
else
{
ur.RoleID = hfRoleID.Value;
}
ur.IsDeleted = false;
ur.CreatedDate = null;
ur.CreatedBy = Session["username"].ToString();
ur.UpdatedDate = null;
if (btnSave.Text == "Update")
{
ur.UpdatedBy = Session["username"].ToString();
}
else
{
ur.UpdatedBy = null;
}
ur.DeletedDate = null;
if (btnSave.Text == "Delete")
{
ur.DeletedBy = Session["username"].ToString();
}
else
{
ur.DeletedBy = null;
}
if (btnSave.Text == "Save")
{
ur.Flag = (int)MPOP_Dashboard_Enum.StoredProcedureType.Insert;
}
else if (btnSave.Text == "Update")
{
ur.Flag = (int)MPOP_Dashboard_Enum.StoredProcedureType.Update;
}
else
{
ur.Flag = (int)MPOP_Dashboard_Enum.StoredProcedureType.Delete;
}
}
public ActionResult AdminReject()//on clicking the "REJECT" button,all selected records will have status now as "rejected" and they will be added in User_Registration table
{
if (Session["username"] == null)
{
return(RedirectToAction("Login"));
}
var cid = Request.Form.Get("chckbox");
var bid = Request.Form.Get("chckbox1");
List <User_Registration> ulist = new List <User_Registration>();
User_Registration U = null;
clist = DBOperations.GetAll();
blist = DBOperations.GetallB();
foreach (var c in clist)
{
if (cid.Contains(c.Customer_id.ToString()))
{
c.Status = "Rejected";
U = new User_Registration();
U.Userid = c.Customer_id;
U.Password = c.Password;
U.Role_Type = c.Role_Type;
U.Status = "Rejected";
U.Create_date = DateTime.Today;
ulist.Add(U);
}
}
if (bid != null)
{
foreach (var b in blist)
{
if (bid.Contains(b.Branch_id.ToString()))
{
b.Status = "Rejected";
U = new User_Registration();
U.Userid = b.Branch_id;
U.Password = b.Password;
U.Status = "Rejected";
U.Role_Type = b.Role_Type;
U.Create_date = DateTime.Today;
ulist.Add(U);
}
}
}
string mesg = DBOperations.UserRegistration(ulist);
ViewBag.message = mesg;
return(View("AdminRejects"));
}
// GET: User_Registration
public ActionResult Index(User_Registration reg)
{
using (var db = new TapalsEntities())
{
db.Registrations.Add(new Registration
{
// Emp_ID=reg.EmpId,
Username = reg.Username,
Password = reg.Password,
Section = reg.Section,
Designation = reg.Designation
});
db.SaveChanges();
}
return(View());
}
public IActionResult Save(IFormCollection keyValues)
{
var firstname = keyValues["firstname"][0];
var lastname = keyValues["lastname"][0];
var useradd = keyValues["useradd"][0];
var email = keyValues["email-id"][0];
var userpass = keyValues["userpass"][0];
// var dob = keyValues["dob"][5];
DateTime dob = Convert.ToDateTime(keyValues["dob"][0]);//use jquery to do validations
var city = keyValues["city"][0];
var zipcode = keyValues["zipcode"][0];
var state = keyValues["state"][0];
var isUserAlreadyInDB = false;
isUserAlreadyInDB = _context.User_Registration.Where(x => x.Email_ID.ToLower() == email.ToLower()).Any();//Any()--property of the LinQ
//put "." and learn all properties //&& x.User_Password == password)
if (isUserAlreadyInDB)
{
TempData["Error"] = "User already in the system";
TempData.Keep("Error");
return(RedirectToAction("Signup"));
}
User_Registration user_Registration = new User_Registration();
user_Registration.First_Name = firstname;
user_Registration.Last_Name = lastname;
user_Registration.User_Address = useradd;
user_Registration.Email_ID = email;
user_Registration.User_Password = userpass;
user_Registration.Date_Of_Birth = dob;
user_Registration.City_Name = city;
user_Registration.Zip_Code = zipcode;
user_Registration.State_Name = state;
user_Registration.User_Status = true;
// _context.User_Registrations.Add(user_Registration);//used LinQ to insert data in DB instead Query
//basically save syntext
_context.User_Registration.Add(user_Registration);//OrderingSystem.Models.User_Registration
_context.SaveChanges();
return(RedirectToAction("Login"));
}
public bool Post([FromBody] User_Registration ur)
{
try
{
ur.Password = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create().ComputeHash(Encoding.UTF8.GetBytes(ur.Password)));
db.User_Registration.Add(ur);
var res = db.SaveChanges();
if (res > 0)
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
public HttpResponseMessage Register(User_Registration user)
{
//checks if email id already exits or not
bool EmailAlreadyExists = db.User_Registration.Any(x => x.Email_ID == user.Email_ID);
if (ModelState.IsValid && EmailAlreadyExists != true)
{
user.Email_ID = user.Email_ID;
user.Password = Encryptword(user.Password);//key used for encryption
db.User_Registration.Add(user);
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, user);
return(response);
}
else
{
HttpResponseMessage response = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Email Id Already Exists");
return(response);
}
}
public IActionResult LoginValidate(IFormCollection keyValues)
{
var email = keyValues["email-id"][0];
var userpass = keyValues["password"][0];
User_Registration user_Registration = new User_Registration();
user_Registration.Email_ID = email;
user_Registration.User_Password = userpass;
var IsUserValidate = true;
IsUserValidate = _context.User_Registration.Where(x => x.Email_ID.ToLower() == email.ToLower() && x.User_Password == userpass).Any();
if (IsUserValidate == false)
{
TempData["Error"] = "Password or email wrong";
TempData.Keep("Error");
return(RedirectToAction("Login"));
}
return(RedirectToAction("About"));
}
public bool Put([FromBody] User_Registration stud)
{
bool result = false;
try
{
string otp = stud.OTP;;
string NewPass = Convert.ToBase64String(System.Security.Cryptography.SHA256.Create().ComputeHash(Encoding.UTF8.GetBytes(stud.Password)));
var res = db.sp_UpdatePassword(otp, NewPass);
if (res > 0)
{
result = true;
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public JsonResult Register(User_Registration registermodel)
{
if (registermodel.Registration_Type == 1)//student
{
Student std = new Student();
std.Student_Name = registermodel.Name;
std.Student_Registration_No = registermodel.university_Id;
std.Student_Email = registermodel.Student_Email;
std.Student_Registration_No = registermodel.university_Id;
std.IsActive = false;
std.IsPending = true;
std.DateCreated = DateTime.Now;
db.Students.Add(std);
db.SaveChanges();
var id = std.ID;
User regusr = new User();
regusr.User_Name = registermodel.Name;
regusr.User_Password = registermodel.User_Password;
regusr.Date_Created = DateTime.Now;
regusr.Status = "Pending";
regusr.Is_Active = false;
regusr.Is_Pending = true;
regusr.Is_Block = false;
regusr.Email = registermodel.Student_Email;
regusr.Is_Student = true;
regusr.Is_Advisor = false;
regusr.Std_Adv_Id = Convert.ToInt32(id);
db.Users.Add(regusr);
db.SaveChanges();
return(Json(new { url = "/Account/Login", msg = "Successfully Created Waiting For Approval From Admin", success = true }, JsonRequestBehavior.AllowGet));
}
else//advisor
{
Advisor adv = new Advisor();
adv.AdvisorsName = registermodel.Name;
adv.Advisor_Description = "";
adv.Advisor_Email = registermodel.Student_Email;
adv.Advisor_Uni_ID = registermodel.university_Id;
adv.Advisor_Requested_Date = DateTime.Now;
adv.IsBlock = false;
adv.IsActive = false;
adv.Advisors_Slot = 5;
db.Advisors.Add(adv);
db.SaveChanges();
var id = adv.Id;
User regusr = new User();
regusr.User_Name = registermodel.Name;
regusr.User_Password = registermodel.User_Password;
regusr.Date_Created = DateTime.Now;
regusr.Status = "Pending";
regusr.Is_Active = false;
regusr.Is_Pending = true;
regusr.Is_Block = false;
regusr.Email = registermodel.Student_Email;
regusr.Is_Student = false;
regusr.Is_Advisor = true;
regusr.Std_Adv_Id = Convert.ToInt32(id);
db.Users.Add(regusr);
db.SaveChanges();
return(Json(new { url = "/Account/Login", msg = "Successfully Created Waiting For Approval From Admin", success = true }, JsonRequestBehavior.AllowGet));
}
}
partial void DeleteUser_Registration(User_Registration instance);
partial void UpdateUser_Registration(User_Registration instance);
partial void InsertUser_Registration(User_Registration instance);
