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;
}
}
