// update status
public bool EditStatus(StatusVM status, out string msg)
{
Status s = _context.Status
.Where(a => a.StatusTypeID == status.StatusTypeID && a.StatusName == status.StatusName)
.FirstOrDefault();
if (s != null)
{
if (s.StatusID != status.StatusID)
{
msg = "Status already exist for this status type.";
return(false);
}
}
try
{
Status statusUpdated = _context.Status
.Where(d => d.StatusID == status.StatusID)
.FirstOrDefault();
statusUpdated.StatusName = status.StatusName;
statusUpdated.StatusTypeID = status.StatusTypeID;
_context.SaveChanges();
msg = "Status succesfully updated.";
return(true);
}
catch
{
msg = "Failed to update status.";
return(false);
}
}
public EditInspectionViewModel(InspectieViewModel inspection, FestiSpecProvider dataServer)
{
_previousPage = inspection;
_dataServer = dataServer;
_inspection = inspection.SelectedInspectie;
Datum = _inspection.Datum;
GebruikerList = new ObservableCollection <GebruikerVM>();
foreach (var g in _inspection.InspectieModel.Gebruiker1.ToList())
{
GebruikerVM gVM = new GebruikerVM(g);
gVM.IsIncluded = true;
GebruikerList.Add(gVM);
}
PostCode = _inspection.Postcode;
huisnummer = _inspection.Huisnummer;
Naam = _inspection.Naam;
Wens = _inspection.Wens;
SelectedKlant = new KlantVM(_inspection.InspectieModel.Klant);
SelectedStatus = new StatusVM(_inspection.InspectieModel.Status);
SelectedOfferte = new OfferteVM(_inspection.InspectieModel.Offerte);
KlantList = _dataServer.GetKlanten();
StatusList = _dataServer.GetStatus();
OfferteList = _dataServer.GetOfferte().ToList();
EditInspectionCommand = new RelayCommand(EditInspection);
ShowMapCommand = new RelayCommand(CalculateRoute);
apiConnector = new GeodanRepository("6c4c63db-de9a-11e8-8aac-005056805b87");
}
public HttpResponseMessage Add(StatusVM statusVM, string token)
{
try
{
//check token info
var isAllow = iAccountService.IsTokenAvailable(token);
if (!isAllow)
{
return(PostResponseFail(HttpStatusCode.ExpectationFailed, ExceptionMessageConstant.TokenNotAvailable));
}
//proceed request
var tokenizedUserId = iAccountService.GetUserIdByToken(token);
statusVM.UserId = tokenizedUserId;
iStatusService.AddStatus(statusVM);
return(PostResponseSuccess(HttpStatusCode.OK, SucessMessageConstant.RequestHandleSuccessful));
}
catch (NullReferenceException)
{
return(PostResponseFail(HttpStatusCode.ExpectationFailed, ExceptionMessageConstant.RequestNullExceptionMassge));
}
catch (Exception ex)
{
return(PostResponseFail(HttpStatusCode.ExpectationFailed, ex.Message));
}
}
// create new status
public bool AddStatus(StatusVM status, out string msg)
{
Status s = _context.Status.Where(e => e.StatusName == status.StatusName)
.FirstOrDefault();
if (s != null)
{
msg = "Status name already exist.";
return(false);
}
try
{
Status newStatus = new Status();
newStatus.StatusName = status.StatusName;
newStatus.StatusTypeID = status.StatusTypeID;
_context.Status.Add(newStatus);
_context.SaveChanges();
msg = "Status successfully created";
return(true);
}
catch (SqlException)
{
msg = "Failed to add status.";
return(false);
}
}
public void editRoom()
{
RoomVM roomVM = _iRoomBLL.getAll(1, 2, "hello")[0];
roomVM.RoomName = "Room1";
//edit status time
roomVM.ListStatusTime[0].StatimTodate = Convert.ToDateTime("01/10/2021");
//add Status time
StatusVM statusVM = new StatusVM();
statusVM.IdStatus = 1;
StatusTimeVM statusTimeVM = new StatusTimeVM();
//statusTimeVM.IdStatim = 4; //gia su minh sua lai thong tin tk status_time da co trong db
statusTimeVM.StatimFromdate = DateTime.Now;
statusTimeVM.StatimTodate = Convert.ToDateTime("12/12/2021");
statusTimeVM.statusVM = statusVM;
roomVM.ListStatusTime.Add(statusTimeVM);
//del sattus time
// List<int>listdel = new List<int>();
// listdel.Add(3);
_iRoomBLL.editRoom(roomVM, null);
}
public static void UpdateStatus(this Status item, StatusVM itemVM)
{
item.Name = itemVM.Name;
item.LinkedIds = itemVM.LinkedIds;
item.Group = item.Group;
item.Description = itemVM.Description;
}
protected void GridView_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
StatusVM CloneItem = new StatusVM();
if (bool.Parse(HttpContext.Current.Session["isCloneRow_Com"].ToString()) == true && GridView.FocusedRowIndex >= 0)
{
//List<int> selectedIds = GridView.GetSelectedFieldValues("Id").ConvertAll(id => (int)id);
//CloneItem = StandardTypeProvider.GetSingleById(selectedIds.Last());
CloneItem = Mapper.Map <StatusVM>(StatusProvider.GetSingleById(GridView.GetRowValues(GridView.FocusedRowIndex, "Id").ToString()));
HttpContext.Current.Session["isCloneRow_Com"] = false;
PropertyInfo myFieldInfo;
foreach (var myProperty in typeof(StatusVM).GetProperties())
{
myFieldInfo = typeof(StatusVM).GetProperty(myProperty.Name);
if (myFieldInfo == null)
{
continue;
}
var ttt = myFieldInfo.GetValue(CloneItem);
e.NewValues[myProperty.Name] = myFieldInfo.GetValue(CloneItem);
}
}
}
public async Task <int> SaveAreaScore(StatusVM status)
{
int count = 0;
using (IAreaScoreRepository db = new AreaScoreRepository())
{
status.AreaScores.ForEach(a =>
{
var areaScore = db.Where(r => r.ReleaseID == status.ReleaseID && r.AreaID == a.AreaID && r.CPID == status.CPID).FirstOrDefault();
if (areaScore != null)//edit areaScore
{
if (areaScore.Score != a.Score)
{
areaScore.Score = a.Score;
db.Edit(areaScore);
}
}
else//add areaScore
{
areaScore = new AreaScore()
{
ReleaseID = status.ReleaseID, AreaID = a.AreaID, CPID = status.CPID, Score = a.Score
};
db.Add(areaScore);
}
});
count += await db.SaveAsync((WindowsPrincipal)User);
using (ISubAreaScoreRepository dbSubAreaScore = new SubAreaScoreRepository())
{
status.AreaScores.ForEach(a =>
{
var areaScore = db.Where(r => r.ReleaseID == status.ReleaseID && r.AreaID == a.AreaID && r.CPID == status.CPID).FirstOrDefault();
a.SubAreaScors.ForEach(sas =>
{
var subAreaScore = dbSubAreaScore.Where(s => s.SubAreaID == sas.SubAreaID && s.AreaScoreID == areaScore.AreaScoreID).FirstOrDefault();
if (subAreaScore != null)//edit subAreaScore
{
if (subAreaScore.Score != sas.Score)
{
subAreaScore.Score = sas.Score;
dbSubAreaScore.Edit(subAreaScore);
}
}
else//add subAreaScore
{
subAreaScore = new SubAreaScore()
{
SubAreaID = sas.SubAreaID, AreaScoreID = areaScore.AreaScoreID, Score = sas.Score
};
dbSubAreaScore.Add(subAreaScore);
}
});
});
count += await dbSubAreaScore.SaveAsync((WindowsPrincipal)User);
}
}
return(count);
}
public ActionResult ViewStatus(int ReleaseId, int CPID = 0, bool IsDraft = true)
{
using (ReleaseCPRepository db = new ReleaseCPRepository())
{
status = new StatusVM();
status.ReleaseID = ReleaseId;
NavigationBreadCrums.SetSesionReleaseID(ReleaseId);
List <StatusAreaText> statusAreaTexts;
using (IStatusAreaTextRepository dbStatusAreaText = new StatusAreaTextRepository())
{
statusAreaTexts = dbStatusAreaText.Where(a => a.ReleaseID == ReleaseId).ToList();
}
using (IStatusTextRepository dbStatusText = new StatusTextRepository())
{
StatusText statusText = dbStatusText.Where(a => a.ReleaseID == ReleaseId).FirstOrDefault();
if (statusText != null)
{
status.StatusText = new StatusTextVM()
{
ReleaseID = statusText.ReleaseID, HighLightText = statusText.HighLightText
}
}
;
}
using (IReleaseChecklistAnswerRepository dbChecklist = new ReleaseChecklistAnswerRepository())
{
status.AreaScores = dbChecklist.GetStatus(ReleaseId).Select(q =>
new AreaScoreVM()
{
AreaID = q.Area.AreaID,
ReleaseID = ReleaseId,
Name = q.Area.Name,
Score = q.Score,
ScoreStatus = IndicatorList.First(i => q.Score >= i.Min && q.Score < i.Max).ScoreIMG,
Trand = q.LastScore != null ? TrandCalculation(q.Score, (double)q.LastScore) : Trand.none,
StatusAreaText = statusAreaTexts != null && statusAreaTexts.Where(s => s.AreaID == q.Area.AreaID).FirstOrDefault() != null ? statusAreaTexts.Where(s => s.AreaID == q.Area.AreaID).FirstOrDefault().AreaText : "",
SubAreaScors = q.SubAreaScores.Select(s =>
new SubAreaScoreVM()
{
Name = s.SubArea.Name,
Score = s.Score,
ScoreStatus = IndicatorList.First(i => s.Score >= i.Min && s.Score < i.Max).ScoreIMG,
SubAreaID = s.SubArea.SubAreaID,
Trand = s.LastScore != null ? TrandCalculation(s.Score, (double)s.LastScore) : Trand.none,
}).ToList()
}).ToList();
}
}
status.Details = new ReleaseGeneralDetails()
{
ReleaseID = ReleaseId
};
status.CPID = CPID;
status.IsDraft = IsDraft;
return(View(status));
}
public void OnWindowClosing(object sender, CancelEventArgs e)
{
CameraVM.Dispose();
XYZMotorVM.Dispose();
MeasurementVM.Dispose();
SpectrometerVM.Dispose();
StatusVM.Dispose();
App.Current.Shutdown();
}
public ActionResult Create()
{
var model = new StatusVM
{
StatusTypeList = _lRepo.GetStatusTypeList()
};
return(View(model));
}
public static void Update(StatusVM item)
{
Status dbItem = GetSingleById(item.Id);
dbItem.UpdateStatus(item);
RepositoryBase <Status> .Update(dbItem);
RepositoryBase <Status> .SaveChanges();
}
public bool Insert(StatusVM statusVM)
{
if (string.IsNullOrWhiteSpace(statusVM.Name))
{
return(status);
}
else
{
return(iStatusRepository.Insert(statusVM));
}
}
public List <StatusVM> getAll()
{
List <Status> list = _statusDAL.GetAll();
List <StatusVM> listVm = new List <StatusVM>();
foreach (Status status in list)
{
StatusVM statusVM = mapper.Map <StatusVM>(status);
listVm.Add(statusVM);
}
return(listVm);
}
/// <summary>
/// Just a message to the user to inform them of the status.
/// </summary>
/// <param name="isSuccess"></param>
/// <returns></returns>
public async Task <ActionResult> UseCompanyKeyComplete(bool isSuccess)
{
StatusVM status = new StatusVM();
status.IsSuccess = isSuccess;
status.SuccessMessage = isSuccess ? "You have successfully joined. You can now create appointments :)." : "";
status.FailMessage = isSuccess ? "" : "An error occurred when assigning to the company. Please contact the company owner and try again. If the problem persists, please contact support.";
return(View(status));
}
public ActionResult SaveStats(StatusVM StatustMaster)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
StatustMaster.CmpyCode = list[0].CmpyCode;
return(Json(_StatService.SaveStats(StatustMaster), JsonRequestBehavior.AllowGet));
}
}
// get status by id
public StatusVM GetStatus(int statusID)
{
StatusVM status = _context.Status
.Where(a => a.StatusID == statusID)
.Select(b => new StatusVM
{
StatusName = b.StatusName,
StatusTypeID = b.StatusTypeID,
StatusID = b.StatusID,
StatusTypeName = b.StatusType.StatusTypeName
}).FirstOrDefault();
return(status);
}
public bool Update(int id, StatusVM statusVM)
{
var get = Get(id);
if (get != null)
{
get.Update(id, statusVM);
myContext.Entry(get).State = EntityState.Modified;
myContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool Insert(StatusVM statusVM)
{
var push = new Status(statusVM);
myContext.Statuses.Add(push);
var result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
else
{
return(status);
}
return(status);
}
public static Status Add(StatusVM item)
{
Status dbItem = new Status();
dbItem.UpdateStatus(item);
dbItem.Id = item.Id;
dbItem.Actived = item.Actived;
dbItem.CreatedDate = DateTime.Now;
dbItem.CreatedBy = HttpContext.Current.User.Identity.Name;
Status model = RepositoryBase <Status> .Add(dbItem);
RepositoryBase <Status> .SaveChanges();
return(dbItem);
}
public ActionResult VerifyAccount(string id)
{
StatusVM model = new StatusVM();
UsersRepository usersRepo = new UsersRepository();
User user = usersRepo.GetAll(u => u.ActivationCode == new Guid(id)).FirstOrDefault();
if (user != null)
{
user.IsEmailVerified = true;
usersRepo.Save(user);
model.status = true;
}
else
{
model.message = "Invalid Request ,Verification Is Not Complete!";
}
return(View(model));
}
public ActionResult PutovanjaUpdate([FromForm] StatusVM model)
{
if (model == null)
{
return(BadRequest());
}
UposlenikOdrediste putovanje = _db.UposlenikOdrediste.Include(x => x.Odrediste).Where(x => x.Id == model.PutovanjeId).FirstOrDefault();
if (putovanje == null)
{
return(BadRequest());
}
Uposlenik u = _db.Uposlenik.Where(x => x.Id == putovanje.UposlenikId).FirstOrDefault();
putovanje.Hotel = model.Hotel;
putovanje.Prevoz = model.Prevoz;
putovanje.Dokumentacija = model.Dokumentacija;
putovanje.Uplate = model.Uplate;
putovanje.Osiguranje = model.Osiguranje;
if (putovanje.Hotel != null && putovanje.Prevoz != null && putovanje.Hotel.Count() > 0 && putovanje.Prevoz.Count() > 0 && putovanje.Osiguranje && putovanje.Dokumentacija && putovanje.Uplate)
{
putovanje.Zavrseno = true;
var poruka = new TextPart(TextFormat.Html)
{
Text = "Vaše službeno putovanje u " + putovanje.Odrediste.Naziv + ", od " + putovanje.DatumPolaska.ToShortDateString() + " do " + putovanje.DatumPovratka.ToShortDateString() + " je obrađen te su informacije sljedeće: "
+ "<br />Hotel: <b>" + putovanje.Hotel + "</b><br />Prevoz: <b>" + putovanje.Prevoz + "</b><br />Smjestaj placen: <b>" + (putovanje.Uplate ? "Da" : "Ne")
+ "</b><br /><br />Hvala što koristite naše usluge. <i>PutovanjaAPI</i>"
};
EmailHelper.PosaljiEmail(u, "Zakazivanje Službenog putovanja", poruka);
}
_db.UposlenikOdrediste.Update(putovanje);
_db.SaveChanges();
return(Ok("Ok"));
}
public ActionResult Edit(StatusVM model)
{
string msg = "";
if (ModelState.IsValid)
{
bool success = _sRepo.EditStatus(model, out msg);
if (success)
{
TempData["SuccessMsg"] = msg;
return(RedirectToAction("Details", new { id = model.StatusID }));
}
else
{
TempData["ErrorMsg"] = msg;
}
}
StatusVM status = _sRepo.GetStatus(model.StatusID);
return(View(status));
}
public ActionResult Delete(StatusVM status)
{
string msg = "";
if (ModelState.IsValid)
{
bool success = _sRepo.DeleteStatus(status.StatusID, out msg);
if (success)
{
TempData["SuccessMsg"] = msg;
return(RedirectToAction("index"));
}
else
{
TempData["ErrorMsg"] = msg;
}
}
else
{
TempData["ErrorMsg"] = "Status cannot be deleted at this time.";
}
status = _sRepo.GetStatus(status.StatusID);
return(View(status));
}
public ActionResult Create(StatusVM model)
{
string msg = "";
if (ModelState.IsValid)
{
bool success = _sRepo.AddStatus(model, out msg);
if (success)
{
TempData["SuccessMsg"] = msg;
return(RedirectToAction("index"));
}
else
{
TempData["ErrorMsg"] = msg;
}
}
else
{
TempData["ErrorMsg"] = "Status cannot be added at this time.";
}
model.StatusTypeList = _lRepo.GetStatusTypeList();
return(View(model));
}
protected void GridView_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
StatusVM item = new StatusVM();
if (GridView.IsNewRowEditing)
{
//foreach (var itemKey in e.NewValues.Keys)
foreach (GridViewColumn column in GridView.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
PropertyInfo myFieldInfo = typeof(StatusVM).GetProperty(dataColumn.FieldName);
if (myFieldInfo == null)
{
continue;
}
myFieldInfo.SetValue(item, e.NewValues[dataColumn.FieldName]);
ValidationContext context = new ValidationContext(item)
{
MemberName = dataColumn.FieldName
};
var errors = new List <ValidationResult>();
var myProperty = item.GetType().GetProperty(dataColumn.FieldName).GetValue(item, null);
bool isValid = Validator.TryValidateProperty(myProperty, context, errors);
if (!isValid)
{
//e.Errors[dataColumn] = errors[0].ErrorMessage;
AddError(e.Errors, dataColumn, errors[0].ErrorMessage);
}
//var myPropertyInfo = item.GetType().GetProperty(dataColumn.FieldName);
//myFieldInfo.SetValue(item, e.NewValues[itemKey.ToString()]);
}
}
else
{
//foreach (var itemKey in e.NewValues.Keys)
foreach (GridViewColumn column in GridView.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
PropertyInfo myFieldInfo = typeof(StatusVM).GetProperty(dataColumn.FieldName);
if (myFieldInfo == null)
{
continue;
}
myFieldInfo.SetValue(item, e.NewValues[dataColumn.FieldName]);
ValidationContext context = new ValidationContext(item)
{
MemberName = dataColumn.FieldName
};
var errors = new List <ValidationResult>();
var myProperty = item.GetType().GetProperty(dataColumn.FieldName).GetValue(item, null);
bool isValid = Validator.TryValidateProperty(myProperty, context, errors);
if (!isValid)
{
if (dataColumn.FieldName != "FastStandardTypeName" && dataColumn.FieldName != "UserName" && dataColumn.FieldName != "Password" && dataColumn.FieldName != "ConfirmPassword")
{
//e.Errors[dataColumn] = errors[0].ErrorMessage;
AddError(e.Errors, dataColumn, errors[0].ErrorMessage);
}
}
//var myPropertyInfo = item.GetType().GetProperty(dataColumn.FieldName);
//myFieldInfo.SetValue(item, e.NewValues[itemKey.ToString()]);
}
}
if (e.Errors.Count > 0)
{
e.RowError = "Vui lòng nhập đầy đủ thông tin theo yêu cầu.";
}
}
public Status(StatusVM statusVm)
{
this.Status_name = statusVm.Status_name;
this.Status_module = statusVm.Status_module;
this.CreateDate = DateTimeOffset.Now.LocalDateTime;
}
public StatusVM SaveStats(StatusVM StatustMaster)
{
return(_StatRepo.SaveStats(StatustMaster));
}
public StatusVM SaveStats(StatusVM Stats)
{
try
{
if (!Stats.EditFlag)
{
var Drecord = new List <string>();
List <StatusDetailnew> ObjList = new List <StatusDetailnew>();
ObjList.AddRange(Stats.StatusDetailnew.Select(m => new StatusDetailnew
{
CmpyCode = m.CmpyCode,
Code = m.Code,
Name = m.Name,
// UniCodeName=m.UniCodeName
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MSTS023 where CmpyCode='" + Stats.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'");
if (Stats1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Stats.CmpyCode + "',");
sb.Append("'" + ObjList[n - 1].Code + "',");
sb.Append("'" + ObjList[n - 1].Name + "')");
// sb.Append("'" + ObjList[n - 1].UniCodeName + "')");
using (TransactionScope scope = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("insert into MSTS023(CmpyCode,Code,Name) values(" + sb.ToString() + "");
_EzBusinessHelper.ActivityLog(Stats.CmpyCode, Stats.UserName, "Add Status Master", Stats.Code, Environment.MachineName);
Stats.SaveFlag = true;
Stats.ErrorMessage = string.Empty;
scope.Complete();
}
}
else
{
Drecord.Add(ObjList[n - 1].Code.ToString());
Stats.Drecord = Drecord;
Stats.SaveFlag = false;
Stats.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
return(Stats);
}
var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from MSTS023 where CmpyCode='" + Stats.CmpyCode + "' and Code='" + Stats.Code + "'");
if (StatsEdit != 0)
{
using (TransactionScope scope1 = new TransactionScope())
{
_EzBusinessHelper.ExecuteNonQuery("update MSTS023 set CmpyCode='" + Stats.CmpyCode + "',Code='" + Stats.Code + "',Name='" + Stats.Name + "' where CmpyCode='" + Stats.CmpyCode + "' and Code='" + Stats.Code + "'");
_EzBusinessHelper.ActivityLog(Stats.CmpyCode, Stats.UserName, "Update Status Master", Stats.Code, Environment.MachineName);
Stats.SaveFlag = true;
Stats.ErrorMessage = string.Empty;
scope1.Complete();
}
}
else
{
Stats.SaveFlag = false;
Stats.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
Stats.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Stats);
}
public void Update(StatusVM statusVM)
{
this.Name = statusVM.Name;
this.UpdateDate = DateTimeOffset.Now.LocalDateTime;
}
