// Get 1 schedule theo schedule_id
public schedules get1Schedule(int schedule_id)
{
string sql = "Select * From schedules Where schedule_id=@schedule_id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("schedule_id", schedule_id);
SqlDataReader rd = cmd.ExecuteReader();
schedules schedule = null;
if (rd.Read())
{
schedule = new schedules();
schedule.schedule_id = (int)rd["schedule_id"];
schedule.fullname = (string)rd["fullname"];
schedule.phone = (string)rd["phone"];
schedule.email = (string)rd["email"];
schedule.room_id = (int)rd["room_id"];
schedule.date_in = (DateTime)rd["date_in"];
schedule.date_out = (DateTime)rd["date_out"];
}
con.Close();
return(schedule);
}
// Get ra danh sách đặt phòng đã đi vs schedule_id=0
public List <schedules> getSchedules1()
{
string sql = "Select * From schedules, rooms where schedules.room_id=rooms.room_id and schedules.schedule_status=1 ORDER BY schedule_id DESC";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader rd = cmd.ExecuteReader();
List <schedules> li = new List <schedules>();
while (rd.Read())
{
schedules schedule = new schedules();
schedule.schedule_id = (int)rd["schedule_id"];
schedule.fullname = (string)rd["fullname"];
schedule.phone = (string)rd["phone"];
schedule.email = (string)rd["email"];
schedule.room_id = (int)rd["room_id"];
schedule.room_name = (string)rd["room_name"];
schedule.date_in = (DateTime)rd["date_in"];
schedule.date_out = (DateTime)rd["date_out"];
schedule.schedule_status = (Boolean)rd["schedule_status"];
li.Add(schedule);
}
con.Close();
return(li);
}
protected void btnSuaDatPhong_Click(object sender, EventArgs e)
{
try
{
schedules schedule = new schedules();
schedule.schedule_id = int.Parse(schedule_id.Text);
schedule.fullname = fullname.Text;
schedule.phone = phone.Text;
schedule.email = email.Text;
schedule.date_in = DateTime.Parse(date_in.Text);
schedule.date_out = DateTime.Parse(date_out.Text);
schedule.room_id = int.Parse(room_id.Text);
data.updateSchedule(schedule);
// Cập nhật room_status phòng vừa đặt là 1 (Đã dùng)
data.updateRoomUsed(schedule.room_id);
err_msg.ForeColor = System.Drawing.Color.Green;
err_msg.Text = "Cập nhật đặt phòng thành công!";
}
catch (Exception ex)
{
err_msg.ForeColor = System.Drawing.Color.Red;
err_msg.Text = "Da xay ra loi: " + ex.Message;
}
}
public void deleteSchedule(schedules schedule)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
context.schedules.Remove(schedule);
context.SaveChanges();
}
}
public void updateSchedule(schedules schedule)
{
using (firedumpdbEntities1 context = new firedumpdbEntities1())
{
schedules original = context.schedules.Find(schedule.id);
context.Entry(original).CurrentValues.SetValues(schedule);
context.SaveChanges();
}
}
protected void Sua_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "sua")
{
int schedule_id = Convert.ToInt16(e.CommandArgument);
schedules schedule = data.get1Schedule(schedule_id);
Session["schedule"] = schedule;
Response.Redirect("schedulesEdit.aspx");
}
}
public ActionResult DeleteConfirmed(int id)
{
using (CenterDBEntities db = new CenterDBEntities())
{
schedules schedules = db.schedules.Find(id);
db.schedules.Remove(schedules);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public void Schedule001PC(schedules schedules)
{
string userNo = (string)Session["User_No"];
if (userNo == null)
{
RedirectToAction("Login", "Auth");
}
string startTime = Request.Form["start_time"];
int schedule_no = int.Parse(Request.Form["schedule_no"]);
using (var db = new MainDbContext())
{
var originalSchedule = db.Schedules.SingleOrDefault(r => r.SCHEDULE_NO == schedules.SCHEDULE_NO);
if (originalSchedule != null)
{
try
{
originalSchedule.ORDER_NAME = schedules.ORDER_NAME;
originalSchedule.ORDER_PHONE = schedules.ORDER_PHONE;
originalSchedule.RGSDT = DateTime.Now.ToString("yyyyMMdd");
originalSchedule.START_DT = schedules.START_DT + startTime;
originalSchedule.SCHEDULE_CONTENTS = schedules.SCHEDULE_CONTENTS;
originalSchedule.SEATER = schedules.SEATER;
originalSchedule.DRIVER_NAME = schedules.DRIVER_NAME;
originalSchedule.DIVER_CAR_NUMBER = schedules.DIVER_CAR_NUMBER;
originalSchedule.CAR_PRICE = schedules.CAR_PRICE;
originalSchedule.DISPATCH_PRICE = schedules.DISPATCH_PRICE;
originalSchedule.DEPOSIT = schedules.DEPOSIT;
originalSchedule.DEPOSIT_DT = schedules.DEPOSIT_DT;
originalSchedule.BILLING_GU = schedules.BILLING_GU;
originalSchedule.FULL_AMOUNT_YN = schedules.FULL_AMOUNT_YN;
originalSchedule.FULL_AMOUNT_DT = schedules.FULL_AMOUNT_DT;
originalSchedule.DRIVER_AMOUNT_YN = schedules.DRIVER_AMOUNT_YN;
originalSchedule.DRIVER_AMOUNT_DT = schedules.DRIVER_AMOUNT_DT;
originalSchedule.REMARK = schedules.REMARK;
originalSchedule.USER_NO = int.Parse(Session["User_No"].ToString());
originalSchedule.SCHEDULE_STASUS = "A10";
db.SaveChanges();
}
catch (Exception e)
{
throw;
}
}
ViewBag.isJob = "Success";
}
}
// GET: schedules/Details/5
public ActionResult Details(int?id)
{
using (CenterDBEntities db = new CenterDBEntities())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
schedules schedules = db.schedules.Find(id);
if (schedules == null)
{
return(HttpNotFound());
}
return(View(schedules));
}
}
public ActionResult Edit(schedules schedules)
{
using (CenterDBEntities db = new CenterDBEntities())
{
if (ModelState.IsValid)
{
schedules.Schedule_ModifiedUser = User.Identity.Name;
schedules.Schedule_ModifiedDate = DateTime.Now;
db.Entry(schedules).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Schedule_GroupID = new SelectList(db.Groups, "Group_ID", "Group_CreationUser", schedules.Schedule_GroupID);
return(View(schedules));
}
}
public ActionResult Schedule001PC(string schedule_no)
{
string userNo = (string)Session["User_No"];
if (userNo == null)
{
RedirectToAction("Login", "Auth");
}
var db = new MainDbContext();
schedules schedules = db.Schedules.Where(r => r.SCHEDULE_NO.ToString() == schedule_no).Single();
int timeLength = schedules.START_DT.Length;
ViewBag.Time = schedules.START_DT.Substring(10, timeLength - 10);
schedules.START_DT = schedules.START_DT.Substring(0, 10);
return(View(schedules));
}
// GET: schedules/Edit/5
public ActionResult Edit(int?id)
{
using (CenterDBEntities db = new CenterDBEntities())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
schedules schedules = db.schedules.Find(id);
if (schedules == null)
{
return(HttpNotFound());
}
ViewBag.Schedule_GroupID = new SelectList(db.Groups, "Group_ID", "Group_CreationUser", schedules.Schedule_GroupID);
return(View(schedules));
}
}
// Update schedule
public void updateSchedule(schedules schedule)
{
string sql = "Update schedules Set fullname=@fullname, phone=@phone, email=@email, room_id=@room_id, date_in=@date_in, date_out=@date_out Where schedule_id=@schedule_id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("schedule_id", schedule.schedule_id);
cmd.Parameters.AddWithValue("fullname", schedule.fullname);
cmd.Parameters.AddWithValue("phone", schedule.phone);
cmd.Parameters.AddWithValue("email", schedule.email);
cmd.Parameters.AddWithValue("room_id", schedule.room_id);
cmd.Parameters.AddWithValue("date_in", schedule.date_in);
cmd.Parameters.AddWithValue("date_out", schedule.date_out);
cmd.ExecuteNonQuery();
con.Close();
}
// Khách hàng Thêm 1 đặt phòng
public int ThemDatPhong(schedules schedule)
{
string sql = "Insert Into schedules (fullname, phone, email, room_id, date_in, date_out) output INSERTED.schedule_id Values (@fullname, @phone, @email, @room_id, @date_in, @date_out)";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("fullname", schedule.fullname);
cmd.Parameters.AddWithValue("phone", schedule.phone);
cmd.Parameters.AddWithValue("email", schedule.email);
cmd.Parameters.AddWithValue("room_id", schedule.room_id);
cmd.Parameters.AddWithValue("date_in", schedule.date_in);
cmd.Parameters.AddWithValue("date_out", schedule.date_out);
// Get last schedule_id insert
int schedule_id = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(schedule_id);
}
public string BatchSchedule001PA(schedules schedules)
{
string userNo = (string)Session["User_No"];
if (userNo == null)
{
RedirectToAction("Login", "Auth");
}
using (var db = new MainDbContext())
{
string startTime = Request.Form["start_time"];
var schedule = db.Schedules.Create();
schedule.ORDER_NAME = schedules.ORDER_NAME;
schedule.ORDER_PHONE = schedules.ORDER_PHONE;
schedule.RGSDT = DateTime.Now.ToString("yyyyMMdd");
schedule.START_DT = schedules.START_DT + startTime;
schedule.SCHEDULE_CONTENTS = schedules.SCHEDULE_CONTENTS;
schedule.SEATER = schedules.SEATER;
schedule.DRIVER_NAME = schedules.DRIVER_NAME;
schedule.DIVER_CAR_NUMBER = schedules.DIVER_CAR_NUMBER;
schedule.CAR_PRICE = schedules.CAR_PRICE;
schedule.DISPATCH_PRICE = schedules.DISPATCH_PRICE;
schedule.DEPOSIT = schedules.DEPOSIT;
schedule.DEPOSIT_DT = schedules.DEPOSIT_DT;
schedule.BILLING_GU = schedules.BILLING_GU;
schedule.FULL_AMOUNT_YN = schedules.FULL_AMOUNT_YN;
schedule.FULL_AMOUNT_DT = schedules.FULL_AMOUNT_DT;
schedule.DRIVER_AMOUNT_YN = schedules.DRIVER_AMOUNT_YN;
schedule.DRIVER_AMOUNT_DT = schedules.DRIVER_AMOUNT_DT;
schedule.REMARK = schedules.REMARK;
schedule.USER_NO = int.Parse(Session["User_No"].ToString());
schedule.SCHEDULE_STASUS = "A10";
db.Schedules.Add(schedule);
db.SaveChanges();
}
ChatId ChatId = new ChatId(295219317);
Bot.SendTextMessageAsync(ChatId, schedules.ORDER_NAME + "님의 일정이 추가되었습니다");
return("success");
}
private async void SaveAction(object obj)
{
try
{
schedules model = (schedules)this;
var result = await context.AddNewSchedule(model);
if (result != null)
{
var newSchedule = new Schedule
{
Complete = result.Complete,
CreatedDate = result.CreatedDate,
DestinationCityCode = DestinationSelected.Code,
DestinationPortCode = DestinationSelected.Code,
DestinationCityName = DestinationSelected.City,
DestinationPortName = DestinationSelected.Name,
End = result.End,
Id = result.Id,
FlightNumber = FlightNumber,
OriginCityCode = OriginSelected.Code,
OriginCityName = OriginSelected.City,
OriginPortCode = OriginSelected.Code,
OriginPortName = OriginSelected.Name,
PlaneId = result.PlaneId, PlaneName = PlaneSelected.Name, PlaneCode = PlaneSelected.Kode,
PortFrom = result.PortFrom,
Start = result.Start,
Tanggal = result.Tanggal, PortTo = result.PortTo, Capasities = result.Capacities
};
this.SchedulteCreated = newSchedule;
Success = true;
WindowClose();
}
}
catch (Exception ex)
{
Helpers.ShowErrorMessage(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
schedules schedule = (schedules)Session["schedule"];
schedule_id.Text = schedule.schedule_id.ToString();
fullname.Text = schedule.fullname;
phone.Text = schedule.phone;
email.Text = schedule.email;
date_in.Text = schedule.date_in.ToString("yyyy-MM-dd");
date_out.Text = schedule.date_out.ToString("yyyy-MM-dd");
room_id.DataSource = data.getAllRooms();
room_id.DataValueField = "room_id";
room_id.DataTextField = "room_name";
DataBind();
room_id.SelectedValue = schedule.room_id.ToString();
old_room_id.Text = schedule.room_id.ToString();
}
}
protected void btn_BookRoom_Click(object sender, EventArgs e)
{
try
{
schedules schedule = new schedules();
schedule.fullname = txtFullname.Text;
schedule.phone = txtPhone.Text;
schedule.email = txtEmail.Text;
schedule.date_in = DateTime.Parse(txtDateIn.Text);
schedule.date_out = DateTime.Parse(txtDateOut.Text);
schedule.room_id = int.Parse(category.Text);
DateTime DateIn = (schedule.date_in);
DateTime DateOut = (schedule.date_out);
TimeSpan tmp_day = DateOut.Subtract(DateIn);
double num_day = tmp_day.TotalDays + 1;
// Thêm đặt phòng
Int32 schedule_id = data.ThemDatPhong(schedule);
// Cập nhật room_status phòng vừa đặt là 1 (Đã dùng)
data.updateRoomUsed(schedule.room_id);
// Tạo 1 bills cho KH này theo schedule_id
data.createBills(schedule_id, num_day);
err_msg.ForeColor = System.Drawing.Color.Aqua;
err_msg.Text = "Bạn đã đặt phòng thành công!";
}
catch (Exception ex)
{
err_msg.ForeColor = System.Drawing.Color.Red;
err_msg.Text = "Đã xảy ra lỗi: " + ex.Message;
}
}
public int saveSchedule(schedules schedule)
{
contextdb.schedules.Add(schedule);
contextdb.SaveChanges();
return((int)schedule.id);
}
public void TestMysqlserversGetSave()
{
Firedump.tests.TestContext context = new Firedump.tests.TestContext();
FiredumpContextTest service = new FiredumpContextTest(context);
for (int i = 0; i <= 100; i++)
{
sqlservers server = new sqlservers();
server.port = -10000 + i;
server.host = "HOST" + i;
server.name = "N" + i;
server.password = "******" + i;
server.username = "******" + i;
server.id = i;
service.saveMysqlServer(server);
}
List <sqlservers> servers = service.getAllMySqlServers();
Assert.AreEqual(101, servers.Count);
TestMysql_serverDbSet mysqlserverContext = new TestMysql_serverDbSet();
service = new FiredumpContextTest(mysqlserverContext);
for (int i = 0; i <= 100; i++)
{
sqlservers server = new sqlservers();
server.port = -10000 + i;
server.host = "HOST" + i;
server.name = "N" + i;
server.password = "******" + i;
server.username = "******" + i;
server.id = i;
service.saveMysqlServer(server);
}
servers = service.getAllMySqlServers();
Assert.AreEqual(101, servers.Count);
for (int i = 0; i < servers.Count; i++)
{
sqlservers temps = mysqlserverContext.Find((int)servers[i].id);
Assert.AreEqual(servers[i], temps);
Assert.AreEqual(servers[i].id, temps.id);
Assert.AreEqual(servers[i].host, temps.host);
Assert.AreEqual(servers[i].name, temps.name);
Assert.AreEqual(servers[i].password, temps.password);
Assert.AreEqual(servers[i].port, temps.port);
}
sqlservers mysqlserver = service.getAllMySqlServers()[0];
schedules schedule = new schedules();
schedule.hours = 1;
schedule.activated = 0;
schedule.date = new DateTime();
schedule.name = "scheduleName";
schedule.server_id = mysqlserver.id;
service.saveSchedule(schedule);
servers = service.getAllMySqlServers();
List <schedules> schedules = service.getSchedules();
for (int i = 0; i < servers.Count; i++)
{
}
}
public Task <schedules> AddNewSchedule(schedules model)
{
var date = DateTime.Now;
model.CreatedDate = date;
using (var db = new OcphDbContext())
{
var trans = db.BeginTransaction();
try
{
var manifest = db.Manifest.Where(O => O.SchedulesId == model.Id).FirstOrDefault();
if (manifest != null && manifest.IsTakeOff)
{
throw new SystemException("Data Tidak Dapat Di Ubah Pesawat Telah Berangkat");
}
if (User.CanAccess(MethodBase.GetCurrentMethod()))
{
if (model.Id <= 0)
{
model.Id = db.Schedules.InsertAndGetLastID(model);
if (model.Id > 0)
{
var history = User.GenerateHistory(model.Id, BussinesType.Schedule, ChangeType.Create, "");
if (db.Histories.Insert(history))
{
trans.Commit();
model.User = User.Name;
return(Task.FromResult(model));
}
else
{
throw new SystemException("Data Tidak Tersimpan");
}
}
else
{
throw new SystemException("Data Tidak Tersimpan");
}
}
else
{
if (db.Schedules.Update(O => new { O.Capacities, O.Complete, O.End, O.Start, O.FlightNumber, O.PlaneId, O.PortFrom, O.PortTo, O.Tanggal, O.CreatedDate }, model, O => O.Id == model.Id))
{
var history = User.GenerateHistory(model.Id, BussinesType.Schedule, ChangeType.Update, "");
if (db.Histories.Insert(history))
{
trans.Commit();
model.User = User.Name;
return(Task.FromResult(model));
}
else
{
throw new SystemException("Data Tidak Tersimpan");
}
}
else
{
throw new SystemException("Data Tidak Tersimpan");
}
}
}
else
{
throw new SystemException(NotHaveAccess);
}
;
}
catch (Exception ex)
{
trans.Rollback();
throw new SystemException(ex.Message);
}
}
}
".xlsx" => new ScheduleExporterExcel(schedules, fileInfo, (ExcelExportMode)exportMode),
