public bool DeleteOId(string OId)//#223韦
{
using (var ctx = new OracleDbContext())
{
try
{
FreightOrder F = new FreightOrder()
{
OrderID = OId
};
ctx.FreightOrder.Attach(F);
ctx.FreightOrder.Remove(F);
ctx.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
return(false);
}
}
}
public void Upload(FreightOrder fo)
{
var existFo = this.Query(fo.Id);
fo.NewAmount = existFo.Amount + fo.Amount;
//Implement other logic here
this.Update(fo);
}
private void button1_Click(object sender, EventArgs e)
{
List <FreightOrder> freightOrders = new List <FreightOrder>();
DateTime today = new DateTime();
String dateString = Convert.ToString(today.Date);
FreightOrder freightOrder;
int random_id;
int random_postalcode;
Random random = new Random();
int amount = 1;
for (int i = 0; i < amount; i++)
{
random_id = random.Next(1, 100000000);
random_postalcode = random.Next(10000, 99999);
// FreightOrder(string id, string companyName, string description, EnumFreightOrderStatus freightOrderStatus, string date, string postalCode, string country, string city, string streetName, string streetNumber, string signatureTagPacker, string feedbackPacker, List<string> photoTagsPacker, string signatureTagDriver, string feedbackDriver, List<string> photoTagsDriver)
freightOrder = new FreightOrder(Convert.ToString(random_id), "Mustermann Company", "Construction Elements", EnumFreightOrderStatus.BEFORE_PACKING, dateString,
Convert.ToString(random_postalcode), "Germany", "Berlin", "Mustermannstreet", "99", "sign_Packer_MaxMustermann" + Convert.ToString(random_id), "FeedbackPacker Text", "PhotoTagsPacker Tag1, Tag2, Tagn", "sign_Driver_MaxMustermann" + Convert.ToString(random_id), "FeedbackDriver Text", "PhotoTagsDriver Tag1, Tag2, Tagn");
freightOrders.Add(freightOrder);
}
Console.WriteLine(freightOrders);
ListViewItem listViewItem_FreightOrder = new ListViewItem();
for (int i = 0; i < freightOrders.Count; i++)
{
listView_FreightOrders.Items.Add(freightOrders.ElementAt(i).getCompanyName() + " ID: " + freightOrders.ElementAt(i).getId());
// -----------------------------------------------------------------------------------------S Q L ----------------------------------------------------------------------------------------------------------------------
// Insert SQL Statements for transfering freightOrders to database
// Example accessing ID of FreightOrder
String test_id = freightOrders.ElementAt(i).getId();
con = new SqlConnection(@"data source=bsspublic.database.windows.net; Initial catalog=HTW; user id=HTW; Password=u3Q9##X6&I;");
cmd = new SqlCommand("INSERT INTO SmartLoadAppData(id,companyName, description,freightOrderStatus,date,postalCode,country,city,streetName,streetNumber,signatureTagPacker,feedbackPacker,photoTagsPacker,signatureTagDriver,feedbackDriver,photoTagsDriver) VALUES (150,'" + this.CompanyName + "','description','BEFORE_PACKING','17.06.2019','10318','Germany','Berlin',1,1,1,1,1,1,1,1)", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
// -----------------------------------------------------------------------------------------S Q L ----------------------------------------------------------------------------------------------------------------------
}
}
public bool ChangeOrder(FreightOrder F)
{
using (var ctx = new OracleDbContext())
{
try
{
var FO = ctx.FreightOrder.Where(x => x.OrderID == F.OrderID).FirstOrDefault();
FO.SenderName = F.SenderName;
FO.SenderPhoneNumber = F.SenderPhoneNumber;
FO.SenderID = F.SenderID;
FO.ReceiverName = F.ReceiverName;
FO.ReceiverPhoneNumber = F.ReceiverPhoneNumber;
FO.StartStation = F.StartStation;
FO.CarriageNumber = F.CarriageNumber;
FO.CreateDate = F.CreateDate;
FO.DueDate = F.DueDate;
FO.EndStation = F.EndStation;
FO.OrderBill = F.OrderBill;
FO.State = F.State;
FO.PackgeID = F.PackgeID;
FO.TrainID = F.TrainID;
FO.OrderCapacity = F.OrderCapacity;
ctx.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Diagnostics.Debug.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
return(false);
}
}
}
public IActionResult Index(string fileType, FreightOrder fo)
{
ModelState.Clear();
IFoStrategy stg = null;
if (fileType.Equals("1"))
{
stg = new FoStrategyAppend();
ViewBag.Strategy = "採用策略：累加原單之數量";
}
else
{
stg = new FoStrategyReplace();
ViewBag.Strategy = "採用策略：覆蓋原單之數量";
}
stg.Query = DataAccessService.Query;
stg.Update = DataAccessService.Update;
updateFreightOrder(fo, stg);
return(View(fo));
}
private void updateFreightOrder(FreightOrder fo, IFoStrategy stg)
{
stg.Upload(fo);
}
public IActionResult Index()
{
FreightOrder fo = DataAccessService.Query(1);
return(View(fo));
}
public static void Update(FreightOrder fo)
{
Trace.WriteLine("==>更新資料庫...");
}
