public async Task <String> lockRec(int id)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
var tbl = await db.tblSaleOrders.FirstOrDefaultAsync(x => x.id == id);
if (tbl == null)
{
return("Sale Order not found !");
}
if (tbl.slor_LockBy != null)
{
if (tbl.slor_LockBy != user.id)
{
var _u = await db.tblUsers.FirstOrDefaultAsync(x => x.id == tbl.slor_LockBy);
if (_u != null)
{
return("Record is currently in use by " + _u.userName + " !");
}
}
}
tbl.slor_LockBy = user.id;
tbl.slor_LockOn = DateTime.Now;
await db.SaveChangesAsync();
return("True");
}
// edit user
public ActionResult Edit(int ID, string userName, string password, int userLevel, string userEmail)
{
UserViewDTO userView = new UserViewDTO(ID, userName, password, userLevel, userEmail);
ViewData["User"] = userView;
return(View());
}
//-> SelectByID
public async Task <CustomerViewDTO> SelectByID(int id)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
var record = await db.tblCustomers.FirstOrDefaultAsync(x => x.deleted == null && x.id == id &&
(_user == -1? 1 == 1 : _user == x.cust_UserID)
);
if (record == null)
{
return(new CustomerViewDTO());
}
return(MappingHelper.MapDBClassToDTO <tblCustomer, CustomerViewDTO>(record));
}
// save user after editing
public ActionResult saveUser(UserViewDTO userView)
{
if (userView.UserName == null || userView.Password == null || userView.UserLevel == 0 || userView.UserEmail == null || userView.UID == 0)
{
ViewData["User"] = userView;
return(View("Edit"));
}
else
{
UserWSReference.UserDTO user = new UserWSReference.UserDTO
{
UID = userView.UID,
UserName = userView.UserName,
Password = userView.Password,
UserLevel = userView.UserLevel,
UserEmail = userView.UserEmail
};
if (userClient.IsUserUpdated(user))
{
return(RedirectToAction("Index"));
}
else
{
return(View("Edit"));
}
}
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
/*
* var controllerName = filterContext.RouteData.Values["controller"].ToString();
* var actionName = filterContext.RouteData.Values["action"].ToString();
* if (controllerName == "Foo" && actionName == "Bar")
* {
* return;
* }
*/
var session = filterContext.HttpContext.Session;
UserViewDTO user = (UserViewDTO)session["user"];
if (session == null || user == null)
{
RedirectToLogin(filterContext);
}
else
{
var isValidSession = new AuthHandler().IsValidSession(user);
if (isValidSession == false)
{
RedirectToLogin(filterContext);
}
else
{
return;
}
}
}
public ActionResult EditUsers()
{
var Roles = roleManager.GetAll();
var CustomView = new UserViewDTO()
{
Roles = Roles
};
ModelState.Clear();
return(View(CustomView));
}
//-> IsValidSession
public bool IsValidSession(UserViewDTO userDTO)
{
//var session = EncryptString(userDTO.session);
var session = CryptingHelper.EncryptString(userDTO.session);
var user = db.tblUsers.FirstOrDefault(x => x.deleted == null && x.id == userDTO.id && x.session == session);
if (user == null)
{
return(false);
}
return(true);
}
public ObjectResult GetById([FromRoute] int id)
{
try
{
UserViewDTO user = _service.GetById(id);
return(Ok(user));
}
catch (UserNotFoundException ex)
{
return(NotFound(ex.Message));
}
catch (Exception ex)
{
return(StatusCode(500, $"Ocorreu um erro inesperado: {ex.Message}"));
}
}
// add user to database
public ActionResult AddUser(UserViewDTO userView)
{
UserWSReference.UserDTO user = new UserWSReference.UserDTO
{
UID = userView.UID,
UserName = userView.UserName,
Password = userView.Password,
UserLevel = userView.UserLevel,
UserEmail = userView.UserEmail
};
if (userClient.IsUserInserted(user))
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Create"));
}
}
//-> New
public async Task <CustomerViewDTO> New(CustomerNewDTO newDTO)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
if (user != null)
{
newDTO.cust_UserID = user.id;
}
newDTO = StringHelper.TrimStringProperties(newDTO);
var record = (tblCustomer)MappingHelper.MapDTOToDBClass <CustomerNewDTO, tblCustomer>(newDTO, new tblCustomer());
record.createdDate = DateTime.Now;
db.tblCustomers.Add(record);
await db.SaveChangesAsync();
db.Entry(record).Reload();
return(await SelectByID(record.id));
}
//-> Save
public async Task <SaleOrderViewDTO> Edit(SaleOrderEditDTO editDTO)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
editDTO = StringHelper.TrimStringProperties(editDTO);
editDTO.date = editDTO.date.ToDBDate();
editDTO.requiredDate = editDTO.requiredDate.ToDBDate();
var record = await db.tblSaleOrders.FirstOrDefaultAsync(r => r.deleted == null && r.id == editDTO.id);
if (record == null)
{
throw new HttpException((int)HttpStatusCode.NotFound, "NotFound");
}
editDTO.updatedDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
record = (tblSaleOrder)MappingHelper.MapDTOToDBClass <SaleOrderEditDTO, tblSaleOrder>(editDTO, record);
record.updatedDate = DateTime.Now;
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
if (user != null)
{
record.updatedBy = user.id;
}
record.slor_LockBy = null;
record.slor_LockOn = null;
var lineItems = await EditLineItem(record.id, editDTO);
record.total = lineItems.Sum(item => item.total);
await db.SaveChangesAsync();
transaction.Commit();
return(await SelectByID(record.id));
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
public async Task <vSaleOrderDTO> SelectByIDList(int id)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
else
{
return(new vSaleOrderDTO());
}
var record = await db.vSaleOrders.FirstOrDefaultAsync(x => x.slor_Deleted == null && x.slor_SaleOrderID == id
//var record = await db.vSaleOrders.FirstOrDefaultAsync(x => x.slor_Deleted == null && x.slor_SaleOrderID == id &&
//&&(_user == -1 ? 1 == 1 : _user == x.cust_UserID)
);
if (record == null)
{
return(new vSaleOrderDTO());
}
//throw new HttpException((int)HttpStatusCode.NotFound, "NotFound");
var saleOrderDTO = MappingHelper.MapDBClassToDTO <vSaleOrder, vSaleOrderDTO>(record);
//saleOrderDTO.customer = await new CustomerHandler().SelectByID(int.Parse(record.customerID.ToString()));
//saleOrderDTO.items = await GetLineItems(id);
return(saleOrderDTO);
}
//-> New
public async Task <SaleOrderViewDTO> New(SaleOrderNewDTO newDTO)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
if (user != null)
{
newDTO.slor_UserID = user.id;
}
newDTO = StringHelper.TrimStringProperties(newDTO);
newDTO.date = newDTO.date.ToDBDate();
newDTO.requiredDate = newDTO.requiredDate.ToDBDate();
var record = (tblSaleOrder)MappingHelper.MapDTOToDBClass <SaleOrderNewDTO, tblSaleOrder>(newDTO, new tblSaleOrder());
record.createdDate = DateTime.Now;
record.createdBy = user.id;
db.tblSaleOrders.Add(record);
await db.SaveChangesAsync();
var lineItems = await SaveLineItem(record.id, newDTO);
record.total = lineItems.Sum(item => item.total);
await db.SaveChangesAsync();
db.Entry(record).Reload();
transaction.Commit();
return(await SelectByID(record.id));
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
//-> GetList
public async Task <GetListDTO <CustomerViewDTO> > GetList(CustomerFindDTO findDTO)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
IQueryable <tblCustomer> query = db.tblCustomers.Where(x => x.deleted == null);
if (!string.IsNullOrEmpty(findDTO.code))
{
query = query.Where(x => x.code.StartsWith(findDTO.code));
}
if (!string.IsNullOrEmpty(findDTO.firstName))
{
query = query.Where(x => x.firstName.StartsWith(findDTO.firstName));
}
if (!string.IsNullOrEmpty(findDTO.lastName))
{
query = query.Where(x => x.lastName.StartsWith(findDTO.lastName));
}
if (_user != -1)
{
query = query.Where(x => x.cust_UserID == _user);
}
query = query.AsQueryable().OrderBy($"{findDTO.orderBy} {findDTO.orderDirection}");
return(await ListingHandler(findDTO.currentPage, query));
}
//-> GetList SaleOrderTabPaging
public async Task <GetListDTO <vSaleOrderDTO> > SaleOrderTabPaging(int customerID, int currentPage)
{
/*
* IQueryable<tblSaleOrder> records = from s in db.tblSaleOrders
* join c in db.tblCustomers on s.customerID equals c.id
* where s.deleted == null && s.customerID == customerID
* orderby s.id ascending
* select s;
* var saleOrderHandler = new SaleOrderHandler();
* return await saleOrderHandler.Listing(currentPage, records);
*/
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
/*
* IQueryable<tblSaleOrder> records = from s in db.tblSaleOrders
* join c in db.tblCustomers on s.customerID equals c.id
* where s.deleted == null && s.customerID == customerID
* && (_user == -1 ? 1==1 : _user == s.slor_UserID)
* orderby s.id ascending
* select s;*/
var records = db.vSaleOrders.Where(x => x.slor_Deleted == null &&
(_user == -1 ? 1 == 1 : _user == x.slor_UserID)).OrderBy(x => x.slor_SaleOrderID);
var saleOrderHandler = new SaleOrderHandler();
return(await saleOrderHandler.ListingHandler(currentPage, records));
}
public async Task <OperationDetails> CreateUserViewAsync(UserViewDTO userViewDto, OperationDetails MessageSuccess, OperationDetails MessageFail)
{
var resultAddressCreate = await AddressService.CreateAddressAsync
(
userViewDto.AddressView.Address,
new AddressMessageSpecification().ToSuccessCreateMessage(),
new AddressMessageSpecification().ToFailCreateMessage()
);
string addressId = resultAddressCreate.Id;
userViewDto.Person.AddressID = Convert.ToInt32(addressId);
OperationDetails UserOperationDetails = await service.CreateAccountUserAsync
(
userViewDto.Person,
MessageSuccess,
MessageFail,
new UserEquelSpecification(userViewDto.Person).ToExpression()
);
return(UserOperationDetails);
}
public void InsertTextBoxClientInformation(UserViewDTO user)
{
PersonViewModel = PersonViewModel ?? new PersonPropertyViewModel <UserDTO>(user);
PersonViewModel.InsertComboboxPersonInformation(user.Person);
PersonViewModel.AddressViewModel.InsertComboboxAddressInformation(user.AddressView);
}
public async Task <string> CreateUser(UserViewDTO userViewDto)
{
return((await new SendToServerService <OperationDetails, UserViewDTO>().PostDataByJsonObjectAsync("User/CreateUserViewAsync", userViewDto)).Result.Id);
}
public async Task <OperationDetails> CreateUserViewAsync(UserViewDTO userViewDto)
{
return(await userService.CreateUserViewAsync(userViewDto,
new UserMessageSpecification().ToSuccessCreateMessage(),
new UserMessageSpecification().ToFailCreateMessage()));
}
//-> SelectByID
public async Task <SaleOrderViewDTO> SelectByID(int id, bool _lock = false)
{
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
else
{
return(new SaleOrderViewDTO());
}
var record = await db.tblSaleOrders.FirstOrDefaultAsync(x => x.deleted == null && x.id == id
//var record = await db.vSaleOrders.FirstOrDefaultAsync(x => x.slor_Deleted == null && x.slor_SaleOrderID == id &&
//&&(_user == -1 ? 1 == 1 : _user == x.cust_UserID)
);
if (_user != -1)
{
var cust = await db.tblCustomers.FirstOrDefaultAsync(x => x.id == record.customerID);
if (cust != null)
{
if (cust.cust_UserID != _user)
{
return(new SaleOrderViewDTO());
}
}
}
if (record == null)
{
return(new SaleOrderViewDTO());
}
//throw new HttpException((int)HttpStatusCode.NotFound, "NotFound");
if (_lock)
{
if (record.slor_LockBy != null)
{
if (record.slor_LockBy != user.id)
{
var tt = new SaleOrderViewDTO();
tt.status = "_inuse";
tt.code = record.code;
var _u = await db.tblUsers.FirstOrDefaultAsync(x => x.id == record.slor_LockBy);
if (_u != null)
{
tt.product = _u.userName;
}
return(tt);
}
}
record.slor_LockBy = user.id;
record.slor_LockOn = DateTime.Now;
await db.SaveChangesAsync();
}
var saleOrderDTO = MappingHelper.MapDBClassToDTO <tblSaleOrder, SaleOrderViewDTO>(record);
saleOrderDTO.customer = await new CustomerHandler().SelectByID(int.Parse(record.customerID.ToString()));
saleOrderDTO.items = await GetLineItems(id);
return(saleOrderDTO);
}
//-> GetList
public async Task <GetListDTO <vSaleOrderDTO> > GetList(SaleOrderFindDTO findDTO)
{
/*
* IQueryable<tblSaleOrder> records = from s in db.tblSaleOrders
* join c in db.tblCustomers on s.customerID equals c.id
* where s.deleted == null
* && (string.IsNullOrEmpty(findDTO.code) ? 1 == 1 : s.code.Contains(findDTO.code))
* && (string.IsNullOrEmpty(findDTO.status) ? 1 == 1 : s.status == findDTO.status)
* && (string.IsNullOrEmpty(findDTO.customer) ? 1 == 1 : c.firstName.Contains(findDTO.customer))
* orderby s.id ascending
* select s;
*
* return await Listing(findDTO.currentPage, records);
*/
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
int _user = 0;
if (user != null)
{
_user = user.id;
if (user.user_Profile == 1)
{
_user = -1;
}
}
/*
* IQueryable<SaleOrderFindResultDTO> query = from s in db.vSaleOrders
* //join c in db.tblCustomers on s.cust_CustomerID equals c.id
* where s.slor_Deleted == null
* && (string.IsNullOrEmpty(findDTO.code) ? 1 == 1 : s.cust_Code.Contains(findDTO.code))
* && (string.IsNullOrEmpty(findDTO.status) ? 1 == 1 : s.slor_Status == findDTO.status)
* && (string.IsNullOrEmpty(findDTO.customer) ? 1 == 1 : s.cust_FirstName.Contains(findDTO.customer))
* && (findDTO.customerID == 0 ? 1 == 1 : s.cust_CustomerID == findDTO.customerID)
* //&& (_user == -1 ? 1 == 1 : c.cust_UserID == _user)
* select new SaleOrderFindResultDTO
* {
* id = s.slor_SaleOrderID,
* code = s.slor_Code,
* date = s.slor_Date,
* firstName = s.cust_FirstName,
* total = s.slor_Total,
* status = s.slor_Status
* };
*/
//return await Listing(findDTO.currentPage, records);
var query = db.vSaleOrders.Where(x => x.slor_Deleted == null &&
(string.IsNullOrEmpty(findDTO.code) ? 1 == 1 : x.cust_Code.Contains(findDTO.code)) &&
(string.IsNullOrEmpty(findDTO.status) ? 1 == 1 : x.slor_Status == findDTO.status) &&
(string.IsNullOrEmpty(findDTO.customer) ? 1 == 1 : x.cust_FirstName.Contains(findDTO.customer) || x.cust_LastName.Contains(findDTO.customer)) &&
(string.IsNullOrEmpty(findDTO.slor_SourceOfSupply) ? 1 == 1 : x.slor_SourceOfSupply.ToString() == findDTO.slor_SourceOfSupply) &&
(string.IsNullOrEmpty(findDTO.slor_TruckNo) ? 1 == 1 : x.slor_TruckNo.Contains(findDTO.slor_TruckNo)) &&
(string.IsNullOrEmpty(findDTO.slor_DocNo) ? 1 == 1 : x.slor_DocNo.Contains(findDTO.slor_DocNo)) &&
(string.IsNullOrEmpty(findDTO.slor_ShipmentNo) ? 1 == 1 : x.slor_ShipmentNo.Contains(findDTO.slor_ShipmentNo)) &&
(string.IsNullOrEmpty(findDTO.slor_TruckDriverPhoneNo) ? 1 == 1 : x.slor_TruckDriverPhoneNo.Contains(findDTO.slor_TruckDriverPhoneNo)) &&
(string.IsNullOrEmpty(findDTO.slor_Code) ? 1 == 1 : x.slor_Code.Contains(findDTO.slor_Code)) &&
(string.IsNullOrEmpty(findDTO.slor_SONo) ? 1 == 1 : x.slor_SONo.Contains(findDTO.slor_SONo)) &&
(string.IsNullOrEmpty(findDTO.shipMode) ? 1 == 1 : x.slor_ShipConidtion.Contains(findDTO.shipMode)) &&
(findDTO.customerID == 0 ? 1 == 1 : x.cust_CustomerID == findDTO.customerID)
);
DateTime?fromDate = null;
DateTime?toDate = null;
if (!string.IsNullOrEmpty(findDTO.slor_RequiredDate_From) && !string.IsNullOrEmpty(findDTO.slor_RequiredDate_To))
{
fromDate = DateTime.ParseExact(findDTO.slor_RequiredDate_From, ConstantHelper.ddMMyyyy_DASH_SEPARATOR, CultureInfo.InvariantCulture);
toDate = DateTime.ParseExact(findDTO.slor_RequiredDate_To, ConstantHelper.ddMMyyyy_DASH_SEPARATOR, CultureInfo.InvariantCulture);
}
if (!string.IsNullOrEmpty(findDTO.slor_RequiredDate_From) && !string.IsNullOrEmpty(findDTO.slor_RequiredDate_To))
{
query = query.Where(x => DbFunctions.TruncateTime(x.slor_RequiredDate) >= DbFunctions.TruncateTime(fromDate) && DbFunctions.TruncateTime(x.slor_RequiredDate) <= DbFunctions.TruncateTime(toDate));
}
return(await ListingHandler(findDTO.currentPage, query.AsQueryable().OrderBy($"{findDTO.orderBy} {findDTO.orderDirection}")));
}
public async Task <String> QEdit(int id, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var record = await db.tblSaleOrders.FirstOrDefaultAsync(r => r.deleted == null && r.id == id);
if (record == null)
{
return("Sale Order not found !");
}
//newDTO.requiredDate = newDTO.requiredDate.ToDBDate();
record.updatedDate = DateTime.Now;
//record.slor_DocNo = p1;
record.requiredDate = DateTime.ParseExact(p1, ConstantHelper.ddMMyyyy_DASH_SEPARATOR, CultureInfo.InvariantCulture);
if (string.IsNullOrEmpty(p2))
{
record.sourceOfSupplyID = null;
}
else
{
record.sourceOfSupplyID = int.Parse(p2);
}
record.slor_TruckNo = p3;
record.slor_TruckDriverPhoneNo = p4;
record.slor_DocNo = p5;
record.slor_ShipmentNo = p6;
//record.slor_ShipmentNo = p2;
record.status = p8;
var session = HttpContext.Current.Session;
UserViewDTO user = (UserViewDTO)session["user"];
if (user != null)
{
if (p8 == "Processed")
{
record.slor_Status1By = user.id;
record.slor_Status1Date = DateTime.Now;
}
if (p8 == "Complete")
{
record.slor_Status2By = user.id;
record.slor_Status2Date = DateTime.Now;
}
if (p8 == "Cancelled")
{
record.slor_Status3By = user.id;
record.slor_Status3Date = DateTime.Now;
}
if (p8 == "Rejected")
{
record.slor_Status4By = user.id;
record.slor_Status4Date = DateTime.Now;
}
if (p8 == "Insufficient balance")
{
record.slor_Status5By = user.id;
record.slor_Status5Date = DateTime.Now;
}
if (p8 == "Pending")
{
record.slor_Status6By = user.id;
record.slor_Status6Date = DateTime.Now;
}
}
record.pickUp = (string.IsNullOrEmpty(p9) ? null : p9);
record.slor_TransportZone = p10;
record.slor_SONo = p11;
record.slor_ShipConidtion = p12;
record.slor_LockBy = null;
record.slor_LockOn = null;
if (user != null)
{
record.updatedBy = user.id;
}
await db.SaveChangesAsync();
transaction.Commit();
return("True");
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
