private void ucGetLoads_Load(object sender, EventArgs e) { try { using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { var result = loadRepo.GetList("Beam"); if (result.Result == null) { return; } dgvLoads.DataSource = result.Result; dgvLoads.Columns["Calculations"].Visible = false; dgvLoads.Columns["ID"].Visible = false; dgvLoads.Columns["Name"].HeaderText = "Yük Adı"; dgvLoads.Columns["CreatedAt"].HeaderText = "Oluşturulma Tarihi"; dgvLoads.Columns["UpdatedAt"].HeaderText = "Düzenlenme Tarihi"; dgvLoads.Columns["IsDeleted"].HeaderText = "Silinme"; dgvLoads.Columns["IsActive"].HeaderText = "Aktiflik"; } } catch (Exception) { throw; } }
private void btnUpdate_Click(object sender, EventArgs e) { if (cmbBeams.SelectedIndex == -1) { MessageBox.Show("Kiriş tipi seçiniz."); } if (txtName.Text == String.Empty) { MessageBox.Show("Yük tipi adı giriniz."); } try { using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { Load oldLoad = loadRepo.Get(x => x.ID == _Load.ID).Result; oldLoad.BeamId = ((Beam)cmbBeams.SelectedItem).ID; oldLoad.Name = txtName.Text; oldLoad.IsActive = chkIsActive.Checked; oldLoad.IsDeleted = chkIsDeleted.Checked; oldLoad.UpdatedAt = DateTime.UtcNow; var result = loadRepo.Update(oldLoad); switch (result.State) { case Basecore.Model.Enums.BusinessResultType.NotSet: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Success: lblMessage.Text = "Güncelleme başarılı. Son güncellenen yük tipinin adı : " + result.Result.Name; txtName.Text = String.Empty; cmbBeams.SelectedIndex = 0; chkIsActive.Checked = true; chkIsDeleted.Checked = false; break; case Basecore.Model.Enums.BusinessResultType.Error: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Warning: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Info: lblMessage.Text = result.Message; break; default: break; } ucEditLoads_Load(sender, e); } } catch (Exception ex) { lblMessage.Text = "Hata : " + ex.GetBaseException(); } }
private void btnInsert_Click(object sender, EventArgs e) { if (cmbBeam.SelectedIndex == -1) { MessageBox.Show("Kiriş tipi seçiniz."); return; } if (txtName.Text == String.Empty) { MessageBox.Show("Yük tipi adını boş geçemezsiniz."); return; } try { using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { Load load = new Load { BeamId = ((Beam)cmbBeam.SelectedItem).ID, Name = txtName.Text }; var result = loadRepo.Insert(load); switch (result.State) { case Basecore.Model.Enums.BusinessResultType.NotSet: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Success: lblMessage.Text = "Kayıt başarılı. Son kaydedilen yük tipinin adı : " + result.Result.Name; txtName.Text = String.Empty; txtName.Focus(); break; case Basecore.Model.Enums.BusinessResultType.Error: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Warning: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Info: lblMessage.Text = result.Message; break; default: break; } } } catch (Exception ex) { lblMessage.Text = "Hata : " + ex.GetBaseException(); } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); AntiForgeryConfig.UniqueClaimTypeIdentifier = ClaimTypes.Name; _ordersDependency = new OrderRepository(); _ordersDependency.StartDependency(); _loadsDependency = new LoadRepository(); _loadsDependency.StartDependency(); }
private void btnDelete_Click(object sender, EventArgs e) { if (_Load == null) { lblMessage.Text = "Silinecek yük tipini seçiniz."; return; } try { using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { Load oldLoad = loadRepo.Get(x => x.ID == _Load.ID).Result; var result = loadRepo.Delete(oldLoad); switch (result.State) { case Basecore.Model.Enums.BusinessResultType.NotSet: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Success: lblMessage.Text = "Silme işlemi başarılı. Son silinen yük tipi adı : " + oldLoad.Name; break; case Basecore.Model.Enums.BusinessResultType.Error: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Warning: lblMessage.Text = result.Message; break; case Basecore.Model.Enums.BusinessResultType.Info: lblMessage.Text = result.Message; break; default: break; } ucEditLoads_Load(sender, e); } } catch (Exception ex) { lblMessage.Text = "Hata : " + ex.GetBaseException(); } }
private void cmbBeams_SelectedIndexChanged(object sender, EventArgs e) { if (cmbBeams.SelectedIndex == -1) { return; } pnlMain.Controls.Clear(); pnlButtom.Controls.Clear(); using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { var loads = loadRepo.FindList(x => x.BeamId == ((Beam)cmbBeams.SelectedItem).ID); if (loads == null) { return; } cmbLoads.DataSource = loads.Result; cmbLoads.DisplayMember = "Name"; } }
private void ucEditLoads_Load(object sender, EventArgs e) { chkIsActive.Text = "Evet"; chkIsActive.Checked = true; chkIsDeleted.Text = "Hayır"; chkIsDeleted.Checked = false; try { using (ILoadRepository loadRepo = new LoadRepository(new Datacore.Data.BeamDeflectionDbContext())) { var result = loadRepo.GetList("Beam"); if (result.Result == null) { return; } dgvLoads.DataSource = result.Result; dgvLoads.Columns["BeamId"].Visible = false; dgvLoads.Columns["Calculations"].Visible = false; dgvLoads.Columns["ID"].Visible = false; dgvLoads.Columns["Name"].HeaderText = "Yük Adı"; dgvLoads.Columns["CreatedAt"].HeaderText = "Oluşturulma Tarihi"; dgvLoads.Columns["UpdatedAt"].HeaderText = "Düzenlenme Tarihi"; dgvLoads.Columns["IsDeleted"].HeaderText = "Silinme"; dgvLoads.Columns["IsActive"].HeaderText = "Aktiflik"; } using (IBeamRepository beamRepo = new BeamRepository(new Datacore.Data.BeamDeflectionDbContext())) { var result = beamRepo.GetList("Loads"); if (result == null) { lblMessage.Text = "Kayıtlı kiriş tipi bulunamadı. Önce kiriş tipi ekleyin"; return; } cmbBeams.DataSource = result.Result; } } catch (Exception ex) { lblMessage.Text = "Hata : " + ex.GetBaseException(); } }
public WordsRepository(LoadRepository loader) { _repository = loader(); _numberOfAnagramsToAnagramsList = new Dictionary <int, List <string> >(); _disassembledWordToAnagramsList = new Dictionary <string, List <string> >(); foreach (string word in _repository) { string disassembledWord = DisassembleWord(word); if (!_disassembledWordToAnagramsList.ContainsKey(disassembledWord)) { _disassembledWordToAnagramsList[disassembledWord] = new List <string>(); } _disassembledWordToAnagramsList[disassembledWord].Add(word); } foreach (string word in _repository) { string disassembledWord = DisassembleWord(word); int numberOfAnagrams = _disassembledWordToAnagramsList[disassembledWord].Count - 1; if (numberOfAnagrams > 0) { if (!_numberOfAnagramsToAnagramsList.ContainsKey(numberOfAnagrams)) { _numberOfAnagramsToAnagramsList[numberOfAnagrams] = new List <string>(); } _numberOfAnagramsToAnagramsList[numberOfAnagrams].Add(word); } } }
private void ucEditCalculations_Load(object sender, EventArgs e) { chkIsActive.Text = "Evet"; chkIsActive.Checked = true; chkIsDeleted.Text = "Hayır"; chkIsDeleted.Checked = false; try { using (ICalculationRepository calRepo = new CalculationRepository(new BeamDeflectionDbContext())) { var result = calRepo.GetList("Load", "Unit", "AppUser"); if (result.Result == null) { return; } dgvCalculations.DataSource = result.Result; dgvCalculations.Columns["ID"].Visible = false; dgvCalculations.Columns["LoadId"].Visible = false; dgvCalculations.Columns["UserId"].Visible = false; dgvCalculations.Columns["UnitId"].Visible = false; dgvCalculations.Columns["Variables"].Visible = false; dgvCalculations.Columns["Result"].HeaderText = "Sonuç"; dgvCalculations.Columns["Load"].HeaderText = "Yük Tipi"; dgvCalculations.Columns["Unit"].HeaderText = "Birimi"; dgvCalculations.Columns["AppUser"].HeaderText = "Hesaplamayı Yapan Kullanıcı"; dgvCalculations.Columns["CreatedAt"].HeaderText = "Oluşturulma Tarihi"; dgvCalculations.Columns["UpdatedAt"].HeaderText = "Düzenlenme Tarihi"; dgvCalculations.Columns["IsDeleted"].HeaderText = "Silinme"; dgvCalculations.Columns["IsActive"].HeaderText = "Aktiflik"; } using (IUserRepository userRepo = new UserRepository(new BeamDeflectionDbContext())) { var result = userRepo.GetList(); if (result.Result == null) { lblMessage.Text = "Eklenecek kullanıcı bulunamadı."; return; } cmbUsers.DataSource = result.Result; } using (IUnitRepository unitRepo = new UnitRepository(new BeamDeflectionDbContext())) { var result = unitRepo.GetList(); if (result.Result == null) { lblMessage.Text = "Eklenecek birim bulunamadı."; return; } cmbUnits.DataSource = result.Result; } using (ILoadRepository loadRepo = new LoadRepository(new BeamDeflectionDbContext())) { var result = loadRepo.GetList(); if (result.Result == null) { lblMessage.Text = "Eklenecek yük tipi bulunamadı."; return; } cmbLoads.DataSource = result.Result; } } catch (Exception ex) { lblMessage.Text = "Hata : " + ex.GetBaseException(); } }
public static void Starter() { using (BeamDeflectionDbContext ctx = new BeamDeflectionDbContext()) { if (ctx.Users.SingleOrDefault(x => x.Username == "admin") != null) { return; } } using (IUnitRepository unitRepo = new UnitRepository(new BeamDeflectionDbContext())) { try { List <Unit> units = new List <Unit> { new Unit { Name = "meters", Display = "m" }, new Unit { Name = "centimeters", Display = "cm" }, new Unit { Name = "milimeters", Display = "mm" }, new Unit { Name = "kilonewtons", Display = "kN" }, new Unit { Name = "newtons", Display = "N" }, new Unit { Name = "megapascals", Display = "MPa" }, new Unit { Name = "pascals", Display = "Pa" }, new Unit { Name = "meters to fourth power", Display = "m⁴" }, new Unit { Name = "centimeters to fourth power", Display = "cm⁴" }, new Unit { Name = "newtons per meter", Display = "N/m" }, new Unit { Name = "kilonewtons per meter", Display = "kN/m" }, new Unit { Name = "newton meters", Display = "Nm" }, new Unit { Name = "kilogram-centimeters", Display = "kg-cm" } }; unitRepo.InsertList(units); } catch (Exception) { throw; } } using (IBeamRepository beamRepo = new BeamRepository(new BeamDeflectionDbContext())) { try { List <Beam> beams = new List <Beam> { new Beam { Name = "Basitçe desteklenen kiriş" }, new Beam { Name = "Konsol kiriş" } }; beamRepo.InsertList(beams); } catch (Exception) { throw; } } using (IRoleRepository roleRepo = new RoleRepository(new BeamDeflectionDbContext())) { try { List <Role> roles = new List <Role> { new Role { Name = "admin" }, new Role { Name = "appuser" }, new Role { Name = "guest" } }; roleRepo.InsertList(roles); } catch (Exception) { throw; } } using (IUserRepository userRepo = new UserRepository(new BeamDeflectionDbContext())) { try { userRepo.Register("admin", "admin", "admin", "admin", "admin", "admin", true); userRepo.Register("Yeliz", "yeliz", "student", "Yeliz", "ERDOĞAN", "admin", true); userRepo.Register("user", "user", "appuser", "Yeliz", "ERDOĞAN", "appuser", true); } catch (Exception) { throw; } } using (ILoadRepository loadRepo = new LoadRepository(new BeamDeflectionDbContext())) { try { loadRepo.InsertWithBeam(new Load { Name = "Ortadan yük" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Herhangi bir noktadan yük" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Düzgün yük" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Düzgün değişen yük" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Üçgen yük" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Tek destekte moment yükü" }, "Basitçe desteklenen kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Sona yük" }, "Konsol Kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Herhangi bir noktaya yük" }, "Konsol kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Düzgün yayılan yük" }, "Konsol kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Düzgün değişen yük (Durum 1)" }, "Konsol kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Düzgün değişen yük (Durum 2)" }, "Konsol kiriş"); loadRepo.InsertWithBeam(new Load { Name = "Sonunda moment yükü" }, "Konsol kiriş"); } catch (Exception) { throw; } } }
public string OrderGridRead() { #region Deklaracje repozytoriow IOrderRepository orderRepository = new OrderRepository(); ILoadRepository loadRepository = new LoadRepository(); IRouteRepository routeRepository = new RouteRepository(); IStatusOrderRepository statusOrderRepository = new StatusOrderRepository(); ICustomerRepository customerRepository = new CustomerRepository(); #endregion #region Wypelnianie OrderListModelu string orderName = ""; string status = ""; string from = ""; string to = ""; string customerInformation = ""; DateTime date; #endregion List <OrderListModel> ordersListResult = new List <OrderListModel>(); List <Order> orders = orderRepository.getAllOrders(); foreach (var order in orders) { if (order.idLoad.HasValue) { orderName = loadRepository.getLoadNameById(order.idLoad.GetValueOrDefault()); } if (order.idStatus.HasValue) { status = statusOrderRepository.getStatusOrderNameById(order.idStatus.GetValueOrDefault()); } if (order.idRoutes.HasValue) { Tuple <string, string> route = routeRepository.getRouteStartEndById(order.idRoutes.GetValueOrDefault()); from = route.Item1; to = route.Item2; } if (order.idCustomer.HasValue) { customerInformation = customerRepository.getCustomerInformationById(order.idCustomer.GetValueOrDefault()); } date = order.CreatedAt; OrderListModel singleOrder = new OrderListModel { id = order.id, OrderName = orderName, Status = status, From = from, To = to, Customer = customerInformation, Date = date }; ordersListResult.Add(singleOrder); } return(JsonConvert.SerializeObject(ordersListResult)); }
public ActionResult NewOrder(OrderModel model) { if (ModelState.IsValid) { #region Deklaracje repozytoriow ICustomerRepository customerRepository = new CustomerRepository(); IRouteRepository routeRepository = new RouteRepository(); IStatusHistoryRepository statusHistoryRepository = new StatusHistoryRepository(); ILoadRepository loadRepository = new LoadRepository(); IWorkerRepository workerRepository = new WorkerRepository(); ITypesVehicleRepository typeVehicleRepository = new TypesVehicleRepository(); ITypesFreightRepository typeFreightRepository = new TypesFreightRepository(); IOrderRepository orderRepository = new OrderRepository(); #endregion #region ID nowego rodzaju ladunku int typeFreightId = typeFreightRepository.CreateNewTypeFreightByOrder(new TypesFreight { TypeName = model.load.LoadType }); #endregion #region ID nowego towaru int loadCreatedId = loadRepository.CreateLoadByOrder(new Load { Name = model.load.Name, Price = model.load.Price, Weight = model.load.Weight, IdType = typeFreightId }); #endregion #region ID uzytkownika dodajacego zlecenie var cookie = Request.Cookies["LogOn"]; int workerId = workerRepository.getWorkerIdByLogin(cookie.Value); #endregion #region ID statusu zlecenia int statusOrder = 1; #endregion #region ID nowego typu pojazdu int typeVehicleCreatedId = typeVehicleRepository.CreateTypeVehicleByOrder(new TypesVehicle { TypeName = model.vehicle.Name }); #endregion #region ID nowego zleceniodawcy int customerCreatedId = customerRepository.CreateNewCustomerByOrder(new Customer { Name = model.customer.Name, Surname = model.customer.Surname, Address = model.customer.Address, PhoneNumber = model.customer.PhoneNumber, Firm = model.customer.Firm }); #endregion #region ID nowej trasy int routeCreatedId = routeRepository.CreateNewRouteByOrder(new Route { StartPoint = model.route.StartPoint, EndPoint = model.route.EndPoint }); #endregion DateTime createdAt = DateTime.Now; #region Nowe zlecenie Order order = new Order { idLoad = loadCreatedId, idWorker = workerId, idStatus = statusOrder, idTypeVehicles = typeVehicleCreatedId, idCustomer = customerCreatedId, idRoutes = routeCreatedId, CreatedAt = createdAt }; int orderCreatedId = orderRepository.CreateNewOrder(order); statusHistoryRepository.AddStatusHistory(new StatusHistory { idStatus = 1, idWorker = workerId, ChangeDate = DateTime.Now, idOrder = orderCreatedId }); #endregion return(RedirectToAction("OrderList", "Order")); } return(NewOrderRetry(model)); }