public ActionResult CreateContacts(EmailAddress e)
{
if (ModelState.IsValid)
{
db.MyEntitiesEmailAddress.Add(e);
db.SaveChanges();
return(RedirectToAction("SentConfirmation"));
}
return(View());
}
private void Salesman()
{
try
{
ContactsModel contact = new ContactsModel();
contact.Database.ExecuteSqlCommand("truncate table [SalesTable]");
contact.Database.ExecuteSqlCommand("truncate table [ProductTable]");
contact.SaveChanges();
contact.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", Pen = 33, Pencil = 32, Eraser = 56, Ruler = 45, Whiteout = 33, Quantity = (33 * 12 + 32 * 16 + 56 * 10 + 45 * 14 + 33 * 15)
});
contact.SalesTable.Add(new SalesTable()
{
Salesman = "John", Pen = 77, Pencil = 33, Eraser = 68, Ruler = 45, Whiteout = 23, Quantity = (77 * 12 + 33 * 16 + 68 * 10 + 45 * 14 + 23 * 15)
});
contact.SalesTable.Add(new SalesTable()
{
Salesman = "David", Pen = 43, Pencil = 55, Eraser = 43, Ruler = 67, Whiteout = 65, Quantity = (43 * 12 + 55 * 16 + 43 * 10 + 67 * 14 + 65 * 15)
});
contact.ProductTable.Add(new ProductTable()
{
Products = "原子筆", Sum = 153, Quantity = 153 * 12
});
contact.ProductTable.Add(new ProductTable()
{
Products = "鉛筆", Sum = 128, Quantity = 128 * 16
});
contact.ProductTable.Add(new ProductTable()
{
Products = "橡皮擦", Sum = 167, Quantity = 167 * 10
});
contact.ProductTable.Add(new ProductTable()
{
Products = "直尺", Sum = 157, Quantity = 157 * 14
});
contact.ProductTable.Add(new ProductTable()
{
Products = "立可白", Sum = 121, Quantity = 121 * 15
});
contact.SaveChanges();
list1 = contact.SalesTable.ToList();
list2 = contact.ProductTable.ToList();
}
catch (Exception ex)
{
MessageBox.Show($"發生錯誤 {ex.ToString()}");
}
}
static void Main(string[] args)
{
ContactsModel contacts = new ContactsModel();
string Filename = @"C:\Users\TSAI\Desktop\test03.txt";
string[] Fileline = new string[] { };
if (File.Exists(Filename))
{
Fileline = File.ReadAllLines(Filename);
}
else
{
Console.WriteLine("File does not exist.");
}
DateTime FileFlyingDay;
DateTime FileBirthday;
foreach (var i in Fileline)
{
if (i.Substring(0, 3) == "695" || i.Substring(0, 3) == "525")
{
DateTime.TryParse(i.Substring(13, 4) + "/" + i.Substring(17, 2) + "/" + i.Substring(19, 2), out FileFlyingDay);
DateTime.TryParse(i.Substring(21, 4) + "/" + i.Substring(25, 2) + "/" + i.Substring(27, 2), out FileBirthday);
var FileTickNumber = i.Substring(0, 13);
contacts.TextTable.Add(new TextTable {
TickNumber = FileTickNumber, FlyingDay = FileFlyingDay, Birthday = FileBirthday
});
}
}
contacts.SaveChanges();
Console.ReadLine();
}
private void button1_Click(object sender, EventArgs e)
{
RefuleTable refule = new RefuleTable()
{
Kilometer = (double)(numericUpDown2.Value),
Liter = (double)(numericUpDown1.Value),
RefuelingDate = dateTimePicker1.Value
};
try
{
ContactsModel contacts = new ContactsModel();
contacts.RefuleTable.Add(refule);
contacts.SaveChanges();
Cleardata();
}
catch (Exception ex)
{ MessageBox.Show($"{ex}"); }
}
private void button1_Click(object sender, EventArgs e)
{
RefuleTable data = new RefuleTable()
{
RefulingDate = dateTimePicker1.Value,
Liter = (float)numericUpDown1.Value,
Kilometer = (float)numericUpDown2.Value
};
try
{
ContactsModel context = new ContactsModel();
context.RefuleTable.Add(data);
context.SaveChanges();
MessageBox.Show("存檔完成");
}
catch (Exception ex)
{ MessageBox.Show($"發生錯誤 {ex.ToString()}"); }
}
private void button1_Click_1(object sender, EventArgs e)
{
ContactsTable data = new ContactsTable()
{
RefuelingDate = dateTimePicker1.Value,
Liter = Convert.ToDouble(numericUpDown1.Value),
Kilometer = Convert.ToDouble(numericUpDown2.Value),
};
try
{
ContactsModel context = new ContactsModel();
context.ContactsTable.Add(data);
context.SaveChanges();
list = context.ContactsTable.ToList();
MessageBox.Show("存檔完成");
}
catch (Exception ex)
{ MessageBox.Show($"發生錯誤 {ex.ToString()}"); }
}
private void button1_Click(object sender, EventArgs e)
{
ContactsTable data = new ContactsTable()// 先產生一筆資料 在記憶體裡 requir 一定要有資料
{
UserName = textBox1.Text.Trim(),
Address = textBox2.Text.Trim(),
Phone = textBox3.Text.Trim()
};
try
{
ContactsModel context = new ContactsModel(); //記憶體之間的橋樑
context.ContactsTable.Add(data);
context.SaveChanges(); // 改變 資料
MessageBox.Show("存檔完成");
ClearTextBoxes();
}
catch (Exception ex)
{ MessageBox.Show($"發生錯誤{ex.ToString()}"); }//練習用 tostring出來 自己要看的
}
private void button1_Click(object sender, EventArgs e)
{
ContactsTable data = new ContactsTable()
{
UserName = textBox1.Text.Trim(),
Address = textBox2.Text.Trim(),
Phone = textBox3.Text.Trim()
};
try
{
ContactsModel context = new ContactsModel();
context.ContactsTable.Add(data);
context.SaveChanges();
MessageBox.Show("存檔完成");
ClearTextBoxes();
}
catch (Exception ex)
{ MessageBox.Show($"發生錯誤 {ex.ToString()}"); }
}
private void button1_Click(object sender, EventArgs e)
{
ContactsTable data = new ContactsTable()
{
RefuilingDate = dateTimePicker1.Value,
Liter = (double)numericUpDown1.Value,
Kilometer = (double)numericUpDown2.Value
};
try
{
ContactsModel model = new ContactsModel();
model.ContactsTable.Add(data);
model.SaveChanges();
MessageBox.Show("存檔完成");
Close();
}
catch (Exception ex)
{
MessageBox.Show("發生錯誤");
}
}
static void Main(string[] args)
{
var lines = File.ReadAllLines("test03.txt");
// string i = string.Empty;
CultureInfo zhtw = new CultureInfo("zh-tw");
foreach (var i in lines)
{
if (i.Substring(0, 3) == "695" || i.Substring(0, 3) == "525")
{
DateTime.TryParseExact(i.Substring(13, 8), "yyyyMMdd", zhtw, DateTimeStyles.None, out DateTime dateValue1);
DateTime.TryParseExact(i.Substring(21, 8), "yyyyMMdd", zhtw, DateTimeStyles.None, out DateTime dateValue2);
Table data = new Table()
{
TickNumber = i.Substring(0, 13),
FlyingDay = dateValue1,
BirthDay = dateValue2
};
try
{
ContactsModel context = new ContactsModel();
context.Table.Add(data);
context.SaveChanges();
Console.WriteLine($"{data.TickNumber} {data.FlyingDay.ToString("yyyy/MM/dd")} {data.BirthDay.ToString("yyyy/MM/dd")}");
}
catch (Exception ex)
{
Console.WriteLine("發生錯誤" + ex);
}
}
}
// var list = new ContactsModel();
// var list2 = list.Table.ToList();
//foreach(var i in list2)
// {
// Console.WriteLine(i.TickNumber + " " + i.FlyingDay + " " + i.BirthDay);
// }
Console.ReadLine();
}
private void InsertData()
{
try
{
ContactsModel context = new ContactsModel();
context.Database.ExecuteSqlCommand("TRUNCATE TABLE [TicketFare]");
context.SaveChanges();
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台北", EndStation = "新竹", TicketPrice = 177
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台北", EndStation = "台中", TicketPrice = 375
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台北", EndStation = "嘉義", TicketPrice = 598
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台北", EndStation = "台南", TicketPrice = 738
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台北", EndStation = "高雄", TicketPrice = 842
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "新竹", EndStation = "台中", TicketPrice = 197
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "新竹", EndStation = "嘉義", TicketPrice = 421
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "新竹", EndStation = "台南", TicketPrice = 560
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "新竹", EndStation = "高雄", TicketPrice = 755
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台中", EndStation = "嘉義", TicketPrice = 224
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台中", EndStation = "台南", TicketPrice = 363
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台中", EndStation = "高雄", TicketPrice = 469
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "嘉義", EndStation = "台南", TicketPrice = 139
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "嘉義", EndStation = "高雄", TicketPrice = 245
});
context.TicketFare.Add(new Models.TicketFare {
StartStation = "台南", EndStation = "高雄", TicketPrice = 106
});
context.SaveChanges();
Data = context.TicketFare.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void TicketFare()
{
try
{
ContactsModel contacts = new ContactsModel();
contacts.Database.ExecuteSqlCommand("truncate table [ContactsTable]");
contacts.SaveChanges();
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台北", EndStation = "新竹", Fare = 177
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台北", EndStation = "台中", Fare = 375
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台北", EndStation = "嘉義", Fare = 598
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台北", EndStation = "台南", Fare = 738
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台北", EndStation = "高雄", Fare = 842
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "新竹", EndStation = "台中", Fare = 197
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "新竹", EndStation = "嘉義", Fare = 421
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "新竹", EndStation = "台南", Fare = 560
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "新竹", EndStation = "高雄", Fare = 755
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台中", EndStation = "嘉義", Fare = 224
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台中", EndStation = "台南", Fare = 363
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台中", EndStation = "高雄", Fare = 469
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "嘉義", EndStation = "台南", Fare = 139
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "嘉義", EndStation = "高雄", Fare = 245
});
contacts.ContactsTable.Add(new ContactsTable()
{
StartStation = "台南", EndStation = "高雄", Fare = 106
});
contacts.SaveChanges();
list = contacts.ContactsTable.ToList();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void InsertMyData()
{
try
{
ContactsModel context = new ContactsModel();
//var P_rows = context.Products.ToList();
//foreach(var row in P_rows)
//{
// context.Products.Remove(row);
//}
//var S_rows = context.Sales.ToList();
//foreach(var row in S_rows)
//{
// context.Sales.Remove(row);
//}
context.Database.ExecuteSqlCommand("TRUNCATE TABLE [Products]");
context.Database.ExecuteSqlCommand("TRUNCATE TABLE [Sales]");
context.SaveChanges();
context.Products.Add(new Products {
Product_Name = "原子筆", Product_Price = 12
});
context.Products.Add(new Products {
Product_Name = "鉛筆", Product_Price = 16
});
context.Products.Add(new Products {
Product_Name = "橡皮擦", Product_Price = 10
});
context.Products.Add(new Products {
Product_Name = "直尺", Product_Price = 14
});
context.Products.Add(new Products {
Product_Name = "立可白", Product_Price = 15
});
context.Sales.Add(new Sales {
Name = "Bill", Product_Name = "原子筆", Product_Quantity = 33
});
context.Sales.Add(new Sales {
Name = "Bill", Product_Name = "鉛筆", Product_Quantity = 32
});
context.Sales.Add(new Sales {
Name = "Bill", Product_Name = "橡皮擦", Product_Quantity = 56
});
context.Sales.Add(new Sales {
Name = "Bill", Product_Name = "直尺", Product_Quantity = 45
});
context.Sales.Add(new Sales {
Name = "Bill", Product_Name = "立可白", Product_Quantity = 33
});
context.Sales.Add(new Sales {
Name = "Jhon", Product_Name = "原子筆", Product_Quantity = 77
});
context.Sales.Add(new Sales {
Name = "Jhon", Product_Name = "鉛筆", Product_Quantity = 33
});
context.Sales.Add(new Sales {
Name = "Jhon", Product_Name = "橡皮擦", Product_Quantity = 68
});
context.Sales.Add(new Sales {
Name = "Jhon", Product_Name = "直尺", Product_Quantity = 45
});
context.Sales.Add(new Sales {
Name = "Jhon", Product_Name = "立可白", Product_Quantity = 23
});
context.Sales.Add(new Sales {
Name = "David", Product_Name = "原子筆", Product_Quantity = 43
});
context.Sales.Add(new Sales {
Name = "David", Product_Name = "鉛筆", Product_Quantity = 55
});
context.Sales.Add(new Sales {
Name = "David", Product_Name = "橡皮擦", Product_Quantity = 43
});
context.Sales.Add(new Sales {
Name = "David", Product_Name = "直尺", Product_Quantity = 67
});
context.Sales.Add(new Sales {
Name = "David", Product_Name = "立可白", Product_Quantity = 65
});
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void InitialData()
{
try
{
ContactsModel data = new ContactsModel();
data.Database.ExecuteSqlCommand("truncate table [SalesTable]");
data.Database.ExecuteSqlCommand("truncate table [ProductTable]");
data.SaveChanges();
data.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", ProductItem = "原子筆", Quantity = 33
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", ProductItem = "鉛筆", Quantity = 32
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", ProductItem = "橡皮擦", Quantity = 56
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", ProductItem = "直尺", Quantity = 45
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "Bill", ProductItem = "立可白", Quantity = 33
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "John", ProductItem = "原子筆", Quantity = 77
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "John", ProductItem = "鉛筆", Quantity = 33
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "John", ProductItem = "橡皮擦", Quantity = 68
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "John", ProductItem = "直尺", Quantity = 45
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "John", ProductItem = "立可白", Quantity = 23
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "David", ProductItem = "原子筆", Quantity = 43
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "David", ProductItem = "鉛筆", Quantity = 55
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "David", ProductItem = "橡皮擦", Quantity = 43
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "David", ProductItem = "直尺", Quantity = 67
});
data.SalesTable.Add(new SalesTable()
{
Salesman = "David", ProductItem = "立可白", Quantity = 65
});
data.ProductTable.Add(new ProductTable()
{
Item = "原子筆", Price = 12
});
data.ProductTable.Add(new ProductTable()
{
Item = "鉛筆", Price = 16
});
data.ProductTable.Add(new ProductTable()
{
Item = "橡皮擦", Price = 10
});
data.ProductTable.Add(new ProductTable()
{
Item = "直尺", Price = 14
});
data.ProductTable.Add(new ProductTable()
{
Item = "立可白", Price = 15
});
data.SaveChanges();
list1 = data.SalesTable.ToList();
list2 = data.ProductTable.ToList();
}
catch (Exception ex)
{
MessageBox.Show($"發生錯誤{ex.ToString()}");
}
}
