public ActionResult Loaddata()
{
HRMDB objHRMEmp = new HRMDB();
var emp = objHRMEmp.AspNetUsers.OrderBy(x => x.Id).ToList();
return(Json(new { data = emp }, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(AspNetUser objasp, HttpPostedFileBase UploadedImage)
{
if (UploadedImage.ContentLength > 0)
{
string ImageFileName = Path.GetFileName(UploadedImage.FileName);
string Folderpath = Path.Combine(Server.MapPath("~/UploadedImages"), ImageFileName);
UploadedImage.SaveAs(Folderpath);
}
var image = UploadedImage.FileName;
objasp.ImageName = image;
objEmpBLL.EditEmp(objasp); HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
//string id = Session["id"].ToString();
//string id = Session["Empid"].ToString();
if (empdata.DepartmentId == "D4")
{
return(RedirectToAction("GetEmpByid", "Emp", new { ide }));
}
else
{
return(RedirectToAction("GetEmpByid", "Emp", new { ide }));
}
}
//
// GET: /Manage/Index
public async Task <ActionResult> Index(ManageMessageId?message)
{
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
ViewBag.StatusMessage =
message == ManageMessageId.ChangePasswordSuccess ? "Your password has been changed."
: message == ManageMessageId.SetPasswordSuccess ? "Your password has been set."
: message == ManageMessageId.SetTwoFactorSuccess ? "Your two-factor authentication provider has been set."
: message == ManageMessageId.Error ? "An error has occurred."
: message == ManageMessageId.AddPhoneSuccess ? "Your phone number was added."
: message == ManageMessageId.RemovePhoneSuccess ? "Your phone number was removed."
: "";
var userId = User.Identity.GetUserId();
var model = new IndexViewModel
{
HasPassword = HasPassword(),
PhoneNumber = await UserManager.GetPhoneNumberAsync(userId),
TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId),
Logins = await UserManager.GetLoginsAsync(userId),
BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId)
};
return(View(model));
}
public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
HRMDB objHRMEmp = new HRMDB();
//var data = (from x in objHRMEmp.AspNetUsers where x.Email == model.Email select x).SingleOrDefault();
var data1 = (from x in objHRMEmp.AspNetUsers where x.Email == model.Email select x).SingleOrDefault();
if (!ModelState.IsValid)
{
return(View(model));
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false);
string id = data1.Id;
if (data1.DepartmentId == "D4")
{
switch (result)
{
case SignInStatus.Success:
return(RedirectToAction("EmpAdmin", "Emp", new { id }));
//return RedirectToLocal(returnUrl);
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
else
{
switch (result)
{
case SignInStatus.Success:
return(RedirectToAction("Empty", "Emp", new { id }));
//return RedirectToAction("GetEmpByid", "Emp", new { id });
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
}
//
// GET: /Manage/ChangePassword
public ActionResult ChangePassword()
{
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
return(View());
}
public ActionResult Edit(string id)
{
var emp = objEmpBLL.UpdateEdit(id);
//Session["Empid"] = emp.Id;
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
return(View(emp));
}
public ActionResult GetTeamMemberes(string id)
{
id = Session["id"].ToString();
var team = objEmpBLL.GetTeamMembers(id);
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
return(View(team));
}
public ActionResult DetailsLeave(int id)
{
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
var leave = objLeaveBLL.Details(id);
return(View(leave));
}
public ActionResult Register()
{
HRMDB objHRMEmp = new HRMDB();
IEnumerable <SelectListItem> Dept = context.Depts.Select(p => new SelectListItem
{
Value = p.DepartmentId,
Text = p.DepartmentName
});
ViewData["YourData"] = Dept;
return(View());
//return View();
}
public ActionResult AddFinancialReference(string id)
{
HRMDB objHRMEmp = new HRMDB();
IEnumerable <SelectListItem> Dept = context.FinancialYearDetails.Select(p => new SelectListItem
{
Value = p.FinancialId,
Text = p.FYearName
});
ViewData["YourData"] = Dept;
return(View());
}
//Displaying all the Emplopye Leave Details With the Particular ID
public ActionResult GetLeaveById(string id)
{
HRMDB objHRMEmp = new HRMDB();
id = Session["id"].ToString();
//var data = (from x in objHRMEmp.AspNetUsers where x.Id == model.id select x).SingleOrDefault();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == id select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
var leavedetails = objLeaveBLL.GetLeaveById(id);
return(View(leavedetails));
}
public ActionResult CreateLeave()
{
HRMDB objHRMEmp = new HRMDB();
string ide = Session["id"].ToString();
var empdata = (from x in objHRMEmp.AspNetUsers where x.Id == ide select x).SingleOrDefault();
string Dept = empdata.DepartmentId;
ViewBag.deptid = Dept;
//HRMDB objHRMEmp = new HRMDB();
IEnumerable <SelectListItem> Dept1 = objHRMEmp.LeaveDescs.Select(p => new SelectListItem
{
Value = p.LeaveId.ToString(),
Text = p.Description
});
ViewData["YourData"] = Dept1;
return(View());
}
public ActionResult ExportLeaveData()
{
HRMDB objHRMEmp = new HRMDB();
GridView gv = new GridView();
gv.DataSource = objHRMEmp.LeaveDetails.ToList();
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=LeaveDetails.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index"));
}
public ActionResult demodetails(Demo obj)
{
Demo demonew = new Demo();
HRMDB objHRMEmp = new HRMDB();
var ddd = (from x in objHRMEmp.AttendanceDetails.Where(x => x.Id == obj.Id) select x).SingleOrDefault();
string i = ddd.financialId;
DateTime date = Convert.ToDateTime(DateTime.Now.Date.ToString());
DateTime joindate = Convert.ToDateTime(ddd.JoiningDate.ToString());
var data = (from x in objHRMEmp.FinancialYearDetails.Where(x => x.FinancialId == i) select x).SingleOrDefault();
int count = (from x in objHRMEmp.LeaveDetails where x.Status == true && x.Id == obj.Id select x).Count();
var username = (from x in objHRMEmp.AspNetUsers.Where(x => x.Id == obj.Id) select x).SingleOrDefault();
demonew.Id = username.UserName;
demonew.Totaldays = ddd.TotalDays;
demonew.Totalleaes = count.ToString();
int totatworking = int.Parse(demonew.Totaldays) - int.Parse(demonew.Totalleaes);
string totalworkingtilldate = date.Subtract(joindate).TotalDays.ToString();
int totalworkingtilldatewithleave = int.Parse(totalworkingtilldate) - int.Parse(demonew.Totalleaes);
demonew.Totalworkingdaystilldate = totalworkingtilldatewithleave.ToString();
demonew.Totalworkingdays = totatworking.ToString();
ViewData["Demo"] = demonew;
return(View());
}
public ActionResult AddFinancialReference(AttendanceDetail objAD)
{
HRMDB objHRMEmp = new HRMDB();
var data = (from x in objHRMEmp.FinancialYearDetails.Where(x => x.FinancialId == objAD.financialId) select x).SingleOrDefault();
int count = (from x in objHRMEmp.LeaveDetails where x.Status == true && x.Id == objAD.Id select x).Count();
DateTime enddate = Convert.ToDateTime(data.YearEnd);
DateTime joindate = Convert.ToDateTime(objAD.JoiningDate);
string nonworkingdays = data.NonWorkingDays;
string totaldays = enddate.Subtract(joindate).TotalDays.ToString();
int totaldaysafternonworkingdays = int.Parse(totaldays) - int.Parse(nonworkingdays);
string totalleaves = count.ToString();
int totalworkingdays = (totaldaysafternonworkingdays) - int.Parse(count.ToString());
DateTime currentdate = DateTime.Now;
string totalworkingdaystilldate = currentdate.Subtract(joindate).TotalDays.ToString();
objAD.Id = objAD.Id;
objAD.TotalDays = totaldaysafternonworkingdays.ToString();
objAD.TotalLeaves = totalleaves;
objAD.TotalWorkingDays = totalworkingdays.ToString();
objAD.TotalWorkingDaysTillDate = totalworkingdaystilldate;
objAD.financialId = data.FinancialId.ToString();
objEmpBLL.AddFinancialReference(objAD);
return(View());
}
