// 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),