public ActionResult AddGoals(EmployeeGoalsViewModel objGoals) { try { objGoals.objEmpGoals.dtStartdate = DateTime.Now; objGoals.objEmpGoals.varCompletion = objGoals.completion; objGoals.objEmpGoals.dtCreatedOn = DateTime.Now; db.tblEmployeeGoals.Add(objGoals.objEmpGoals); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } return RedirectToAction("AddGoals"); }
public ActionResult Client(tblClientDetail objClientDetails) { objClientDetails.dtCreatedOn = DateTime.Now; db.tblClientDetails.Add(objClientDetails); db.SaveChanges(); return(RedirectToAction("Client")); }
public ActionResult AddProject(ProjectViewModel objProjectViewModel) { try { int clientID = 0; var ClientTeamId = from data in db.tblClientTeams where data.varClientTeamMemName == objProjectViewModel.strExtClientHead select new { ID = data.intClientTeamID }; foreach (var i in ClientTeamId) { clientID = i.ID; } int[] empId = objProjectViewModel.EmployeeID; string selEmpId = String.Join(",", empId); //if (clientID == 0) //{ // tblClientTeam tc = new tblClientTeam(); // tc.varClientTeamMemName = objProjectViewModel.strExtClientHead; // tc.intActive = true; // tc.dtCreatedOn = DateTime.Now; // tc.varClientTeamMemEmail = objProjectViewModel.strExtClientEmailID; // db.tblClientTeams.Add(tc); // db.SaveChanges(); // clientID = tc.intClientTeamID; //} objProjectViewModel.objProjectDetails.varTeamMemDetails = selEmpId; objProjectViewModel.objProjectDetails.dtCreatedOn = DateTime.Now; objProjectViewModel.objProjectDetails.varClientProjectHead = clientID.ToString(); db.tblProjectDetails.Add(objProjectViewModel.objProjectDetails); db.SaveChanges(); } catch (Exception ex) { string msg = ex.Message; } return(RedirectToAction("AddProject")); }
public ActionResult CreateEmployee(LoginViewModel objtlogin, int[] AccessId) { string accesslevels = ""; try { //string accesslevels = string.Join(",", AccessId); foreach (var item in objtlogin.access) { if (item.IsActive == true) { int accid = item.intAccessID; // string str=string.Join(",", accid); accesslevels = accesslevels + ',' + accid; } } accesslevels = accesslevels.Remove(0, 1); string strOfficialEmailId = objtlogin.objtblLogin.tblEmployee.varOfficeEmailAdd; string strUserName = objtlogin.objtblLogin.varLoginName; string strPassword = objtlogin.objtblLogin.varPassword; objtlogin.objtblLogin.tblEmployee.varAccessLevel = accesslevels; objtlogin.objtblLogin.varLoginName = strOfficialEmailId; objtlogin.objtblLogin.IsActive = true; db.tblLogins.Add(objtlogin.objtblLogin); //------------------- Checkbox StringBuilder sb = new StringBuilder(); sb.Append(" ").AppendLine(); foreach (var item in objtlogin.access) { if (item.IsActive == true) { sb.Append(item.intAccessID + ", ").AppendLine(); } } ViewBag.Country = sb.ToString(); // ---------------------- checkbox db.SaveChanges(); sendMail(strOfficialEmailId, strPassword); ViewBag.Message = "Data has been submitted successfully!!."; } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Class: {0}, Property: {1}, Error: {2}", validationErrors.Entry.Entity.GetType().FullName, validationError.PropertyName, validationError.ErrorMessage); } } throw; // You can also choose to handle the exception here... } return(RedirectToAction("CreateEmployee")); }