public void Create(ShopCreateModel shopCreateModel, int UserId)
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
var Shop = Mapper.Map <Shop>(shopCreateModel);
Shop.UserId = UserId;
uow.Shops.Create(Shop);
var Images = _FileSaver.SaveAdvertisementImages(Shop, shopCreateModel.FormImages);
foreach (var Image in Images)
{
uow.Images.Create(Image);
}
}
}
private void btnGenLoad_Click(object sender, EventArgs e)
{
try
{
var checkedItems = new List <ModuleEntity>();
string sns = "";
foreach (DataGridViewRow row in modulesGridView.Rows)
{
ModuleEntity module = (ModuleEntity)row.DataBoundItem;
if (Convert.ToBoolean(row.Cells[0].Value))
{
checkedItems.Add(module);
sns += module.Name + ",";
}
}
sns = sns.TrimEnd(',');
AssignLoadDialog dialog = new AssignLoadDialog();
dialog.SelectedModules = sns;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
dialog.LoadNumber = uow.ModuleRepository
.GetNextManualLoadNumber(CottonDBMS.GinApp.Helpers.ConfigHelper.LoadPrefix + "M", 7);
if (dialog.ShowDialog() == DialogResult.OK)
{
var checkedIds = checkedItems.Select(m => m.Id).ToList();
var modules = uow.ModuleRepository.FindMatching(m => checkedIds.Contains(m.Id));
foreach (var m in modules)
{
m.LoadNumber = dialog.LoadNumber;
m.SyncedToCloud = false;
uow.ModuleRepository.Save(m);
}
uow.SaveChanges();
refresh();
}
}
}
catch (Exception exc)
{
Logging.Logger.Log(exc);
MessageBox.Show(exc.Message);
}
}
public ClientEntity GetOrCreateClientEntity()
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (this.IsNew)
{
return(uow.ClientRepository.EnsureClientCreated(tbNewClient.Text, InputSource.GIN));
}
else if (ExistingSelected)
{
return(uow.ClientRepository.GetById(SelectedClientId, "Farms.Fields"));
}
else
{
return(null);
}
}
}
public ShopDetailsModel GetDetailsModel(int Id, int CommentCount)
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
var Model = Mapper.Map <ShopDetailsModel>(uow.Shops.GetFullShop(Id));
Model.Comments = uow.Comments.GetUserComments(Id);
Model.CommentCount = CommentCount;
Model.CommentCount += Model.CommentPart;
if (Model.Comments.Count > Model.CommentPart && Model.Comments.Count / Model.CommentPart > Model.CommentCount / Model.CommentPart)
{
Model.Comments.RemoveRange(Model.CommentCount - 1, Model.Comments.Count - Model.CommentCount);
}
Model.Comments = Model.Comments.OrderByDescending(i => i.DateTime).ToList();
return(Model);
}
}
private void CalcWeights()
{
string truck = (cboTruck.SelectedIndex > 0) ? ((BaseEntity)cboTruck.SelectedItem).Name : "";
Task.Run(() =>
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
var truckEntity = uow.TruckRepository.FindSingle(t => t.Name == truck);
decimal truckTareWeight = 0.00M;
if (truckEntity != null)
{
truckTareWeight = truckEntity.TareWeight;
}
SetWeights(truckTareWeight);
}
});
}
public DialogResult Show(ModuleEntity doc)
{
historyDataGrid.AutoGenerateColumns = false;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
//reload document to ensure we have the freshest history
_module = uow.ModuleRepository.GetById(doc.Id, new string[] { "ModuleHistory", "Field.Farm.Client" });
lblClient.Text = _module.Field.Farm.Client.Name;
lblFarm.Text = _module.Field.Farm.Name;
lblField.Text = _module.Field.Name;
lblSerialNo.Text = _module.Name;
lblLoad.Text = _module.LoadNumber;
lblLocationValue.Text = string.Format("{0}, {1}", _module.Latitude, _module.Longitude);
historyDataGrid.DataSource = _module.ModuleHistory.OrderBy(t => t.Created).ToList();
}
return(this.ShowDialog());
}
private void LoadAutocompletes()
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
IEnumerable <ClientEntity> clients = uow.ClientRepository.GetAll(new string[] { "Farms.Fields" }).OrderBy(c => c.Name);
IEnumerable <TruckEntity> trucks = uow.TruckRepository.GetAll().OrderBy(c => c.Name);
IEnumerable <DriverEntity> drivers = uow.DriverRepository.GetAll().OrderBy(d => d.Name);
AutoCompleteStringCollection clientCollection = new AutoCompleteStringCollection();
AutoCompleteStringCollection farmsCollection = new AutoCompleteStringCollection();
AutoCompleteStringCollection fieldsCollection = new AutoCompleteStringCollection();
foreach (var c in clients)
{
clientCollection.Add(c.Name);
foreach (var farm in c.Farms)
{
farmsCollection.Add(farm.Name);
foreach (var field in farm.Fields)
{
fieldsCollection.Add(field.Name);
}
}
}
tbClient.AutoCompleteCustomSource = clientCollection;
tbFarm.AutoCompleteCustomSource = farmsCollection;
tbField.AutoCompleteCustomSource = fieldsCollection;
AutoCompleteStringCollection trucksCollection = new AutoCompleteStringCollection();
foreach (var t in trucks)
{
trucksCollection.Add(t.Name);
}
tbTruck.AutoCompleteCustomSource = trucksCollection;
AutoCompleteStringCollection driversCollection = new AutoCompleteStringCollection();
foreach (var d in drivers)
{
driversCollection.Add(d.Firstname + " " + d.Lastname);
}
tbDriver.AutoCompleteCustomSource = driversCollection;
}
}
public override async void Execute(object parameter)
{
using (var unitOfWork = _unitOfWorkFactory.CreateUnitOfWork())
{
_user = unitOfWork.UserRepository.GetUser(_repairClientViewModel.User.Id);
RepairOrder newOrder = new RepairOrder()
{
Status = OrderStatus.Accepted,
ClientFIO = _repairClientViewModel.ClientFIO,
Image = _repairClientViewModel.Image,
Description = _repairClientViewModel.Description,
User = _user
};
unitOfWork.RepairOrderRepository.Create(newOrder);
await unitOfWork.SaveAsync();
}
_repairClientViewModel.NavigateToOrdersClientCommand.Execute(null);
}
IReportInfo GetReport(EmployeeReportType reportType)
{
Logger.Log(string.Format("HybridApp: Create Report : Employees: {0}", reportType.ToString()));
switch (reportType)
{
case EmployeeReportType.TaskList:
return(ReportInfoFactory.EmployeeTaskList(UnitOfWorkFactory.CreateUnitOfWork().Tasks.ToList()));
case EmployeeReportType.Profile:
return(ReportInfoFactory.EmployeeProfile(SelectedEntity));
case EmployeeReportType.Summary:
return(ReportInfoFactory.EmployeeSummary(Entities));
case EmployeeReportType.Directory:
return(ReportInfoFactory.EmployeeDirectory(Entities));
}
throw new ArgumentException("", "reportType");
}
private void loadMore()
{
if (lastResult.TotalPages > lastResult.LastPageNo)
{
loading = true;
BusyMessage.Show("Loading...", this.FindForm());
var filter = loadFilterBar.Filter;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
lastResult = uow.GinLoadRepository.GetLoads(filter, pageSize, lastResult.LastPageNo + 1);
foreach (var item in lastResult.ResultData)
{
loadBindingSource.Add(item);
}
BusyMessage.Close();
}
loading = false;
}
}
private void refresh()
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
//load filters
var filter = pickupListFilterBar.Filter;
pickupListFilterBar.Enabled = false;
BusyMessage.Show("Loading...", this.FindForm());
PagedResult <PickupListEntity> result = uow.PickupListRepository.GetLists(filter, pageSize, 1, ConfigHelper.ModulesPerLoad);
listBindingSource.DataSource = result.ResultData;
lastResult = result;
gridView.DataSource = listBindingSource;
gridView.AutoGenerateColumns = false;
gridView.Columns[0].ReadOnly = false;
checkbox.Checked = false;
pickupListFilterBar.Enabled = true;
BusyMessage.Close();
}
}
private void loadMore()
{
if (gridView.RowCount < lastResult.Total)
{
loading = true;
BusyMessage.Show("Loading...", this.FindForm());
var filter = pickupListFilterBar.Filter;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
PagedResult <PickupListEntity> result = uow.PickupListRepository.GetLists(filter, pageSize, lastResult.LastPageNo + 1, ConfigHelper.ModulesPerLoad);
foreach (var list in lastResult.ResultData)
{
listBindingSource.Add(list);
}
BusyMessage.Close();
}
loading = false;
}
}
void InitializeNewOrder(Order order)
{
var currentUnitOfWork = UnitOfWorkFactory.CreateUnitOfWork();
Func <Order, int> getInvoiceNumber = x => {
int number = 0;
int.TryParse(x.InvoiceNumber, out number);
return(number);
};
var maxInvoiceNumber = currentUnitOfWork.Orders.Max(getInvoiceNumber);
order.InvoiceNumber = (maxInvoiceNumber + 1).ToString();
order.OrderDate = DateTime.Now;
var customer = currentUnitOfWork.Customers.First();
order.CustomerId = customer.Id;
order.StoreId = customer.CustomerStores.First().Id;
order.EmployeeId = currentUnitOfWork.Employees.First().Id;
}
private void refresh()
{
//load filters
var filter = moduleFilterBar.Filter;
moduleFilterBar.Enabled = false;
BusyMessage.Show("Loading...", this.FindForm());
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
lastResult = uow.ModuleRepository.GetModules(filter, pageSize, 1);
moduleBindingSource.DataSource = lastResult.ResultData;
modulesGridView.DataSource = moduleBindingSource;
modulesGridView.AutoGenerateColumns = false;
modulesGridView.Columns[0].ReadOnly = false;
checkbox.Checked = false;
moduleFilterBar.Enabled = true;
BusyMessage.Close();
}
}
public async Task <DialogResult> ShowEdit(PickupListEntity doc)
{
dataObj = doc;
this.Text = "Update Pickup List";
await RefreshDownloadedTrucks();
//has list already been downloaded if so prevent removing modules
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
var thisList = uow.PickupListRepository.GetById(doc.Id, "AssignedModules", "AssignedTrucks", "DownloadedToTrucks");
if (downloadedByTrucks.Count() > 0)
{
modulesDownloaded.AddRange(thisList.AssignedModules.Select(s => s.Id).ToList());
}
}
return(this.ShowDialog());
}
private void refresh()
{
//load filters
var filter = loadFilterBar.Filter;
loadFilterBar.Enabled = false;
BusyMessage.Show("Loading...", this.FindForm());
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
lastResult = uow.GinLoadRepository.GetLoads(filter, pageSize, 1);
loadBindingSource.DataSource = lastResult.ResultData;
dataGridLoads.DataSource = loadBindingSource;
dataGridLoads.AutoGenerateColumns = false;
dataGridLoads.Columns[0].ReadOnly = false;
checkbox.Checked = false;
loadFilterBar.Enabled = true;
BusyMessage.Close();
}
}
public FarmEntity GetOrCreateFarmEntity(ClientEntity clientDoc)
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (this.IsNew)
{
var farm = uow.FarmRepository.EnsureFarmCreated(clientDoc, tbNewFarm.Text, InputSource.GIN);
uow.SaveChanges();
return(farm);
}
else if (ExistingSelected)
{
return(uow.FarmRepository.GetById(SelectedFarmId, "Client", "Fields"));
}
else
{
return(null);
}
}
}
private void ValidateSerialNumber()
{
if (string.IsNullOrWhiteSpace(tbSerialNumber.Text))
{
errorProvider.SetError(tbSerialNumber, "Serial number is requred.");
hasError = true;
}
else
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
bool result = uow.ModuleRepository.CanSaveModule((dataObj != null) ? dataObj.Id : string.Empty, tbSerialNumber.Text.Trim());
if (!result)
{
hasError = true;
errorProvider.SetError(tbSerialNumber, "Serial number already exists.");
}
}
}
}
public void LoadForm()
{
//refresh field document to ensure latest updates are loaded
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (dataObj != null)
{
dataObj = uow.FieldRepository.GetById(dataObj.Id, "Farm.Client");
}
tbField.Text = "";
clientSelector1.Initialize(formErrorProvider, true, false, (dataObj != null) ? dataObj.Farm.Client.Id : string.Empty);
farmSelector1.FormErrorProvider = formErrorProvider;
if (dataObj != null)
{
tbField.Text = dataObj.Name;
}
clearErrors();
}
}
private void ValidateListName()
{
if (string.IsNullOrWhiteSpace(tbListname.Text))
{
errorProvider.SetError(tbListname, "List name is requred.");
hasError = true;
}
else
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
bool result = uow.PickupListRepository.CanSavePickupList((dataObj != null) ? dataObj.Id : string.Empty, tbListname.Text.Trim());
if (!result)
{
hasError = true;
errorProvider.SetError(tbListname, "List name already exists.");
}
}
}
}
private void tbGinTagLoadNumber_Validating(object sender, CancelEventArgs e)
{
if (string.IsNullOrWhiteSpace(tbGinTagLoadNumber.Text))
{
errorProvider.SetError(tbGinTagLoadNumber, "Gin tag load # is required.");
hasError = true;
}
else
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
bool result = uow.GinLoadRepository.CanGinTagLoadNumber((dataObj != null) ? dataObj.Id : string.Empty, tbGinTagLoadNumber.Text.Trim());
if (!result)
{
hasError = true;
errorProvider.SetError(tbGinTagLoadNumber, "Gin ticket load number already in use.");
}
}
}
}
public void DeleteTravel(Guid travelId)
{
var unitOfWork = UnitOfWorkFactory.CreateUnitOfWork();
var travelRepository = RepositoriesFactory.CreateTravelRepository(unitOfWork);
try
{
unitOfWork.BeginTransaction();
travelRepository.DeleteTravel(travelId);
unitOfWork.Commit();
}
catch (Exception ex)
{
unitOfWork.Rollback();
MessageBox.Show(ex.Message, "TravelBuddy");
}
}
public void test()
{
var dataSession = new DataSession();
var uowFactory = new UnitOfWorkFactory(dataSession);
var uow = uowFactory.CreateUnitOfWork();
BridgeRepository <CampaignReport> campaignReportBridgeRepository = new BridgeRepository <CampaignReport>(dataSession);
campaignReportBridgeRepository.Save(new CampaignReport()
{
BursifyUserId = 3,
CampaignId = 1,
Reason = "reason"
});
uow.Commit();
//foreach (var cs in c)
//{
// MessageBox.Show(cs.ID + "");
//}
}
public FieldEntity GetOrCreateFieldEntity(FarmEntity farmDoc)
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (this.IsNew)
{
var field = uow.FieldRepository.EnsureFieldCreated(farmDoc, tbNewField.Text, InputSource.GIN);
uow.SaveChanges();
return(field);
}
else if (ExistingSelected)
{
return(uow.FieldRepository.GetById(SelectedFieldId));
}
else
{
return(null);
}
}
}
private void mapBrowser_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
{
if (documentCompleted == false)
{
documentCompleted = true;
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
//get location of selected field
var field = uow.FieldRepository.GetById(fieldSelector.SelectedFieldId);
lblCheckInfo.Text = "Click a point on the map to set the pickup location";
List <object> parms = new List <object>();
if (field != null && field.Latitude != 0 && field.Longitude != 0)
{
parms.Add(field.Latitude);
parms.Add(field.Longitude);
selectedLat = field.Latitude;
selectedLng = field.Longitude;
}
else if (ConfigHelper.GinYardNWCornerLat != 0 && ConfigHelper.GinYardNWCornerLong != 0)
{
selectedLat = ConfigHelper.GinYardNWCornerLat;
selectedLng = ConfigHelper.GinYardNWCornerLong;
}
else
{
selectedLat = 33.5778631;
selectedLng = -101.8551665;
}
parms.Add(selectedLat);
parms.Add(selectedLng);
mapBrowser.Document.InvokeScript("setPinLocation", parms.ToArray());
if (ReadOnly)
{
mapBrowser.Document.InvokeScript("setReadOnly");
//lblCheckInfo.Text = "This list is currently locked because it has already been downloaded.";
}
mapBrowser.Document.InvokeScript("initMap");
}
}
}
private void tbLicensePlate_Validating(object sender, CancelEventArgs e)
{
string id = (truckObj != null) ? truckObj.Id : "";
if (String.IsNullOrWhiteSpace(tbLicensePlate.Text))
{
hasError = true;
formErrorProvider.SetError(tbLicensePlate, "License plate is required.");
}
else
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (!uow.TruckRepository.CanSaveLicensePlate(id, tbLoadPrefix.Text.Trim()))
{
hasError = true;
formErrorProvider.SetError(tbLicensePlate, "License plate is in use by another truck.");
}
}
}
}
public async Task LoadForm()
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
this.Enabled = true;
//initialize client drop down
if (farmObj != null)
{
farmObj = uow.FarmRepository.GetById(farmObj.Id);
}
clientSelector1.Initialize(formErrorProvider, true, false, (farmObj != null) ? farmObj.ClientId : string.Empty);
if (farmObj != null)
{
tbFarm.Text = farmObj.Name;
}
}
clearErrors();
}
public void LoginUseCaseNotEqualTest()
{
Exception exception = null;
try
{
IUnitOfWorkFactory unitOfWorkFactory = new UnitOfWorkFactory();
IUnitOfWork unitOfWork = unitOfWorkFactory.CreateUnitOfWork();
unitOfWork.GetUsersFromDatabase();
IActivityFactory activityFactory = new ActivityFactory(unitOfWork, new ValidationRuleFactory());
IUseCaseFactory useCaseFactory = new UseCaseFactory(activityFactory);
GetUserRequest getUserRequest = new GetUserRequest("re", "f");
GetUserResponse getUserResponse = useCaseFactory.CreateLoginUseCase().Execute(getUserRequest);
}
catch (Exception ex)
{
exception = ex;
}
Assert.AreEqual(exception.Message, "The user is not found! Please, check out login or password");
}
private void tbRFIDTag_Validating(object sender, CancelEventArgs e)
{
string id = (truckObj != null) ? truckObj.Id : "";
if (String.IsNullOrWhiteSpace(tbRFIDTag.Text) && !cbxIsSemi.Checked)
{
hasError = true;
formErrorProvider.SetError(tbRFIDTag, "RFID tag is required for gin trucks.");
}
else if (!String.IsNullOrWhiteSpace(tbRFIDTag.Text))
{
using (var uow = UnitOfWorkFactory.CreateUnitOfWork())
{
if (!uow.TruckRepository.CanSaveRFIDTag(id, tbRFIDTag.Text.Trim()))
{
hasError = true;
formErrorProvider.SetError(tbRFIDTag, "RFID tag is in use by another truck.");
}
}
}
}
public virtual async Task <RequestResult> Get(int id)
{
RequestResult result = new RequestResult(StatusResult.Success);
using (IUnitOfWork unitOfWork = UnitOfWorkFactory.CreateUnitOfWork())
{
T obj = await unitOfWork.Repository
.First <T>(x => !x.Deleted &&
x.Id == id);
result.Data = await BeforeReturnGet(unitOfWork.GetTransaction(), obj);
if (result.Data == null)
{
result.Status = StatusResult.Warning;
result.Messages.Add(new Message(_localizer["EntityNotFound"]));
}
}
return(result);
}
