public Park_Database.Model.Park_Time GetParkByID(string id)
{
Park_Database.Model.Park_Time result = new Park_Database.Model.Park_Time();
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = string.Format(@"
Select * from Park_Time
Where Time_Carname='{0}'", id);
var reader = command.ExecuteReader();
while (reader.Read())
{
Park_Database.Model.Park_Time item = new Park_Database.Model.Park_Time();
item.Time_Carname = reader["Time_Carname"].ToString();
item.Time_Seat = reader["Time_Seat"].ToString();
item.Time_Start = reader["Time_Start"].ToString();
item.Time_End = reader["Time_End"].ToString();
item.Time_Createtime = DateTime.Parse(reader["Time_Createtime"].ToString());
result = item;
}
connection.Close();
return result;
}
public List<Park_Database.Model.Park_Time> LoadAll()
{
List<Park_Database.Model.Park_Time> result = new List<Park_Database.Model.Park_Time>();
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = "Select * from Park_Time";
var reader = command.ExecuteReader();
while (reader.Read())
{
Park_Database.Model.Park_Time item = new Park_Database.Model.Park_Time();
item.Time_Carname = reader["Time_Carname"].ToString();
item.Time_Seat = reader["Time_Seat"].ToString();
item.Time_Start = reader["Time_Start"].ToString();
item.Time_End = reader["Time_End"].ToString();
item.Time_Createtime = DateTime.Parse(reader["Time_Createtime"].ToString());
result.Add(item);
}
connection.Close();
return result;
}
public ActionResult Create(Park_Database.Model.Park_User Pget, string s, string d, string t)
{
Park_Database.Service.Park_User_Service dbu = new Park_Database.Service.Park_User_Service();
Park_Database.Service.Park_Time_Service dbt = new Park_Database.Service.Park_Time_Service();
Park_Database.Model.Park_User PU = new Park_Database.Model.Park_User();
Park_Database.Model.Park_Time PT = new Park_Database.Model.Park_Time();
Park_Web.Models.Park_Ok PK = new Park_Web.Models.Park_Ok();
DateTime da;
da = DateTime.Parse(d);
if (t == "1") //月租
{
da = da.AddMonths(1);
}
else if (t == "2") //年租
{
da = da.AddYears(1);
}
Pget.User_Createtime = DateTime.Now;
dbu.Create(Pget);
PT.Time_Carname = Pget.User_Carname;
PT.Time_Seat = s;
PT.Time_Start = d;
PT.Time_End = da.ToString("yyyy-MM-dd HH:mm");
PT.Time_Createtime = DateTime.Now;
dbt.Create(PT);
if (t == "0")
{
PK.Ok_Type = "日租型";
}
else if (t == "1")
{
PK.Ok_Type = "月租型";
}
else if (t == "2")
{
PK.Ok_Type = "年租型";
}
PK.Ok_Seat = s;
PK.Ok_Carname = Pget.User_Carname;
PK.Ok_Name = Pget.User_Name;
PK.Ok_Password = Pget.User_Password;
PK.Ok_Start = d;
PK.Ok_End = da.ToString("yyyy-MM-dd HH:mm");
return(RedirectToAction("ok", "Park", PK));
}
public void Update(Park_Database.Model.Park_Time updatePark)
{
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = string.Format(@"
UPDATE Park_Time
SET Time_Seat=N'{1}',Time_Start=N'{2}',Time_End=N'{3}'
Where Time_Carname=N'{0}'
", updatePark.Time_Carname, updatePark.Time_Seat, updatePark.Time_Start, updatePark.Time_End);
command.ExecuteNonQuery();
connection.Close();
}
public void Create(Park_Database.Model.Park_Time CP)
{
var connection = new System.Data.SqlClient.SqlConnection(_connection);
connection.Open();
var command = new System.Data.SqlClient.SqlCommand("", connection);
command.CommandText = string.Format(@"
INSERT INTO Park_Time(Time_Carname,Time_Seat, Time_Start, Time_End,Time_Createtime)
VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}')
", CP.Time_Carname, CP.Time_Seat, CP.Time_Start, CP.Time_End, CP.Time_Createtime.ToString("yyyy-MM-dd HH:mm"));
command.ExecuteNonQuery();
connection.Close();
}
public static void Create_Time(Park_Database.Service.Park_Time_Service db)
{
Park_Database.Model.Park_Time PT = new Park_Database.Model.Park_Time();
var carname = "MAX-7222";
var seats = "A02";
var start = "2017-01-01";
var end = "2017-01-01";
var Createtime = DateTime.Now;
PT.Time_Carname = carname;
PT.Time_Seat = seats;
PT.Time_Start = start;
PT.Time_End = end;
PT.Time_Createtime = (Createtime);
db.Create(PT);
Console.WriteLine("區域資料創建完成");
}
public RedirectToRouteResult Update(Park_Database.Model.Park_Time P)
{
//if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0)
//{
// var File = Request.Files[0];
// string dir = string.Format("~/Content/Image/");
// var TrueDir = System.Web.Hosting.HostingEnvironment.MapPath(dir);
// if (!System.IO.Directory.Exists(TrueDir))
// {
// System.IO.Directory.CreateDirectory(TrueDir);
// }
// var SaveDir = System.IO.Path.Combine(TrueDir, File.FileName);
// File.SaveAs(SaveDir);
// P.area = this.Url.Content(System.IO.Path.Combine(dir, File.FileName));
// //System.Drawing.Image image = System.Drawing.Image.FromStream(File.InputStream);
//}
Park_Database.Service.Park_Time_Service dt = new Park_Database.Service.Park_Time_Service();
dt.Update(P);
return(RedirectToAction("Phome"));
}
