private questStatus delete(FMSEntities dbContext, UserId userId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
List <Quest.Services.Dbio.FMS.GroupUsers> groupUserList = null;
status = read(dbContext, userId, out groupUserList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the records.
foreach (Quest.Services.Dbio.FMS.GroupUsers groupUser in groupUserList)
{
dbContext.GroupUsers.Remove(groupUser);
}
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* UserPrivileges
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, UserPrivilege userPrivilege, out UserPrivilegeId userPrivilegeId)
{
// Initialize
userPrivilegeId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.UserPrivileges _userPrivileges = new Quest.Services.Dbio.FMS.UserPrivileges();
_userPrivileges.PrivilegeId = userPrivilege.Privilege.Id;
_userPrivileges.UserId = userPrivilege.User.Id;
_userPrivileges.Created = DateTime.Now;
dbContext.UserPrivileges.Add(_userPrivileges);
dbContext.SaveChanges();
if (_userPrivileges.Id == 0)
{
return(new questStatus(Severity.Error, "UserPrivilege not created"));
}
userPrivilegeId = new UserPrivilegeId(_userPrivileges.Id);
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
private questStatus delete(FMSEntities dbContext, PrivilegeId privilegeId)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
Quest.Services.Dbio.FMS.Privileges _privilege = null;
status = read(dbContext, privilegeId, out _privilege);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Delete the record.
dbContext.Privileges.Remove(_privilege);
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Groups
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, Group group, out GroupId groupId)
{
// Initialize
groupId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.Groups _group = new Quest.Services.Dbio.FMS.Groups();
BufferMgr.TransferBuffer(group, _group);
dbContext.Groups.Add(_group);
dbContext.SaveChanges();
if (_group.Id == 0)
{
return(new questStatus(Severity.Error, "Group not created"));
}
groupId = new GroupId(_group.Id);
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
private questStatus update(FMSEntities dbContext, Group group)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
GroupId groupId = new GroupId(group.Id);
Quest.Services.Dbio.FMS.Groups _group = null;
status = read(dbContext, groupId, out _group);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the record.
BufferMgr.TransferBuffer(group, _group);
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Privileges
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, Privilege privilege, out PrivilegeId privilegeId)
{
// Initialize
privilegeId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.Privileges _privilege = new Quest.Services.Dbio.FMS.Privileges();
BufferMgr.TransferBuffer(privilege, _privilege);
dbContext.Privileges.Add(_privilege);
dbContext.SaveChanges();
if (_privilege.Id == 0)
{
return(new questStatus(Severity.Error, "Privilege not created"));
}
privilegeId = new PrivilegeId(_privilege.Id);
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/// <summary>
/// Saves context changes
/// </summary>
public void SaveChanges()
{
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
LogEntityValidationErrors(e.EntityValidationErrors);
throw;
}
}
public void SaveChangesLog(TEntity entity, Login user, Core.Enums.MenuList menuId)
{
if (user != null)
{
var isAdded = _context.ChangeTracker.Entries().Any(x => x.State == EntityState.Added);
var isModified = _context.ChangeTracker.Entries().Any(x => x.State == EntityState.Modified);
var isDeleted = _context.ChangeTracker.Entries().Any(x => x.State == EntityState.Deleted);
var action = "";
if (isAdded)
{
action = "Create";
}
if (isModified)
{
action = "Modified";
}
ObjectContext objectContext = ((IObjectContextAdapter)_context).ObjectContext;
ObjectSet <TEntity> set = objectContext.CreateObjectSet <TEntity>();
IEnumerable <string> keyNames = set.EntitySet.ElementType
.KeyMembers
.Select(k => k.Name);
string id = "";
if (keyNames.Count() > 0)
{
foreach (var name in keyNames)
{
id += _context.Entry(entity).CurrentValues[name].ToString();
}
}
_context.TRA_CHANGES_HISTORY.Add(new TRA_CHANGES_HISTORY()
{
MODUL_ID = (int)menuId,
FORM_ID = long.Parse(id),
MODIFIED_BY = user.USER_ID,
MODIFIED_DATE = DateTime.Now,
ACTION = action
});
_context.SaveChanges();
}
}
private questStatus update(FMSEntities dbContext, UserSession userSession)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
UserSessionId userSessionId = new UserSessionId(userSession.Id);
Quest.Services.Dbio.FMS.UserSessions _userSession = null;
status = read(dbContext, userSessionId, out _userSession);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the record.
BufferMgr.TransferBuffer(userSession, _userSession);
dbContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, " The DbEntityValidationException errors are: ", fullErrorMessage);
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage)));
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* UserSessions
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(FMSEntities dbContext, UserSession userSession, out UserSessionId userSessionId)
{
// Initialize
userSessionId = null;
// Perform create
try
{
Quest.Services.Dbio.FMS.UserSessions _userSession = new Quest.Services.Dbio.FMS.UserSessions();
BufferMgr.TransferBuffer(userSession, _userSession);
dbContext.UserSessions.Add(_userSession);
dbContext.SaveChanges();
if (_userSession.Id == 0)
{
return(new questStatus(Severity.Error, "UserSession not created"));
}
userSessionId = new UserSessionId(_userSession.Id);
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
String fullErrorMessage = string.Join("; ", errorMessages);
String exceptionMessage = string.Concat(ex.Message, " The DbEntityValidationException errors are: ", fullErrorMessage);
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
exceptionMessage)));
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public void AddSecretaryPayment(SecretaryPayment payment)
{
_db.SecretaryPayments.Add(payment);
_db.SaveChanges();
}
public void AddSalers(Saler saler)
{
_db.Salers.Add(saler);
_db.SaveChanges();
}
public void AddCustomer(CustomerDetail customer)
{
db.CustomerDetails.Add(customer);
db.SaveChanges();
}
public void AddSalerPayment(SalerPayment payment)
{
_db.SalerPayments.Add(payment);
_db.SaveChanges();
}
public void AddCannoe(Cannoe cannoe)
{
_db.Cannoes.Add(cannoe);
_db.SaveChanges();
}
public TraCcfDto Save(TraCcfDto Dto, Login userLogin)
{
TRA_CCF dbTraCcf;
TRA_CCF_DETAIL dbTraCcfD1;
if (Dto == null)
{
throw new Exception("Invalid Data Entry");
}
try
{
if (Dto.TraCcfId > 0)
{
//update
var Exist = _ccfService.GetCcf().Where(c => c.TRA_CCF_ID == Dto.TraCcfId).FirstOrDefault();
if (Exist == null)
{
throw new BLLException(ExceptionCodes.BLLExceptions.DataNotFound);
}
dbTraCcf = Mapper.Map <TRA_CCF>(Dto);
dbTraCcfD1 = Mapper.Map <TRA_CCF_DETAIL>(Dto.DetailSave);
//If Status Completed
if (Dto.DocumentStatus == Enums.DocumentStatus.Completed)
{
FMSEntities context = new FMSEntities();
var query = from p in context.TRA_CCF
where p.TRA_CCF_ID == dbTraCcf.TRA_CCF_ID
select p;
foreach (TRA_CCF dt in query)
{
dt.DOCUMENT_STATUS = dbTraCcf.DOCUMENT_STATUS;
}
context.SaveChanges();
}
//If Status In Progress
if (dbTraCcf.POLICE_NUMBER != null || dbTraCcf.POLICE_NUMBER_GS != null)
{
_ccfService.Save(dbTraCcf, userLogin);
if (dbTraCcfD1.COMPLAINT_URL != null && dbTraCcfD1.COMPLAINT_ATT != null)
{
dbTraCcfD1.TRA_CCF_ID = dbTraCcf.TRA_CCF_ID;
_ccfService.Save_d1(dbTraCcfD1);
}
else
{
var data_d1 = _ccfService.GetCcfD1().Where(c => c.TRA_CCF_DETAIL_ID == Dto.DetailSave.TraCcfDetilId).FirstOrDefault();
if (data_d1 != null)
{
dbTraCcfD1.TRA_CCF_ID = data_d1.TRA_CCF_ID;
dbTraCcfD1.COMPLAINT_URL = data_d1.COMPLAINT_URL;
dbTraCcfD1.COMPLAINT_ATT = data_d1.COMPLAINT_ATT;
_ccfService.Save_d1(dbTraCcfD1);
}
}
}
if (dbTraCcfD1.COORDINATOR_NOTE != null && dbTraCcfD1.VENDOR_NOTE == null)
{
var data_d1 = _ccfService.GetCcfD1().Where(c => c.TRA_CCF_DETAIL_ID == Dto.DetailSave.TraCcfDetilId).FirstOrDefault();
if (data_d1 == null)
{
_ccfService.Save_d1(dbTraCcfD1);
}
else
{
dbTraCcfD1.COMPLAINT_DATE = data_d1.COMPLAINT_DATE;
dbTraCcfD1.COMPLAINT_NOTE = data_d1.COMPLAINT_NOTE;
dbTraCcfD1.COMPLAINT_URL = data_d1.COMPLAINT_URL;
dbTraCcfD1.COMPLAINT_ATT = data_d1.COMPLAINT_ATT;
dbTraCcfD1.VENDOR_RESPONSE_DATE = null;
if (dbTraCcfD1.COORDINATOR_ATT == null)
{
dbTraCcfD1.COORDINATOR_ATT = data_d1.COORDINATOR_ATT;
}
_ccfService.Save_d1(dbTraCcfD1);
}
FMSEntities context = new FMSEntities();
var query = from p in context.TRA_CCF
where p.TRA_CCF_ID == dbTraCcf.TRA_CCF_ID
select p;
foreach (TRA_CCF dt in query)
{
dt.DOCUMENT_STATUS = dbTraCcf.DOCUMENT_STATUS;
dt.COORDINATOR_NAME = userLogin.USER_ID;
}
context.SaveChanges();
}
else if (dbTraCcfD1.COORDINATOR_NOTE == null && dbTraCcfD1.VENDOR_NOTE != null)
{
var data_d1 = _ccfService.GetCcfD1().Where(c => c.TRA_CCF_DETAIL_ID == Dto.DetailSave.TraCcfDetilId).FirstOrDefault();
if (data_d1 == null)
{
_ccfService.Save_d1(dbTraCcfD1);
}
else
{
dbTraCcfD1.COMPLAINT_DATE = data_d1.COMPLAINT_DATE;
dbTraCcfD1.COMPLAINT_NOTE = data_d1.COMPLAINT_NOTE;
dbTraCcfD1.COMPLAINT_URL = data_d1.COMPLAINT_URL;
dbTraCcfD1.COMPLAINT_ATT = data_d1.COMPLAINT_ATT;
dbTraCcfD1.COORDINATOR_RESPONSE_DATE = data_d1.COORDINATOR_RESPONSE_DATE;
dbTraCcfD1.COORDINATOR_NOTE = data_d1.COORDINATOR_NOTE;
dbTraCcfD1.COORDINATOR_PROMISED_DATE = data_d1.COORDINATOR_PROMISED_DATE;
dbTraCcfD1.COORDINATOR_URL = data_d1.COORDINATOR_URL;
dbTraCcfD1.COORDINATOR_ATT = data_d1.COORDINATOR_ATT;
_ccfService.Save_d1(dbTraCcfD1);
}
FMSEntities context = new FMSEntities();
var query = from p in context.TRA_CCF
where p.TRA_CCF_ID == dbTraCcf.TRA_CCF_ID
select p;
foreach (TRA_CCF dt in query)
{
dt.DOCUMENT_STATUS = dbTraCcf.DOCUMENT_STATUS;
}
context.SaveChanges();
}
else if (dbTraCcfD1.COORDINATOR_NOTE != null && dbTraCcfD1.VENDOR_NOTE != null)
{
var data_d1 = _ccfService.GetCcfD1().Where(c => c.TRA_CCF_DETAIL_ID == Dto.DetailSave.TraCcfDetilId).FirstOrDefault();
if (data_d1 == null)
{
_ccfService.Save_d1(dbTraCcfD1);
}
else
{
dbTraCcfD1.COMPLAINT_DATE = data_d1.COMPLAINT_DATE;
dbTraCcfD1.COMPLAINT_NOTE = data_d1.COMPLAINT_NOTE;
dbTraCcfD1.COMPLAINT_URL = data_d1.COMPLAINT_URL;
dbTraCcfD1.COMPLAINT_ATT = data_d1.COMPLAINT_ATT;
if (dbTraCcfD1.COORDINATOR_ATT == null)
{
dbTraCcfD1.COORDINATOR_ATT = data_d1.COORDINATOR_ATT;
}
if (dbTraCcfD1.VENDOR_ATT == null)
{
dbTraCcfD1.VENDOR_ATT = data_d1.VENDOR_ATT;
}
_ccfService.Save_d1(dbTraCcfD1);
}
FMSEntities context = new FMSEntities();
var query = from p in context.TRA_CCF
where p.TRA_CCF_ID == dbTraCcf.TRA_CCF_ID
select p;
foreach (TRA_CCF dt in query)
{
dt.DOCUMENT_STATUS = dbTraCcf.DOCUMENT_STATUS;
}
context.SaveChanges();
}
else if (dbTraCcfD1.COORDINATOR_NOTE == null && dbTraCcfD1.VENDOR_NOTE == null && dbTraCcf.DOCUMENT_STATUS == (int)Enums.DocumentStatus.InProgress)
{
// _ccfService.Save_d1(dbTraCcfD1);
FMSEntities context3 = new FMSEntities();
context3.TRA_CCF_DETAIL.Add(new TRA_CCF_DETAIL()
{
TRA_CCF_ID = dbTraCcf.TRA_CCF_ID,
COMPLAINT_DATE = dbTraCcfD1.COMPLAINT_DATE,
COMPLAINT_NOTE = dbTraCcfD1.COMPLAINT_NOTE,
COMPLAINT_URL = dbTraCcfD1.COMPLAINT_URL,
COMPLAINT_ATT = dbTraCcfD1.COMPLAINT_ATT
});
context3.SaveChanges();
}
FMSEntities context2 = new FMSEntities();
context2.TRA_CHANGES_HISTORY.Add(new TRA_CHANGES_HISTORY()
{
MODUL_ID = (int)Enums.MenuList.TraCcf,
FORM_ID = dbTraCcf.TRA_CCF_ID,
MODIFIED_BY = userLogin.USER_ID,
MODIFIED_DATE = DateTime.Now,
ACTION = "Modified"
});
context2.SaveChanges();
}
else
{
dbTraCcf = Mapper.Map <TRA_CCF>(Dto);
dbTraCcfD1 = Mapper.Map <TRA_CCF_DETAIL>(Dto.DetailSave);
_ccfService.Save(dbTraCcf, userLogin);
var dataCCF = _ccfService.GetCcf().Where(x => x.DOCUMENT_NUMBER == Dto.DocumentNumber).FirstOrDefault();
dbTraCcfD1.TRA_CCF_ID = dataCCF.TRA_CCF_ID;
_ccfService.Save_d1(dbTraCcfD1);
}
//Exec Prosedure KPI
EntityConnectionStringBuilder e = new EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings["FMSEntities"].ConnectionString);
string connectionString = e.ProviderConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand query1 = new SqlCommand("EXEC KPICoordinator @TraCCFId = " + dbTraCcf.TRA_CCF_ID + "", con);
query1.ExecuteNonQuery();
SqlCommand query2 = new SqlCommand("EXEC KPIVendor @TraCCFId = " + dbTraCcf.TRA_CCF_ID + "", con);
query2.ExecuteNonQuery();
con.Close();
_uow.SaveChanges();
}
catch (Exception exception)
{
throw exception;
}
var data = _ccfService.GetCcf().Where(x => x.DOCUMENT_NUMBER == Dto.DocumentNumber).FirstOrDefault();
Dto = Mapper.Map <TraCcfDto>(data);
return(Dto);
}
public void AddFishOrder(FishOrder order)
{
_db.FishOrders.Add(order);
_db.SaveChanges();
}
//Add Shipping Arrival
public void AddShipping(Shipping shipping)
{
_db.Shippings.Add(shipping);
_db.SaveChanges();
}
public void AddCustomerPayment(CustomerPayment payment)
{
_db.CustomerPayments.Add(payment);
_db.SaveChanges();
}
public void AddSecretary(Secretary sec)
{
_db.Secretaries.Add(sec);
_db.SaveChanges();
}
public void AddFish(Fish fish)
{
_db.Fish.Add(fish);
_db.SaveChanges();
}
public void AddCEO(CEO ceo)
{
_db.CEOs.Add(ceo);
_db.SaveChanges();
}
public void AddCustomer(Customer customer)
{
_db.Customers.Add(customer);
_db.SaveChanges();
}