public void Remove(int id)
{
UserReportingHierarchy UserReportingHierarchy = db.UserReportingHierarchy.Find(id);
db.UserReportingHierarchy.Remove(UserReportingHierarchy);
db.SaveChanges();
}
public Result deleteEmployeeReportingHirarchy(int urh_id)
{
Result result = new Result();
User user = getCurrentUser();
if (user != null)
{
UserReportingHierarchy userReportingHeirarchy = iuserReportingHierarchy.GetUserReportingHierarchy(urh_id);
if (userReportingHeirarchy != null)
{
iuserReportingHierarchy.Remove(urh_id);
result.Message = "Success";
}
else
{
result.Message = "Data Not Found!!!";
}
}
else
{
result.Message = "Session Expired !! Please Reload Page!!!";
}
return(result);
}
public DbResult addUserReportingHierarchy(UserReportingHierarchy userReportingHierarchy)
{
var urh_u_id = new SqlParameter("urh_u_id", userReportingHierarchy.urh_u_id + "");
var urh_reporting_to = new SqlParameter("urh_reporting_to", userReportingHierarchy.urh_reporting_to + "");
var urh_priority = new SqlParameter("urh_priority", userReportingHierarchy.urh_priority + "");
var urh_cre_by = new SqlParameter("urh_cre_by", userReportingHierarchy.urh_cre_by + "");
var result = db.DbResult.FromSqlRaw <DbResult>
("EXECUTE dbo.addUserReportingHierarchy @urh_u_id,@urh_reporting_to,@urh_priority,@urh_cre_by",
urh_u_id, urh_reporting_to, urh_priority, urh_cre_by).ToList().FirstOrDefault();
return(result);
}
public DbResult AddUserReportingHeirarchy(UserReportingHierarchy userReportingHierarchy)
{
DbResult result = new DbResult();
User user = getCurrentUser();
if (user != null)
{
result = iuserReportingHierarchy.addUserReportingHierarchy(userReportingHierarchy);
}
else
{
result.Message = "Session Expired !! Please reload Page !!";
}
return(result);
}
public ActionResult getUserReportingHeirarchy(UserReportingHierarchy userReportingHierarchy)
{
User user = getCurrentUser();
IEnumerable <List_UserReportingHierarchy> list_UserReportingHierarchies = Enumerable.Empty <List_UserReportingHierarchy>();
if (user != null)
{
list_UserReportingHierarchies = iuserReportingHierarchy.GetUserReportingHierarchysByuser(userReportingHierarchy);
}
else
{
ViewBag.Message = "Session Expired !! Please reload Page !!";
}
return(View(list_UserReportingHierarchies));
}
public void Update(UserReportingHierarchy UserReportingHierarchy)
{
db.Update(UserReportingHierarchy);
db.SaveChanges();
}
public IEnumerable <List_UserReportingHierarchy> GetUserReportingHierarchysByuser(UserReportingHierarchy userReportingHierarchy)
{
var urh_u_id = new SqlParameter("urh_u_id", userReportingHierarchy.urh_u_id + "");
var urh_reporting_to = new SqlParameter("urh_reporting_to", userReportingHierarchy.urh_reporting_to + "");
var urh_priority = new SqlParameter("urh_priority", userReportingHierarchy.urh_priority + "");
var pellets = db.List_UserReportingHierarchy.FromSqlRaw <List_UserReportingHierarchy>("EXECUTE dbo.GetUserReportingHierarchysByuser @urh_u_id,@urh_reporting_to,@urh_priority",
urh_u_id, urh_reporting_to, urh_priority).ToList();
return(pellets);
}
public UserReportingHierarchy GetUserReportingHierarchy(int id)
{
UserReportingHierarchy UserReportingHierarchys = db.UserReportingHierarchy.Find(id);
return(UserReportingHierarchys);
}
public void Add(UserReportingHierarchy UserReportingHierarchy)
{
throw new NotImplementedException();
}