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));
}
