public Userdetails GetUserDetailByName(string userName) { try { tbl_EmpDetails userdetailsOB = null; userdetailsOB = (from e in _dbContext.tbl_EmpDetails where e.UserName == userName select e ).FirstOrDefault(); if (userdetailsOB != null) { tbl_Department dept = (from d in _dbContext.tbl_Departments where d.ID == userdetailsOB.DeptId select d).FirstOrDefault(); userdetailsOB.Department = dept; } Userdetails userDetail = null; userDetail = _employeeDetailsMapper.GetUserDetilsFromTbl_EmpDetailsOB(userdetailsOB); return(userDetail); } catch (Exception ex) { return(null); } }
public ActionResult Insert(FormCollection f) { string msg; try { DepartmentEntities OE = new DepartmentEntities(); tbl_Department D = new tbl_Department(); D.D_Name = f["DName"].ToString(); D.HOD = f["HOD"].ToString(); OE.tbl_Department.Add(D); OE.SaveChanges(); msg = "Record is Inserted"; } catch { msg = "Record not inserted"; } TempData["msg"] = msg; TempData.Keep();//or TempData.Keep("msg") for a particular msg to be kept in temp data return(RedirectToAction("Index")); }
public ActionResult DeleteDepartment(tbl_Level DelLevel) { if (Session["Admin_Id"] == null || Session["Admin_Name"] == null) { return(RedirectToAction("AdminLogin", "Home")); } else { try { int id = (int)TempData["DepartmentId"]; tbl_Department Dep = db.tbl_Department.Find(id); db.tbl_Department.Remove(Dep); db.SaveChanges(); return(RedirectToAction("DepartmentsManagement")); } catch { ViewBag.msg = "يوجد طلبة في هذا القسم"; } } return(View()); }
public string SaveDepartment(DepartmentModel model) { tbl_Department tb = new tbl_Department(); var duplicate = _entities.tbl_Department.Where(o => o.Department.Equals(model.Department) && o.Active.Equals(model.Active)).SingleOrDefault(); if (duplicate == null) { try { if (model.DepartmentId != 0) { tb = _entities.tbl_Department.Where(x => x.DepartmentID == model.DepartmentId).SingleOrDefault(); tb.Department = model.Department; tb.Active = model.Active; _entities.SaveChanges(); return("Record Updated Successfully..."); } else { tb.Department = model.Department; tb.Active = model.Active; _entities.tbl_Department.Add(tb); _entities.SaveChanges(); return("Record Saved Successfully..."); } } catch { return("something Wrong try Agian !"); } } else { return(model.Department + "Already Exits"); } }
public HttpResponseMessage Post(tbl_Department departman) { try { using (var db = new HastaneDBEntities()) { tbl_Department Departman = db.tbl_Department.FirstOrDefault(x => x.DepartmentName == departman.DepartmentName); if (Departman != null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu departman bulunmakta")); } else { db.tbl_Department.Add(departman); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, departman)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }