public void OnGet()
{
WorkDays = WorkDay.WorkDays.ToArray();
using (var cn = Data.GetConnection())
{
MyOrgSelect = new MyOrgSelect()
{
UserId = CurrentUser.UserId
}.ExecuteSelectList(cn, CurrentUser.OrganizationId);
ActivitySelect = new ActivitySelect()
{
OrgId = OrgId
}.ExecuteSelectList(cn, CurrentOrgUser.DefaultActivityId);
Responsibilities = new Responsibilities().Execute(cn);
TimeZoneSelect = new TimeZoneSelect().ExecuteSelectList(cn, CurrentUser.TimeZoneOffset);
AdjustForDaylightSaving = CurrentUser.AdjustForDaylightSaving;
}
OrgUser = CurrentOrgUser ?? new OrganizationUser()
{
UserId = CurrentUser.UserId,
OrganizationId = CurrentOrg.Id,
DisplayName = User.Identity.Name,
WorkDays = 62 // mon -> fri flag values
};
}
public bool this[Responsibilities responsibility]
{
get
{
return(_responsibilities.Contains(responsibility));
}
}
public IEnumerable <Responsibilities> GetAllResponsibilities()
{
var result = new List <Responsibilities>();
using (var connection = MSSQLdb.GetConnection())
{
SqlCommand cmd = new SqlCommand("GetAllResponsibilities", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var responsibilities = new Responsibilities
{
IDPosition = (int)reader["IDPosition"],
IDTask = (int)reader["IDTask"]
};
result.Add(responsibilities);
}
}
return(result);
}
private Responsibilities ReadResponsibilities(SqlDataReader reader)
{
Responsibilities responsibilities = new Responsibilities();
responsibilities.R_Description = reader["R_Description"].ToString();
return(responsibilities);
}
public IActionResult Delete([FromBody] Responsibilities ec)
{
try{
_responsibilitiesService.Delete(ec);
return(Ok(ec));
}
catch (AppException ex)
{
return(BadRequest(new { message = ex.Message }));
}
}
public IActionResult Update(int newProjNumVal, [FromBody] Responsibilities oldRes)
{
try{
Console.WriteLine($"The newProjNum:{newProjNumVal}");
_responsibilitiesService.Update(newProjNumVal, oldRes);
return(Ok(new { message = "Updated." }));
}
catch (AppException ex) {
return(BadRequest(new { message = ex.Message }));
}
}
public IActionResult Create([FromBody] Responsibilities ec)
{
try
{
var newResp = _responsibilitiesService.Create(ec);
return(Ok(newResp));
}
catch (AppException ex)
{
return(BadRequest(new { message = ex.Message }));
}
}
public ActionResult Create(Responsibilities model)
{
try
{
if (ModelState.IsValid)
{
Responsibilities record = new Responsibilities();
record.Name = model.Name;
record.Description = model.Description;
record.Code = model.Code;
var Skill_group = dbcontext.Responsibilities.Add(record);
dbcontext.SaveChanges();
//=================================check for alert==================================
var get_result_check = HR.Controllers.check.check_alert("responsibilites", HR.Models.user.Action.Create, HR.Models.user.type_field.form);
if (get_result_check != null)
{
var inbox = new Models.user.Alert_inbox {
send_from_user_id = User.Identity.Name, send_to_user_id = get_result_check.send_to_ID_user, title = get_result_check.Subject, Subject = get_result_check.Message
};
if (get_result_check.until != null)
{
if (get_result_check.until.Value.Year != 0001)
{
inbox.until = get_result_check.until;
}
}
ApplicationDbContext dbcontext = new ApplicationDbContext();
dbcontext.Alert_inbox.Add(inbox);
dbcontext.SaveChanges();
}
//===================================================================================
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
catch (DbUpdateException)
{
TempData["Message"] = HR.Resource.Basic.thiscodeIsalreadyexists;
return(View(model));
}
catch (Exception e)
{
return(View(model));
}
}
public static void AddResponsibility()
{
Console.WriteLine("Введите ID должности");
var idPosition = Console.ReadLine();
Console.WriteLine("Введите ID задачи");
var idTask = Console.ReadLine();
var currentinfo = new Responsibilities()
{
IDPosition = Int32.Parse(idPosition),
IDTask = Int32.Parse(idTask)
};
responsibilitiesLogic.AddResponsibility(currentinfo);
}
public ActionResult Create()
{
//////
var modell = new Responsibilities();
var stru = dbcontext.StructureModels.FirstOrDefault(m => m.All_Models == ChModels.Organization).Structure_Code;
var model = dbcontext.Responsibilities.ToList();
if (model.Count() == 0)
{
modell.Code = stru + "1";
}
else
{
modell.Code = stru + (model.LastOrDefault().ID + 1).ToString();
}
/////
return(View(modell));
}
public RoleType GetHighestResponsibility()
{
RoleType r = RoleType.None;
if (Responsibilities.Any(i => i.RoleType.Equals(RoleType.Staff)))
{
r = RoleType.Staff;
}
if (Responsibilities.Any(i => i.RoleType.Equals(RoleType.Nurse)))
{
r = RoleType.Nurse;
}
if (Responsibilities.Any(i => i.RoleType.Equals(RoleType.Doctor)))
{
r = RoleType.Doctor;
}
if (Responsibilities.Any(i => i.RoleType.Equals(RoleType.SystemAdmin)))
{
r = RoleType.SystemAdmin;
}
return(r);
}
//private string connnectionString = "Data Source=DESKTOP-EMEUIMH\\SQLEXPRESS; Initial Catalog = Company; Integrated Security = True";
public int AddResponsibility(Responsibilities value)
{
using (var connection = MSSQLdb.GetConnection())
{
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "AddResponsibility";
cmd.Parameters.Add(new SqlParameter("@IDPosition", value.IDPosition));
cmd.Parameters.Add(new SqlParameter("@IDTask", value.IDTask));
connection.Open();
Object tmp = cmd.ExecuteScalar();
if (tmp == null)
{
return(-1);
}
return((int)tmp);
//return (int)cmd.ExecuteScalar();
}
}
public virtual void AssignTo(Responsibility responsibility)
{
responsibility.Task = this;
Responsibilities.Add(responsibility);
}
public bool HasAccessTo(Responsibilities responsibility)
{
return(_role[responsibility]);
}
public int AddResponsibility(Responsibilities value)
{
return(this.responsibilitiesDao.AddResponsibility(value));
}
