public HttpResponseMessage GetReasons(string reason)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,ReasonController,GetReasons,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
if (!string.IsNullOrEmpty(reason))
{
reason = reason.Replace(" ", "");
}
ReasonType reasonType;
Enum.TryParse(reason, true, out reasonType);
var reasons = _reasonManager.GetReasons(reasonType);
var reasonName = _reasonManager.GetReasonType(reasonType);
_performancelog.Debug($"End,ReasonController,GetReasons,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
var response = new ReasonModel
{
ReasonTitle = reasonName,
Reasons = reasons.Select(r => new Reason
{
Code = r.Reason,
Description = r.Description
}).ToList()
};
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public ActionResult Upload()
{
var model = new ReasonModel();
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
return(View(model));
}
protected override async Task SaveAsync()
{
try
{
var typeManifestation = View.TypeManifestation;
var shortName = View.ShortName;
var fullName = View.FullName;
var additionally = View.Additionally;
if (string.IsNullOrWhiteSpace(shortName))
{
throw new ArgumentNullException(null, "Вы не ввели краткое наименование причины обращения заказчика!");
}
if (string.IsNullOrWhiteSpace(typeManifestation))
{
throw new ArgumentNullException(null, "Вы не выбрали тип проявления!");
}
using (var context = new DbSSContext())
{
if (Identifier != null)
{
await context.Reason.Where(r => r.ID == (Guid)Identifier).UpdateAsync(r => new ReasonModel
{
Type = typeManifestation,
ShortName = shortName,
FullName = GetNullValue(fullName),
Additionally = GetNullValue(additionally)
});
}
else
{
ReasonModel insertReasonInfo = new ReasonModel
{
ID = ConsistentGuid.CreateGuid(),
Type = typeManifestation,
ShortName = shortName,
FullName = GetNullValue(fullName),
Additionally = GetNullValue(additionally)
};
context.Reason.Add(insertReasonInfo);
await context.SaveChangesAsync();
Identifier = insertReasonInfo.ID;
}
}
View.Close();
}
catch (Exception ex)
{
ShowError(ex.Message);
}
}
public ActionResult Upload(ReasonModel Model)
{
if (ModelState.IsValid)
{
foreach (var data in Model.Details)
{
try
{
data.CreatedDate = DateTime.Now;
data.CreatedBy = CurrentUser.USERNAME;
data.ModifiedDate = null;
data.IsActive = true;
if (data.ErrorMessage == "" | data.ErrorMessage == null)
{
var Exist = _rasonBLL.GetReason().Where(x => (x.Reason == null ? "" : x.Reason.ToUpper()) == (data.Reason == null ? "" : data.Reason.ToUpper()) &&
x.DocumentType == data.DocumentType &&
(x.VehicleType == null ? "" : x.VehicleType.ToUpper()) == (data.VehicleType == null ? "" : data.VehicleType.ToUpper()) &&
x.IsActive).FirstOrDefault();
if (Exist != null)
{
Exist.IsActive = false;
Exist.ModifiedBy = "SYSTEM";
Exist.ModifiedDate = DateTime.Now;
_rasonBLL.save(Exist);
}
var dto = Mapper.Map <ReasonDto>(data);
_rasonBLL.save(dto);
}
AddMessageInfo(Constans.SubmitMessage.Saved, Enums.MessageInfoType.Success);
}
catch (Exception exception)
{
Model.MainMenu = _mainMenu;
Model.CurrentLogin = CurrentUser;
Model.ErrorMessage = exception.Message;
return(View(Model));
}
}
try
{
_rasonBLL.SaveCanges();
}
catch (Exception exp)
{
Model.MainMenu = _mainMenu;
Model.CurrentLogin = CurrentUser;
Model.ErrorMessage = exp.Message;
return(View(Model));
}
}
return(RedirectToAction("Index", "MstReason"));
}
public ActionResult Index()
{
var data = _rasonBLL.GetReason();
var model = new ReasonModel();
model.Details = Mapper.Map <List <ReasonItem> >(data);
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model.CurrentPageAccess = CurrentPageAccess;
return(View(model));
}
/// <summary>
/// 删
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public bool DeleteReasonCode(ReasonModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from ReasonCode where 1=1 ");
sb.Append("and rid=@rid ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@rid", model.id));
int res = Base.SQLServerHelper.ExecuteSql(sb.ToString(), pms.ToArray());
return(res > 0);
}
public IActionResult GetReasons()
{
string errorString = null;
try
{
ReasonModel reasonModel = new ReasonModel();
List <Reason> obj = reasonModel.GetAllReasons(out errorString);
return(new JsonResult(obj));
}
catch (Exception e)
{
return(Ok(e + "\n" + errorString));
}
}
public ActionResult PMCReceipientVerify(PMCReceipientVerificationModel obj)
{
if (TempData["PMCReceipientVerificationModels"] != null && obj != null)
{
List <PMCReceipientVerificationModel> tempLstData = (List <PMCReceipientVerificationModel>)TempData["PMCReceipientVerificationModels"];
PMCReceipientVerificationModel tempData = tempLstData.Where(w => w.PickRawMtrlFKId == obj.PickRawMtrlFKId).FirstOrDefault();
tempData.RejQty = obj.RejQty;
tempData.ReasonCode = obj.ReasonCode;
//Tsen req to insert ReasonDec in the email subject : FW:Rejected Material Transaction
if (!string.IsNullOrEmpty(obj.ReasonCode))
{
ReasonModel tempReasonTypes = tempData.ReasonTypes.Where(w => w.ReasonCode == obj.ReasonCode).FirstOrDefault();
tempData.ReasonDesc = tempReasonTypes.ReasonDesc;
}
HttpResponseMessage response = GlobalVariables.WebApiClient.PostAsJsonAsync("ProdPMCReceipientVerify", tempData).Result;
if (response.IsSuccessStatusCode)
{
if (obj.RejQty <= 0)
{
//No need status if success
//ViewBag.Status = "Inserted Sucessfully!";
ViewBag.Status = "Success";
}
else
{
return(Json(new { success = true, responseText = "Inserted Sucessfully!" }, JsonRequestBehavior.AllowGet));
}
}
else
{
string msgJson = response.Content.ReadAsStringAsync().Result;
JObject jObject = JObject.Parse(msgJson);
string msg = (string)jObject.SelectToken("Message");
string msgDtl = (string)jObject.SelectToken("MessageDetail");
if (obj.RejQty <= 0)
{
ViewBag.Status = msg + "\n" + msgDtl;
}
else
{
return(Json(new { sucess = false, responseText = msg + "\n" + msgDtl }, JsonRequestBehavior.AllowGet));
}
//throw new Exception(msgDtl);
}
}
return(View(obj));
}
internal override Task <object> GetInfo()
{
object result = null;
var item = Item;
result = new ReasonModel
{
ID = item.ID,
ShortName = item.ShortName,
FullName = item.FullName,
Type = item.Type
};
return(Task.FromResult(result));
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public ReasonModel GetReasonCodeInfo(ReasonModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from ReasonCode where 1=1 ");
sb.Append("and id=@id ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@id", model.id));
DataSet ds = Base.SQLServerHelper.Query(sb.ToString(), pms.ToArray());
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
return(new ReasonModel(ds.Tables[0].Rows[0]));
}
/// <summary>
/// 改
/// </summary>
/// <param name="model">model to be updated</param>
/// <returns></returns>
public bool UpdateReasonCode(ReasonModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("update ReasonCode set ");
sb.Append("reason=@reason, reasondesc=@reasondesc ");
sb.Append("where 1=1 ");
sb.Append("and id=@id ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@reason", model.reason));
pms.Add(new SqlParameter("@reasondesc", model.ReasonDesc));
pms.Add(new SqlParameter("@id", model.id));
int res = Base.SQLServerHelper.ExecuteSql(sb.ToString(), pms.ToArray());
return(res > 0);
}
/// <summary>
/// 增
/// </summary>
/// <param name="model">new model</param>
/// <returns></returns>
public bool AddReasonCode(ReasonModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into ReasonCode ( ");
sb.Append("reason,reasondesc");
sb.Append(") values ( ");
sb.Append(",@reason,@reasondesc");
sb.Append(") ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@reason", model.reason));
pms.Add(new SqlParameter("@reasondesc", model.ReasonDesc));
int res = Base.SQLServerHelper.ExecuteSql(sb.ToString(), pms.ToArray());
return(res > 0);
}
public IActionResult Reject(int examinationId, ReasonModel input)
{
var UID = int.Parse(UserId);
using var db = new DatabaseContext();
var ex = db.LaboratoryExaminations.SingleOrDefault(x => x.LaboratoryExaminationId == examinationId);
if (ex != null && ex.Status == "Executed" && input.Reason != null)
{
ex.Status = "Rejected";
ex.ApprovalRejectionDate = DateTime.Now;
ex.ManagerComment = input.Reason;
ex.LaboratoryManagerId = UID;
db.SaveChanges();
return(Ok());
}
return(BadRequest());
}
public IActionResult LaboratoryAbort(int examinationId, ReasonModel input)
{
var UID = int.Parse(UserId);
using var db = new DatabaseContext();
var ex = db.LaboratoryExaminations.SingleOrDefault(x => x.LaboratoryExaminationId == examinationId);
if (ex != null)
{
ex.Result = input.Reason;
ex.Status = "Canceled";
ex.ExaminationDate = DateTime.Now;
ex.LaboratoryWorkerId = UID;
db.SaveChanges();
return(Ok());
}
return(BadRequest());
}
public IActionResult Cancel(int visitId, ReasonModel formData)
{
var UID = int.Parse(UserId);
using var db = new DatabaseContext();
var pv = db.PatientVisits.SingleOrDefault(x => x.PatientVisitId == visitId);
if (pv != null && formData.Reason != null && pv.Status == "Registered" &&
(User.IsInRole("DOCT") && UID == pv.DoctorId || User.IsInRole("RECP"))) // doktor moze anulowac tylko swoje a recp wszystkie
{
pv.Status = "Canceled";
pv.CloseDate = DateTime.Now;
pv.Description = formData.Reason;
db.SaveChanges();
return(Ok());
}
return(BadRequest());
}
protected override void SubscribeEvent()
{
View.Save += async() => await SaveAsync();
View.Loading += View_Loading;
View.SelectionReason += () =>
{
JournalsForm journal = new JournalsForm();
JournalsPresenter <Reason> presenter = new JournalsPresenter <Reason>(journal, new ReasonJournal(journal.Grid, _numberApplication));
journal.ShowDialog();
if (presenter.Info != null)
{
ReasonModel reason = (ReasonModel)presenter.Info;
_reasonID = reason.ID;
View.Reason = GetReasonText(reason.ShortName, reason.Type);
}
};
View.AddWork += AddWork;
View.EditWork += EditWork;
View.DeleteWork += DeleteWork;
View.AddMaterial += AddMaterial;
View.EditMaterial += EditMaterial;
View.DeleteMaterial += DeleteMaterial;
View.AddMaterialCustomer += AddMaterialCustomer;
View.EditMaterialCustomer += EditMaterialCustomer;
View.DeleteMaterialCustomer += DeleteMaterialCustomer;
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddReason(ReasonModel model)
{
return(Common.Instance._Reason.AddReasonCode(model));
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool DeleteReason(ReasonModel model)
{
return(Common.Instance._Reason.DeleteReasonCode(model));
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public static ReasonModel GetReasonInfo(ReasonModel model)
{
return(Common.Instance._Reason.GetReasonCodeInfo(model));
}
