private questStatus read(FMSEntities dbContext, GroupUserId groupUserId, out Quest.Services.Dbio.FMS.GroupUsers groupUser)
{
// Initialize
groupUser = null;
try
{
groupUser = dbContext.GroupUsers.Where(r => r.Id == groupUserId.Id).SingleOrDefault();
if (groupUser == null)
{
return(new questStatus(Severity.Warning, String.Format("WARNING: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("Id {0} not found", groupUserId.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 read(FMSEntities dbContext, PrivilegeId privilegeId, out List <Quest.Services.Dbio.FMS.UserPrivileges> userPrivilegeList)
{
// Initialize
userPrivilegeList = null;
try
{
userPrivilegeList = dbContext.UserPrivileges.Where(r => r.PrivilegeId == privilegeId.Id).ToList();
if (userPrivilegeList == null)
{
return(new questStatus(Severity.Warning, String.Format("WARNING: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
String.Format("PrivilegeId {0} not found", privilegeId.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));
}
/*==================================================================================================================================
* Properties
*=================================================================================================================================*/
#endregion
#region Public Methods
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(User user, out UserId userId)
{
// Initialize
questStatus status = null;
userId = null;
// Data rules.
user.Created = DateTime.Now;
user.Password = _aesEncryption.Encrypt(user.Password);
// Create the user
using (FMSEntities dbContext = new FMSEntities())
{
status = create(dbContext, user, out userId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
public SecretaryTransactionController()
{
_db = new FMSEntities();
}
public CannoeController()
{
_db = new FMSEntities();
}
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);
}
/// <summary>
/// Reverts the changes.
/// </summary>
public void RevertChanges()
{
//overwrite the existing context with a new, fresh one to revert all the changes
_context = new FMSEntities();
}
public CustomerController()
{
_db = new FMSEntities();
}
public questStatus List(QueryOptions queryOptions, out List <User> userList, out QueryResponse queryResponse)
{
// Initialize
questStatus status = null;
userList = null;
queryResponse = null;
using (FMSEntities dbContext = new FMSEntities())
{
using (DbContextTransaction tx = dbContext.Database.BeginTransaction(IsolationLevel.ReadUncommitted))
{
try
{
// TEST
////int _totalRecords2 = dbContext.Users.Where("CONVERT(date, Created) = '2016-07-08'").Count();
////int _totalRecords2 = dbContext.Users.Where(String.Format("Created = ")).Count();
////int _totalRecords2 = dbContext.Users.Where(string.Format("{0} = @0", "Created"),
//// DateTime.Parse("2016-07-08")).Count();
////int _totalRecords2 = dbContext.Users.Where(string.Format("{0} == @0", "Created"),
//// DateTime.Parse("2016-07-08")).Count();
////int _totalRecords2 = dbContext.Users.Where(String.Format("{0} >= @0 AND {0} < @1", "Created"),
//// DateTime.Parse("2016-07-08"), DateTime.Parse("2016-07-09")).Count();
////"DateAdded >= DateTime(2013, 06, 18)"
////int _totalRecords2 = dbContext.Users.Where("Created >= DateTime(2016, 07, 08)").Count();
////_totalRecords2 = dbContext.Users.Where("( Created >= DateTime(2016, 07, 08) AND Created < DateTime(2016, 07, 09) )").Count();
PropertyInfo[] dbProperties = typeof(Quest.Services.Dbio.FMS.Users).GetProperties().ToArray();
int totalRecords = dbContext.Users.Where(BuildWhereClause(queryOptions, dbProperties)).Count();
List <Quest.Services.Dbio.FMS.Users> _usersList = dbContext.Users.Where(BuildWhereClause(queryOptions, dbProperties))
.OrderBy(BuildSortString(queryOptions.SortColumns))
.Skip(queryOptions.Paging.PageSize * (queryOptions.Paging.PageNumber - 1))
.Take(queryOptions.Paging.PageSize).ToList();
if (_usersList == null)
{
return(new questStatus(Severity.Warning));
}
userList = new List <User>();
foreach (Quest.Services.Dbio.FMS.Users _user in _usersList)
{
User user = new User();
BufferMgr.TransferBuffer(_user, user);
userList.Add(user);
}
status = BuildQueryResponse(totalRecords, queryOptions, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
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 CustomerTransactionController()
{
_db = new FMSEntities();
}
public ShippingDetailController()
{
_db = new FMSEntities();
}
public SqlGenericRepository(FMSEntities context, ILogger logger)
{
_context = context;
_logger = logger;
_dbSet = context.Set <TEntity>();
}
public FishOrderController()
{
_db = new FMSEntities();
}
public FishTypeController()
{
_db = new FMSEntities();
}
public SecretaryController()
{
_db = new FMSEntities();
}
public SalersController()
{
_db = new FMSEntities();
}
public CeoController()
{
_db = new FMSEntities();
}
public ActionResult Create(PriceListItem item)
{
//if (ModelState.IsValid)
//{
FMSEntities entities = new FMSEntities();
//String message = "";
bool valid = true;
var vehicleSpect = entities.MST_VEHICLE_SPECT.Where(x => (x.YEAR == item.Year) && (x.MANUFACTURER == item.Manufacture) && (x.MODEL == item.Model) && (x.SERIES == item.Series)).ToList();
var vendor = entities.MST_VENDOR.Where(X => (X.SHORT_NAME == item.Vendor + "")).ToList();
var vehicleType = entities.MST_SETTING.Where(x => (x.SETTING_GROUP == "VEHICLE_TYPE") && (x.SETTING_VALUE == item.VehicleType)).ToList();
string vehicleUsageText = "";
if (item.VehicleType.Equals("WTC"))
{
vehicleUsageText = "VEHICLE_USAGE_BENEFIT";
}
else if (item.VehicleType.Equals("Benefit"))
{
vehicleUsageText = "VEHICLE_USAGE_WTC";
}
var vehicleUsage = entities.MST_SETTING.Where(x => (x.SETTING_GROUP == vehicleUsageText) && (x.SETTING_VALUE == item.VehicleUsage)).ToList();
if (vehicleSpect.Count == 0)
{
valid = false;
ViewData["message"] = "Data not exists in vehicle spect";
}
else if (vendor.Count == 0)
{
valid = false;
ViewData["message"] = "Data not exists in vendor";
}
else if (vehicleType.Count == 0)
{
valid = false;
ViewData["message"] = "Data not exists in vehicle type";
}
else if (vehicleUsage.Count == 0)
{
valid = false;
ViewData["message"] = "Data not exists in vehicle usage";
}
else
{
valid = true;
}
if (valid)
{
//var data = Mapper.Map<PriceListDto>(item);
//data.CreatedBy = CurrentUser.USERNAME;
//data.CreatedDate = DateTime.Today;
//data.ModifiedDate = null;
//try
//{
// _priceListBLL.Save(data);
//}
//catch (Exception ex)
//{
// var msg = ex.Message;
//}
return(RedirectToAction("Index", "MstPriceList"));
}
else
{
var model = new PriceListItem();
model.MainMenu = _mainMenu;
model.CurrentLogin = CurrentUser;
model = listdata(model);
var VendorList = _vendorBLL.GetVendor();
model.VendorList = new SelectList(VendorList, "MstVendorId", "VendorName");
return(View(model));
}
//}
}
