public static void ChangePassword(ChangePassModel _user, out string message) { try { message = ""; using (var db = new eCardEntities()) { var user = db.UserAccount.FirstOrDefault(r => r.ID == UniversalService.CurrentUser.ID); if (user != null) { if (user.Password == _user.CurrentPass) { user.Password = _user.NewPass; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { message = "Invalid Password"; } } } } catch (Exception error) { message = error.Message; } }
public static void SaveMotoRequest(MotoRequestModel _request, out string message) { try { message = ""; using (var db = new eCardEntities()) { if (_request.ID == Guid.Empty) //NEW { MotoRequest newMoto = new MotoRequest { ID = Guid.NewGuid(), Date = DateTime.Now, RequestedBy = UniversalService.CurrentUser.ID, ClientCode = _request.ClientCode, Company = _request.Company, PaxName = _request.PaxName.ToUpper(), RecordLocator = _request.RecordLocator.ToUpper(), Currency = _request.Currency, Amount = _request.Amount, Others = _request.Others, BCDFee = _request.BCDFee, AdminFee = _request.AdminFee, Total = _request.Amount + _request.BCDFee + _request.Others + _request.AdminFee, OptionTime = _request.OptionTime, ApprovalCode = _request.ApprovalCode, Remarks = _request.Remarks, Invoice = _request.Invoice, Status = _request.Status, DeclinedReason = _request.DeclinedReason, ApprovedBy = Guid.Empty }; db.Entry(newMoto).State = EntityState.Added; db.SaveChanges(); } else { var moto = db.MotoRequest.FirstOrDefault(r => r.ID == _request.ID); if (moto != null) { moto.ClientCode = _request.ClientCode; moto.Company = _request.Company; moto.PaxName = _request.PaxName.ToUpper(); moto.RecordLocator = _request.RecordLocator.ToUpper(); moto.Currency = _request.Currency; moto.AdminFee = _request.AdminFee; moto.Total = _request.Amount + _request.Others + _request.BCDFee + _request.AdminFee; moto.OptionTime = _request.OptionTime; moto.ApprovalCode = _request.ApprovalCode; moto.Remarks = _request.Remarks; moto.Invoice = _request.Invoice; moto.Status = _request.Status; moto.DeclinedReason = _request.DeclinedReason; moto.ApprovedDate = DateTime.Now; moto.ApprovedBy = UniversalService.CurrentUser.ID; db.Entry(moto).State = EntityState.Modified; db.SaveChanges(); } } } } catch (Exception error) { message = error.Message; } }
public static void Save(UserAccountModel _user, out string message) { try { message = ""; using (var db = new eCardEntities()) { if (_user.ID == Guid.Empty || _user.ID == null) // NEW { UserAccount newAccount = new UserAccount { ID = Guid.NewGuid(), Username = _user.Username, Password = _user.Password, Department = _user.Department, Email = _user.Email, FirstName = _user.Firstname, LastName = _user.LastName, MiddleInitial = _user.MiddleInitial, Status = "Y", Type = _user.Type, CreatedBy = UniversalService.CurrentUser.ID, CreatedDate = DateTime.Now }; db.Entry(newAccount).State = System.Data.Entity.EntityState.Added; } else { var user = db.UserAccount.FirstOrDefault(r => r.ID == _user.ID); if (user != null) { user.Username = _user.Username; if (_user.Password != "" && _user.Password != null) { user.Password = _user.Password; } user.Department = _user.Department; user.Email = _user.Email; user.FirstName = _user.Firstname; user.LastName = _user.LastName; user.MiddleInitial = _user.MiddleInitial; user.Status = _user.Status; user.Type = _user.Type; user.CreatedBy = UniversalService.CurrentUser.ID; user.CreatedDate = DateTime.Now; db.Entry(user).State = System.Data.Entity.EntityState.Modified; } } db.SaveChanges(); } } catch (Exception error) { message = error.Message; } }