private void SaveBut_Click(object sender, EventArgs e)
{
using (ScalaFtsDb_Parser_TestEntities db = new ScalaFtsDb_Parser_TestEntities())
{
var product = db.Products.First(x => x.Id == currentProduct.Id);
if (nameFileCheckBox.Checked)
{
product.Title = nameFileTextBox.Text;
}
else if (nameInputCheckBox.Checked)
{
product.Title = nameInputTextBox.Text;
}
else if (nameSiteCheckBox.Checked)
{
product.Title = nameSiteTextBox.Text;
}
else if (nameSiteEngCheckBox.Checked)
{
product.Title = nameSiteEngTextBox.Text;
}
else if (nameFileEngCheckBox.Checked)
{
product.Title = nameFileEngTextBox.Text;
}
db.SaveChanges();
if (localProduct != null)
{
localProduct.ProductName = nameSiteTextBox.Text;
localProduct.ProductEngName = nameSiteEngTextBox.Text;
localProduct.ProductModel = modelTextBox.Text;
localProduct.ProductBrand = brandTextBox.Text;
localProduct.ProductType = typeTextBox.Text;
localProduct.ProductClassification = classificationTextBox.Text;
localProduct.ProductDepartmentName = departmentNameTextBox.Text;
}
if (localStatuses != null)
{
localStatuses.ForbiddenStatus = forbiddenWordTextBox.Text;
}
ctx.SaveChanges();
}
}
private void LoginBut_Click(object sender, EventArgs e)
{
ScalaFtsDb_Parser_TestEntities db = new ScalaFtsDb_Parser_TestEntities();
var user = db.AspNetUsers.ToList().FirstOrDefault(x => x.UserName == loginTextBox.Text && VerifyHashedPassword(x.PasswordHash, passwordTextBox.Text));
if (user != null)
{
Global.currentUser = user;
Hide();
if (user.AspNetRoles.First().Name == "Administrators")
{
new AdminSms().Show();
}
else
{
new MainForm().Show();
}
}
else
{
MessageBox.Show("Неверный логин или пароль!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SaveBut_Click(object sender, EventArgs e)
{
//List<People> peoples = new List<People>();
//List<Shipments> shipments = new List<Shipments>();
//List<Products> products = new List<Products>();
//try
//{
GenerateComparisonList();
if (saveToResourcesCheckBox.Checked)
{
SaveSettings(settingsPath);
}
string prevCode = "";
Shipments prevShip = null;
Guid prevPeopleId = Guid.Empty;
Guid prevShipmentId = Guid.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
string ShipmentCode = GetColumn(i, "CodeShipments");
Guid PeopleId = Guid.NewGuid();
Guid ShipmentId = Guid.NewGuid();
Guid ProductId = Guid.NewGuid();
int currencyId = (int)((ComboBox)radScrollablePanel1.Controls[0].Controls["CurrencyCB"]).SelectedValue;
var currencyPrice = (((ComboBox)radScrollablePanel1
.Controls[0]
.Controls["CurrencyCB"])
.SelectedItem as CurrencyEntity).Price;
decimal cost = GetColumn(i, "Cost").ToDecimalOrZero();
double grossWeight = GetColumn(i, "GrossWeight").ToDoubleOrZero();
double netWeight = GetColumn(i, "NetWeight").ToDoubleOrZero();
if (prevCode != ShipmentCode || prevCode == "")
{
var fioItems = GetColumn(i, "FIO").Split(' ');
People ppl = new People()
{
Id = PeopleId,
Phone = GetColumn(i, "Phone"),
IdentityCardName = 21, //GetColumn(i, "IdentityCardName").ToIntOrZero(),
IdentityCardNumber = GetColumn(i, "IdentityCardNumber"),
IdentityCardSeries = GetColumn(i, "IdentityCardSeries"),
IssuedBy = GetColumn(i, "IssuedBy"),
INN = GetColumn(i, "INN"),
Email = GetColumn(i, "Email"),
Index = GetColumn(i, "Index"),
Region = GetColumn(i, "Region"),
City = GetColumn(i, "City"),
Street = GetColumn(i, "Street"),
House = GetColumn(i, "House"),
Country = 643,//GetColumn(i, "Country").ToIntOrZero(),
IssuedOn = GetColumn(i, "IssuedOn").ToNullableDate(),
Birthdate = GetColumn(i, "Birthdate").ToNullableDate(),
Name = fioItems.ElementAtOrDefault(0).NullableToEmptyString(),
Surname = fioItems.ElementAtOrDefault(1).NullableToEmptyString(),
Middlename = fioItems.ElementAtOrDefault(2).NullableToEmptyString(),
UserId = Global.currentUser.Id
};
Shipments ship = new Shipments()
{
Id = ShipmentId,
ExternalId = GetColumn(i, "ExternalId"),
Code = ShipmentCode,
Height = GetColumn(i, "Height").ToDoubleOrZero(),
Length = GetColumn(i, "Length").ToDoubleOrZero(),
Width = GetColumn(i, "Width").ToIntOrZero(),
TotalGrossWeight = (decimal)grossWeight,
TotalNetWeight = (decimal)netWeight,
Currency = currencyId,
TotalCost = cost,
TotalCustomsValue = cost * currencyPrice,
PackageAmount = GetColumn(i, "PackageAmount").ToIntOrOne(),
InvoiceNumber = GetColumn(i, "InvoiceNumber"),
InvoiceDate = GetColumn(i, "InvoiceDate").ToDateOrNow(),
DispatchDate = GetColumn(i, "DispatchDate").ToDateOrNow(),
CreationDate = GetColumn(i, "CreationDate").ToDateOrNow(),
ParcelType = GetColumn(i, "ParcelType").ToIntOrZero(),
DeliveryCategoryId = new Guid("610a507c-6222-0529-2edf-6fa19fb1fdc8"), //GetColumn(i, "DeliveryCategoryId").ToGuidOrZero(),
DispatchPlaceId = 25, //GetColumn(i, "DispatchPlaceId").ToLongOrZero(),
RegistryId = GetColumn(i, "RegistryId").ToNullableGuid(),
Description = GetColumn(i, "Description"),
ShipperType = GetColumn(i, "ShipperType").ToIntOrZero(),
ShipperCompanyId = GetColumn(i, "ShipperCompanyId").ToNullableGuid(),
ReceiverType = GetColumn(i, "ReceiverType").ToIntOrZero(),
ReceiverCompanyId = GetColumn(i, "ReceiverCompanyId").ToNullableGuid(),
ReceiverPersonId = PeopleId,
StatusId = new Guid("3ebc28f0-08a8-942c-236a-f921a45ffb18"),//GetColumn(i, "StatusId").ToGuidOrZero(),
Update = false,
UserId = Global.currentUser.Id
};
db.People.Add(ppl);
db.Shipments.Add(ship);
prevPeopleId = PeopleId;
prevShipmentId = ShipmentId;
prevShip = ship;
}
Products p = new Products()
{
Title = GetColumn(i, "Title"),
Code = GetColumn(i, "CodeProducts"),
Quantity = GetColumn(i, "Quantity").ToIntOrOne(),
Cost = cost,
GrossWeight = grossWeight,
NetWeight = netWeight,
DescriptionLink = GetColumn(i, "DescriptionLink"),
CustomsValue = cost * currencyPrice,
CostEUR = cost * currencyPrice
/ Global.Currencies[1].Price,
Id = ProductId,
ShipmentId = prevShipmentId,
//AddImage = true,
//DocumentScanId = null
};
db.Products.Add(p);
if (prevCode == ShipmentCode)
{
prevShip.TotalCost += p.Cost;
prevShip.TotalGrossWeight += Convert.ToDecimal(p.GrossWeight);
prevShip.TotalNetWeight += Convert.ToDecimal(p.NetWeight);
prevShip.TotalCustomsValue += p.CustomsValue;
}
prevCode = ShipmentCode;
if (i % 500 == 0 && i != 0)
{
db.SaveChanges();
db = new ScalaFtsDb_Parser_TestEntities();
}
}
//db.Shipments.AddRange(shipments);
//db.People.AddRange(peoples);
//db.Products.AddRange(products);
db.SaveChanges();
MessageBox.Show("Данные успешно занесены в базу!", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
