public ActionResult EditUser(int Userid)
{
UserDropdownEntities userDropdownEntities = new UserDropdownEntities();
var getuserlist = userDropdownEntities.Dropdowns.ToList();
SelectList list = new SelectList(getuserlist.Where(o => o.DropdownType == "Userlevel"), "DropdownName", "DropdownName");
ViewBag.userlist = list;
UserModel userModel = new UserModel();
DataTable dtblUser = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(connectionString)) {
sqlCon.Open();
string query = "SELECT * from [User] Where Userid = @UserID";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon);
sqlDa.SelectCommand.Parameters.AddWithValue("@UserID", Userid);
sqlDa.Fill(dtblUser);
}
if (dtblUser.Rows.Count == 1)
{
userModel.Userid = Convert.ToInt32(dtblUser.Rows[0][0].ToString());
userModel.Email = dtblUser.Rows[0][1].ToString();
userModel.Userlevel = dtblUser.Rows[0][2].ToString();
userModel.EmployeeNumber = Convert.ToInt32(dtblUser.Rows[0][4].ToString());
userModel.FirstName = dtblUser.Rows[0][5].ToString();
userModel.LastName = dtblUser.Rows[0][6].ToString();
userModel.ProfilePic = dtblUser.Rows[0][7].ToString();
return(View(userModel));
}
else
{
return(RedirectToAction("Userlist"));
}
}
public ActionResult ViewApplicant(int?MasterlistID)
{
if (MasterlistID == null)
{
return(RedirectToAction("ApplicantList"));
}
UserDropdownEntities userDropdownEntities = new UserDropdownEntities();
var getuserlist = userDropdownEntities.Dropdowns.ToList();
SelectList MaritalStatusList = new SelectList(getuserlist.Where(o => o.DropdownType == "MaritalStatus"), "DropdownName", "DropdownName");
SelectList JobTitleList = new SelectList(getuserlist.Where(o => o.DropdownType == "JobTitle"), "DropdownName", "DropdownName");
ViewBag.MaritalStatusList = MaritalStatusList;
ViewBag.JobTitleList = JobTitleList;
ViewApplicantModel model = new ViewApplicantModel();
DataTable dtblApplicant = new DataTable();
DataTable dtblWorkExperience = new DataTable();
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
string query = "SELECT * from Masterlist Where MasterlistID = @MasterlistID";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon);
sqlDa.SelectCommand.Parameters.AddWithValue("@MasterlistID", MasterlistID);
sqlDa.Fill(dtblApplicant);
string querys = "SELECT * from WorkExperience Where MasterlistID = @MasterlistID";
SqlDataAdapter sqlDas = new SqlDataAdapter(querys, sqlCon);
sqlDas.SelectCommand.Parameters.AddWithValue("@MasterlistID", MasterlistID);
sqlDas.Fill(dtblWorkExperience);
}
if (dtblApplicant.Rows.Count == 1)
{
model.MasterlistID = Convert.ToInt32(dtblApplicant.Rows[0][0].ToString());
model.FirstName = dtblApplicant.Rows[0][2].ToString();
model.MiddleName = dtblApplicant.Rows[0][3].ToString();
model.LastName = dtblApplicant.Rows[0][4].ToString();
model.Birthday = DateTime.Parse(dtblApplicant.Rows[0][7].ToString());
model.MaritalStatus = dtblApplicant.Rows[0][8].ToString();
model.JobTitle = dtblApplicant.Rows[0][6].ToString();
model.Street_Address1 = dtblApplicant.Rows[0][11].ToString();
model.Street_Address2 = dtblApplicant.Rows[0][12].ToString();
model.City = dtblApplicant.Rows[0][13].ToString();
model.Province = dtblApplicant.Rows[0][14].ToString();
model.ZipCode = dtblApplicant.Rows[0][15].ToString();
model.ContactNumber = dtblApplicant.Rows[0][10].ToString();
model.PersonalEmail = dtblApplicant.Rows[0][4].ToString();
ViewBag.MasterlistID = MasterlistID;
model.CompanyName = dtblWorkExperience.Rows[0][2].ToString();
model.WorkExperienceJobTitle = dtblWorkExperience.Rows[0][3].ToString();
model.DateFrom = DateTime.Parse(dtblWorkExperience.Rows[0][4].ToString());
model.DateTo = DateTime.Parse(dtblWorkExperience.Rows[0][5].ToString());
return(View(model));
}
else
{
return(RedirectToAction("ApplicantList"));
}
}
public ActionResult AddUser()
{
UserDropdownEntities userDropdownEntities = new UserDropdownEntities();
var getuserlist = userDropdownEntities.Dropdowns.ToList();
SelectList list = new SelectList(getuserlist.Where(o => o.DropdownType == "Userlevel"), "DropdownName", "DropdownName");
ViewBag.userlist = list;
return(View());
}
public ActionResult AddApplicant()
{
UserDropdownEntities userDropdownEntities = new UserDropdownEntities();
var getuserlist = userDropdownEntities.Dropdowns.ToList();
SelectList MaritalStatusList = new SelectList(getuserlist.Where(o => o.DropdownType == "MaritalStatus"), "DropdownName", "DropdownName");
SelectList JobTitleList = new SelectList(getuserlist.Where(o => o.DropdownType == "JobTitle"), "DropdownName", "DropdownName");
ViewBag.MaritalStatusList = MaritalStatusList;
ViewBag.JobTitleList = JobTitleList;
var tuple = new Tuple <Masterlist, WorkExperience>(new Masterlist(), new WorkExperience());
return(View(tuple));
}
public ActionResult LeaveForm()
{
UserDropdownEntities userDropdownEntities = new UserDropdownEntities();
UserModelEntities userModel = new UserModelEntities();
var getuserlist = userDropdownEntities.Dropdowns.ToList();
var getuser = userModel.Users.ToList();
SelectList LeaveRequest = new SelectList(getuserlist.Where(o => o.DropdownType == "LeaveRequest"), "DropdownName", "DropdownName");
SelectList Approver = new SelectList(getuser.Where(o => o.Userlevel == "Admin"), "Userid", "Email");
ViewBag.LeaveRequest = LeaveRequest;
ViewBag.Approver = Approver;
return(View());
}
