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));
}
}
