public ActionResult ManagePatientList()
{
List <Patient> lstPatients = new List <Patient>();
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
//the UI grid would allow filter by firstname & lastname and not from the DB
CommonStatus cs = cls.GetPatients("", "", base.GetLoggedinUserID());
if (cs != null && cs.OpStatus)
{
if (cs.OpPayload != null && ((List <Patient>)cs.OpPayload).Count() > 0)
{
lstPatients.AddRange(((List <Patient>)cs.OpPayload).OrderByDescending(a => a.DisplayDate).ToList());
}
}
else
{
ModelState.AddModelError(string.Empty, "An error occured");
}
}
catch (Exception ex)
{
}
finally
{
cls = null;
}
return(PartialView(lstPatients));
}
public ActionResult Editrx(int PatientID, int RxDataID)
{
RxViewModel p = new RxViewModel();
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
CommonStatus cs = cls.GetRxData(RxDataID, base.GetLoggedinUserID());
if (cs != null && cs.OpStatus)
{
RxData input = (RxData)cs.OpPayload;
p.RxDataID = input.RxData_ID;
p.rxDate = input.RxDate;
p.rxDoctor = input.RxDoctor;
p.Prescription1 = input.Prescription1;
p.Prescription2 = input.Prescription2;
p.Prescription3 = input.Prescription3;
p.Prescription4 = input.Prescription4;
p.Prescription5 = input.Prescription5;
}
}
catch (Exception ex)
{
}
finally
{
cls = null;
}
return(PartialView(p));
}
public CommonStatus VerifyLoginUser(string UserName, string Password)
{
//password has been already hashed using MD5 in upper layers.
CommonStatus cs = new CommonStatus(false);
PortalUser user = null;
try
{
using (PatientPortalEntities ent = new PatientPortalEntities())
{
var u = (from p in ent.TB_PortalUser where p.UserName == UserName && p.HashedPassword == Password && p.IsActive == true select p).FirstOrDefault();
if (u != null)
{
user = new PortalUser();
user.PortalUser_ID = u.PortalUser_ID;
user.UserName = u.UserName;
user.DisplayName = u.DisplayName;
user.HashedPassword = u.HashedPassword;
}
cs.Set(true, "", user);
}
}
catch (Exception ex)
{
cs.Set(false, ex.Message, null);
}
return(cs);
}
public ActionResult EditPatient(int PatientID)
{
PatientViewModel model = new PatientViewModel();
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
CommonStatus cs = cls.GetPatient(PatientID, base.GetLoggedinUserID());
if (cs != null && cs.OpStatus)
{
Patient p = (Patient)cs.OpPayload;
model.PatientID = p.Patient_ID;
model.First_Name = p.First_Name;
model.Last_Name = p.Last_Name;
model.DateOfBirth = p.DateOfBirth;
model.PhoneNumber = p.PhoneNumber;
}
}
catch (Exception ex)
{
}
finally
{
cls = null;
}
ViewBag.FirstName = model.First_Name;
ViewBag.LastName = model.Last_Name;
return(PartialView(model));
}
public async Task <List <T> > BatchStatusAsync(string ids, CommonStatus status, Action <T> batchStatusWork, bool isSave = true)
{
if (string.IsNullOrEmpty(ids))
{
return(null);
}
var idList = StringUtility.ConvertToBigIntArray(ids, ',');
if (idList == null || !idList.Any())
{
return(null);
}
var list = await QueryUnDelete().Where(d => idList.Contains(d.Id)).ToListAsync();
if (list == null || !list.Any())
{
return(null);
}
foreach (var item in list)
{
RemoveCache(item);
item.CommonStatus = status;
}
if (isSave)
{
await SaveChangesAsync();
}
return(list);
}
public CommonStatus GetPatient(int PatientID, int LoggedInuserID)
{
CommonStatus cs = new CommonStatus(false);
try
{
using (PatientPortalEntities ent = new PatientPortalEntities())
{
var pts = (from p in ent.TB_Patient where p.Patient_ID == PatientID select p).FirstOrDefault();
if (pts != null)
{
Patient p = new Patient();
p.Patient_ID = pts.Patient_ID;
p.First_Name = pts.First_Name;
p.Last_Name = pts.Last_Name;
p.DateOfBirth = pts.DateOfBirth;
p.PhoneNumber = pts.PhoneNumber;
p.UpdatedOn = pts.UpdateDate;
p.CreateDate = pts.CreateDate;
cs.Set(true, "", p);
}
}
}
catch (Exception ex)
{
cs.Set(false, ex.Message, null);
}
return(cs);
}
public static void UpdateClientStatusBatch(IEnumerable <int> sysNos, CommonStatus status)
{
if (sysNos == null || sysNos.Count() == 0)
{
throw new BusinessException("请传入要批量操作的数据编号");
}
ClientDA.UpdateClientStatusBatch(sysNos, status);
}
public async Task <int> UpdateStatusAsync(string id, CommonStatus status)
{
return(await Connection.UpdateAsync(new TDatabase
{
Id = id,
Status = (byte)status
}, new[] { nameof(TDatabase.Status) }, Trans));
}
public void Add(string code, string name, string parentId)
{
Id = ObjectId.GenerateNewId().ToString();
Code = code;
Name = name;
ParentId = parentId;
Status = CommonStatus.Normal;
}
/// <summary>
/// 批量修改Client状态
/// </summary>
public static void UpdateClientStatusBatch(IEnumerable <int> sysNos, CommonStatus status)
{
DataCommand cmd = new DataCommand("UpdateClientStatusBatch");
cmd.SetParameter("@CommonStatus", DbType.Int32, status);
cmd.CommandText = cmd.CommandText.Replace("#BatchSysNo#", string.Join(",", from s in sysNos select s.ToString()));
cmd.ExecuteNonQuery();
}
/// <summary>
/// 修改角色状态
/// </summary>
/// <param name="rid"></param>
/// <param name="status"></param>
/// <returns></returns>
public Task <Resp> UpdateStatus(long rid, CommonStatus status)
{
var cacheKey = string.Concat(CacheKeys.Perm_Role_ById, rid);
return(Update(u => new { u.status },
u => u.id == rid,
new{ status })
.WithCacheClear(cacheKey));
}
public ActionResult login(LoginViewModel model)
{
if (ModelState.IsValid)
{
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
string userName = model.UserName;
string password = model.Password;
CommonStatus cs = cls.VerifyLoginUser(userName, Utilities.PatientRxPortal.Helper.CreateMD5(password));
if (cs != null && cs.OpStatus)
{
PortalUser u = (PortalUser)cs.OpPayload;
var claims = new List <Claim>();
claims.Add(new Claim(ClaimTypes.NameIdentifier, userName));
claims.Add(new Claim(ClaimTypes.Name, u.DisplayName));
claims.Add(new Claim(ClaimTypes.GivenName, u.DisplayName));
claims.Add(new Claim("UserID", u.PortalUser_ID.ToString()));
claims.Add(new Claim(ClaimTypes.Hash, u.HashedPassword));
var claimIdenties = new ClaimsIdentity(claims, DefaultAuthenticationTypes.ApplicationCookie);
var ctx = Request.GetOwinContext();
var authenticationManager = ctx.Authentication;
authenticationManager.SignIn(new AuthenticationProperties()
{
IsPersistent = false
}, claimIdenties);
return(RedirectToAction("ManagePatients", "Home"));
}
else
{
ModelState.AddModelError(string.Empty, "Invalid user-name or password");
}
}
catch (Exception ex)
{
}
finally
{
cls = null;
}
return(View());
}
return(View());
}
/// <summary>
/// 通过状态加载Role信息
/// </summary>
public static List <Role> LoadRoleByCommonStatus(CommonStatus CommonStatus, string ApplicationID)
{
DataCommand cmd = new DataCommand("LoadRoleByCommonStatus");
cmd.SetParameter("@CommonStatus", DbType.Int32, CommonStatus);
cmd.SetParameter("@ApplicationID", DbType.String, ApplicationID);
List <Role> list = cmd.ExecuteEntityList <Role>();
return(list);
}
public static void UpdateSystemUserStatusBatch(IEnumerable <int> sysNos, CommonStatus status, CurrentUser current)
{
DataCommand cmd = new DataCommand("UpdateSystemUserStatusBatch");
cmd.SetParameter("@Status", DbType.Int32, status);
cmd.SetParameter("@EditUserSysNo", DbType.Int32, current.UserSysNo);
cmd.SetParameter("@EditUserName", DbType.String, current.UserDisplayName);
cmd.CommandText = cmd.CommandText.Replace("#BatchSysNo#", string.Join(",", from s in sysNos select s.ToString()));
cmd.ExecuteNonQuery();
}
protected CommonStatus GetErrors(string elementPath, string strTransferId, string elementPath2)
{
CommonStatus status = new CommonStatus();
status.AlertCode = "-1";
status.AlertMessage = string.Format("{0}\\n{1}", commonCulture.ElementValues.getResourceXPathString(PaymentType.ToString() + elementPath, xeErrors), commonCulture.ElementValues.getResourceXPathString(PaymentType.ToString() + "/error" + strTransferId, xeErrors));
status.IsProcessAbort = true;
return(status);
}
protected CommonStatus GetErrors(string elementPath)
{
CommonStatus status = new CommonStatus();
status.AlertCode = "-1";
status.AlertMessage = commonCulture.ElementValues.getResourceXPathString(PaymentType.ToString() + elementPath, xeErrors);
status.IsProcessAbort = true;
return(status);
}
public JsonResult UpdateUserStatus(int userId, CommonStatus status)
{
// 更改用户状态启用/禁用/删除
UserService.UpdateUserStatus(new UserEntity()
{
Id = userId,
CommonStatus = status
}, AuthManager.ReadUserInfo());
return(Json(this.Ok(true)));
}
public async Task <bool> SetStatus([FromForm] int id, [FromForm] CommonStatus status)
{
var item = await dbContext.News.FirstOrDefaultAsync(m => m.Id == id);
if (item == null)
{
throw new ApiException(HttpResultCode.数据不存在);
}
item.Status = (int)status;
return(await dbContext.SaveChangesAsync() > 0);
}
public void UpdateSystemUserStatusBatch(IEnumerable <int> sysNos, CommonStatus status, CurrentUser current)
{
if (sysNos == null || sysNos.Count() == 0)
{
throw new BusinessException("请传入要批量操作的编号");
}
if (sysNos.Any(x => x == 1))
{
throw new BusinessException("传入的要批量操作的用户中含有编号为1的超级用户,不能执行");
}
SystemUserDA.UpdateSystemUserStatusBatch(sysNos, status, current);
}
public void UpdateRoleStatusBatch(IEnumerable <int> sysNos, CommonStatus status)
{
if (sysNos == null || sysNos.Count() == 0)
{
throw new BusinessException("请传入要批量操作的编号");
}
if (sysNos.Any(x => x == 1))
{
throw new BusinessException("传入的要批量操作的角色中含有超级管理员,不能执行");
}
RoleDA.UpdateRoleStatusBatch(sysNos, status);
}
public ActionResult EditRx(int PatientID, RxViewModel input)
{
string status = string.Empty;
string message = string.Empty;
if (ModelState.IsValid)
{
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
RxData p = new RxData();
p.RxData_ID = input.RxDataID;
p.RxDate = input.rxDate;
p.RxDoctor = input.rxDoctor;
p.Prescription1 = input.Prescription1;
p.Prescription2 = input.Prescription2;
p.Prescription3 = input.Prescription3;
p.Prescription4 = input.Prescription4;
p.Prescription5 = input.Prescription5;
CommonStatus cs = cls.AddUpdatePatientRxData(PatientID, p, base.GetLoggedinUserID());
if (cs != null && cs.OpStatus)
{
status = "OK"; message = "";
}
else
{
status = "ERROR"; message = cs.OpMessage;
}
}
catch (Exception ex)
{
status = "ERROR";
message = ex.Message;
}
finally
{
cls = null;
}
}
var jsonData = new
{
status = status,
message = message
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public static string ToName(this CommonStatus commonStatus)
{
var name = string.Empty;
switch (commonStatus)
{
case CommonStatus.False:
name = "否"; break;
case CommonStatus.True:
name = "是"; break;
}
return(name);
}
public void Edit(string name,
string departmentId,
string phone,
string email,
CommonStatus status = CommonStatus.Normal)
{
Name = name;
DepartmentId = departmentId;
Phone = phone;
Email = email;
Status = status;
IsAdmin = false;
ModifiedTime = DateTime.Now;
}
public void Add(string name,
string departmentId,
string phone = "",
string email = "",
CommonStatus status = CommonStatus.Normal)
{
Id = ObjectId.GenerateNewId().ToString();
Name = name;
DepartmentId = departmentId;
Phone = phone;
Email = email;
Status = status;
IsAdmin = false;
}
public ActionResult AddNewPatient(PatientViewModel input)
{
string status = string.Empty;
string message = string.Empty;
if (ModelState.IsValid)
{
DataService.Patientportal.PatientPortalService cls = new DataService.Patientportal.PatientPortalService();
try
{
Patient p = new Patient();
p.First_Name = input.First_Name;
p.Last_Name = input.Last_Name;
p.DateOfBirth = Convert.ToDateTime(input.DateOfBirth);
p.PhoneNumber = input.PhoneNumber;
p.Patient_ID = 0;
CommonStatus cs = cls.AddUpdatePatient(p, base.GetLoggedinUserID());
if (cs != null && cs.OpStatus)
{
status = "OK"; message = "";
}
else
{
status = "ERROR"; message = cs.OpMessage;
}
}
catch (Exception ex)
{
status = "ERROR";
message = ex.Message;
}
finally
{
cls = null;
}
}
var jsonData = new
{
status = status,
message = message
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateSystemUserStatus(string customerSysNos, CommonStatus status)
{
var sysnolist = JsonConvert.DeserializeObject <List <int> >(customerSysNos);
if (sysnolist.Count == 0)
{
throw new BusinessException("请勾选账号后再操作");
}
if (status == CommonStatus.Deleted)
{
throw new BusinessException("传入状态不正确!请刷新重试!");
}
var cuslist = user_service.QuerySystemUserListBySysNos(sysnolist, ConstValue.ApplicationID);
if (CurrUser.MasterSysNo.GetValueOrDefault() > 0)
{
cuslist = cuslist.Where(e => e.MasterSysNo == CurrUser.MasterSysNo.Value).ToList();
}
AjaxResult result = new AjaxResult();
if (status == CommonStatus.Actived)
{
cuslist = cuslist.Where(e => e.CommonStatus == CommonStatus.DeActived).ToList();
}
if (status == CommonStatus.DeActived)
{
cuslist = cuslist.Where(e => e.CommonStatus == CommonStatus.Actived).ToList();
}
if (cuslist.Count == 0)
{
if (status == CommonStatus.Actived)
{
throw new BusinessException("选择的账号已是启用状态!请重新勾选后再试!");
}
if (status == CommonStatus.DeActived)
{
throw new BusinessException("选择的账号已是禁用状态!请重新勾选后再试!");
}
}
var sysnos = cuslist.Select(e => e.SysNo).ToList();
user_service.UpdateSystemUserStatusBatch(sysnos, status, CurrUser);
return(Json(new AjaxResult {
Success = true, Data = sysnos.Count
}));
}
public static string Type2Text(CommonStatus value)
{
switch (value)
{
case CommonStatus.New: return(Languages.Libs.GetString("newStat"));
case CommonStatus.Enable: return(Languages.Libs.GetString("enableStat"));
case CommonStatus.Disable: return(Languages.Libs.GetString("disableStat"));
case CommonStatus.Close: return(Languages.Libs.GetString("closeStat"));
case CommonStatus.Ignore: return(Languages.Libs.GetString("ignoreStat"));
default: return("N/A");
}
}
public CommonStatus GetAllPatientRxs(int patientID, int LoggedInuserID)
{
CommonStatus cs = new CommonStatus(false);
try
{
using (PatientPortalEntities ent = new PatientPortalEntities())
{
List <RxData> allPatientRxs = new List <RxData>();
var rxs = from prd in ent.TB_PatientRxData
join rd in ent.TB_RxData on prd.RxData_ID equals rd.RxData_ID
where (prd.Patient_ID == patientID)
select rd;
if (rxs != null && rxs.FirstOrDefault() != null)
{
foreach (TB_RxData r in rxs)
{
RxData d = new RxData();
d.RxData_ID = r.RxData_ID;
d.RxDate = r.RxDate;
d.RxDoctor = r.RxDoctor;
d.Prescription1 = r.Prescription1;
d.Prescription2 = r.Prescription2;
d.Prescription3 = r.Prescription3;
d.Prescription4 = r.Prescription4;
d.Prescription5 = r.Prescription5;
d.CreateDate = r.CreateDate;
d.UpdatedOn = r.UpdateDate;
allPatientRxs.Add(d);
}
cs.Set(true, "", allPatientRxs);
}
}
}
catch (Exception ex)
{
cs.Set(false, ex.Message, null);
}
return(cs);
}
public CommonStatus VerifyLoginUser(string UserName, string Password)
{
ProcessData p = new ProcessData();
CommonStatus cs = new CommonStatus(false);
try
{
cs = p.VerifyLoginUser(UserName, Password);
}
catch (Exception ex)
{
cs.Set(false, ex.Message, null);
}
finally
{
p = null;
}
return(cs);
}
public CommonStatus GetAllPatientRxs(int patientID, int LoggedInuserID)
{
ProcessData p = new ProcessData();
CommonStatus cs = new CommonStatus(false);
try
{
cs = p.GetAllPatientRxs(patientID, LoggedInuserID);
}
catch (Exception ex)
{
cs.Set(false, ex.Message, null);
}
finally
{
p = null;
}
return(cs);
}
public static string Type2Text(CommonStatus value)
{
switch (value)
{
case CommonStatus.New: return Languages.Libs.GetString("newStat");
case CommonStatus.Enable: return Languages.Libs.GetString("enableStat");
case CommonStatus.Disable: return Languages.Libs.GetString("disableStat");
case CommonStatus.Close: return Languages.Libs.GetString("closeStat");
case CommonStatus.Ignore: return Languages.Libs.GetString("ignoreStat");
default: return "N/A";
}
}
