public ActionResult Register(FormCollection formCollection)
{
try
{
int empId = Convert.ToInt32(formCollection["EmployeeNumber"]);
string uname = formCollection["NewUsername"];
//check the record is already available or not
var checkRegistration = entities.UserRegistrationDetails.Where(q => q.EmployeeNumber == empId).FirstOrDefault();
var username = entities.UserRegistrationDetails.Where(q => q.Username == uname).FirstOrDefault();
if (checkRegistration == null && username == null)
{
//inserting data into User registration details table
UserRegistrationDetail user = new UserRegistrationDetail();
user.EmployeeNumber = empId;
user.EmployeeName = formCollection["EmployeeName"];
user.ContactNumber = formCollection["ContactNumber"];
user.Username = formCollection["NewUsername"];
user.Password = formCollection["Pass"];
entities.UserRegistrationDetails.Add(user);
//adding data in user questions details
UserQuestionDetail userQuestion = new UserQuestionDetail();
string qname = formCollection["AllQuestions"];
int qid = (from res in entities.Questions
where res.Question1 == qname
select res.QuestionId).FirstOrDefault();
userQuestion.QuestionId = qid;
userQuestion.Answer = formCollection["Answer"];
userQuestion.EmpoyeeNumber = Convert.ToInt32(formCollection["EmployeeNumber"]);
entities.UserQuestionDetails.Add(userQuestion);
entities.SaveChanges();
return(Content("<script language='javascript' type='text/javascript'>alert('Employee Registered Successfully');window.location = 'Index';</script>"));
}
else
{
// Content("<script language='javascript' type='text/javascript'>alert('This EmployeeId already Registered');window.location = "Index";</script>");
return(Content("<script language='javascript' type='text/javascript'>alert('This Employee already Registered');window.location = 'Index';</script>"));
}
}
catch (Exception)
{
return(Content("<script language='javascript' type='text/javascript'>alert('This Username already Registered');window.location = 'Index';</script>"));
}
}
public ActionResult Account()
{
if (Session["UserId"] != null /*&& Session["Role"] == DoctorRole*/)
{
var dbc = new DbConnectivityModel();
var userModel = new UserRegistrationDetail
{
CityName = dbc.ListOutCities(),
State = dbc.ListOutStates()
};
return(View(userModel));
}
else
{
return(RedirectToAction("Login", "Home"));
}
}
