private void dgDieuXe_CellClick(object sender, DataGridViewCellEventArgs e)
{
lbTenTX.Text = dgDieuXe.CurrentRow.Cells[8].Value.ToString();
lbSDT.Text = dgDieuXe.CurrentRow.Cells[9].Value.ToString();
lbTuyenDuong.Text = dgDieuXe.CurrentRow.Cells[6].Value.ToString() + " / " + dgDieuXe.CurrentRow.Cells[7].Value.ToString();
dgDinhVi.DataSource = LichTrinh.HienThi(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
}
public void InsertNguonVeGoc(LichTrinh _item)
{
// tao nguon ve goc
var nhaxe = _nhaxeRepository.GetById(_item.NhaXeId);
var loaixe = _LoaiXeRepository.GetById(_item.LoaiXeId);
var hanhtrinhdiemdons = GetAllHanhTrinhDiemDonByHanhTrinhId(_item.HanhTrinhId);
var diemdon1 = GetDiemDonById(hanhtrinhdiemdons[0].DiemDonId);
var diachi1 = _diachiRepository.GetById(diemdon1.DiaChiId);
var diemdon2 = GetDiemDonById(hanhtrinhdiemdons[hanhtrinhdiemdons.Count - 1].DiemDonId);
var diachi2 = _diachiRepository.GetById(diemdon2.DiaChiId);
var nguonve = new NguonVeXe();
nguonve.NhaXeId = _item.NhaXeId;
nguonve.LichTrinhId = _item.Id;
//lay diem don la thong tin Tinh
nguonve.DiemDonId = GetDiaDiemId(diachi1.ProvinceID, ENLoaiDiaDiem.Tinh);
nguonve.DiemDenId = GetDiaDiemId(diachi2.ProvinceID, ENLoaiDiaDiem.Tinh);
nguonve.DiemDonGocId = diemdon1.Id;
nguonve.DiemDenGocId = diemdon2.Id;
nguonve.TenDiemDon = diachi1.Province.Name;
nguonve.TenDiemDen = diachi2.Province.Name;
nguonve.ThoiGianDi = _item.ThoiGianDi;
nguonve.LoaiXeId = _item.LoaiXeId;
nguonve.ThoiGianDen = nguonve.ThoiGianDi.AddHours(Convert.ToDouble(_item.SoGioChay));
nguonve.TimeCloseOnline = _item.TimeCloseOnline;
nguonve.TimeOpenOnline = _item.TimeOpenOnline;
nguonve.TenNhaXe = nhaxe.TenNhaXe;
nguonve.TenLoaiXe = loaixe.TenLoaiXe;
nguonve.GiaVeHienTai = _item.GiaVeToanTuyen;
//tao ra thong tin san pham
TaoNguonVeProduct(nguonve, _item.GiaVeToanTuyen);
//tao nguon ve theo tuyen,
//TaoTuyenVeXe(diachi1.Province, diachi2.Province, _item.GiaVeToanTuyen, loaixe.KieuXe);
//tao cac danh muc cac diem don de co phuc vu tim kiem
//tinh
NguonVeXeDiaDiemInsert(nguonve.Id, true, nguonve.DiemDonId);
NguonVeXeDiaDiemInsert(nguonve.Id, false, nguonve.DiemDenId);
//ben xe
if (diemdon1.BenXeId != null && diemdon1.BenXeId > 0)
{
NguonVeXeDiaDiemInsert(nguonve.Id, true, GetDiaDiemId(diemdon1.BenXeId.GetValueOrDefault(0), ENLoaiDiaDiem.BenXe));
}
if (diemdon2.BenXeId != null && diemdon2.BenXeId > 0)
{
NguonVeXeDiaDiemInsert(nguonve.Id, false, GetDiaDiemId(diemdon2.BenXeId.GetValueOrDefault(0), ENLoaiDiaDiem.BenXe));
}
//quan, huyen
if (diachi1.QuanHuyenID != null && diachi1.QuanHuyenID > 0)
{
NguonVeXeDiaDiemInsert(nguonve.Id, true, GetDiaDiemId(diachi1.QuanHuyenID.GetValueOrDefault(0), ENLoaiDiaDiem.QuanHuyen));
}
if (diachi2.QuanHuyenID != null && diachi2.QuanHuyenID > 0)
{
NguonVeXeDiaDiemInsert(nguonve.Id, false, GetDiaDiemId(diachi2.QuanHuyenID.GetValueOrDefault(0), ENLoaiDiaDiem.QuanHuyen));
}
}
public SubDeclareWorkCalendar(LichTrinh lichTrinh, string WorkCalendarShowType)
{
this.lichTrinh = lichTrinh;
this.Text = "Lịch Trình(" + lichTrinh.TenLichTrinh + ")";
this.WorkCalendarShowType = WorkCalendarShowType;
//SetDoubleBuffer(treeView1, true);
InitializeComponent();
}
private void barButtonItemRefresh_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
allowInsert = false;
barButtonItemAddNew.Enabled = true;
LichTrinh lichtrinh = new LichTrinh();
SetLichTrinh(lichtrinh);
RefreshGrid1();
}
public virtual void DeleteLichTrinh(LichTrinh _item)
{
if (_item == null)
{
throw new ArgumentNullException("LichTrinh");
}
DeleteLichTrinhGiaVe(_item.Id);
_LichTrinhRepository.Delete(_item);
}
private void btnKetThuc_Click(object sender, EventArgs e)
{
// DieuXe.Thoigiancho = KetNoi.ThucThi()
DieuXe.Thoigiancho = LichTrinh._thoiGiabCho(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
DieuXe.Thoigiandi = LichTrinh._thoiGiabDi(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
DieuXe.Quadem = LichTrinh._quadem(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
DieuXe.Madon = Int16.Parse(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
KetThuc kt = new KetThuc();
kt.Show();
}
public ActionResult ThemLichTrinh(LichTrinh lichTrinh, HttpPostedFileBase post)
{
if (post != null)
{
var paths = Server.MapPath("~/content/images/Destinations/");
var path = "/Content/images/Destinations/";
post.SaveAs(paths + post.FileName);
lichTrinh.DuongDanAnh = path + post.FileName;
}
_context.LichTrinhs.Add(lichTrinh);
_context.SaveChanges();
return(RedirectToAction("ThemLichTrinh"));
}
public static string toText(this LichTrinh item, bool withMa = true)
{
if (item == null)
{
return("");
}
if (withMa)
{
return(string.Format("{0} - {1} : {2}", item.ThoiGianDi.ToString("HH:mm"), item.ThoiGianDi.AddMinutes(item.KhungThoiGian).ToString("HH:mm"), item.MaLichTrinh));
}
return(string.Format("{0} - {1}", item.ThoiGianDi.ToString("HH:mm"), item.ThoiGianDi.AddMinutes(item.KhungThoiGian).ToString("HH:mm")));
}
public virtual bool UpdateLichTrinh(LichTrinh _item)
{
if (_item == null)
{
throw new ArgumentNullException("LichTrinh");
}
var existitem = 0;
if (existitem == 0)
{
_LichTrinhRepository.Update(_item);
return(true);
}
return(false);
}
private void LisView2Config(LichTrinh lichTrinh, int month)
{
if (WorkCalendarShowType == "week")
{
ListViewItem weekitem = new ListViewItem("Chủ Nhật");
weekitem.Tag = 1;
listView2.Items.Add(weekitem);
for (int i = 2; i < 8; i++)
{
ListViewItem weekitem2 = new ListViewItem("Thứ " + i.ToString());
weekitem2.Tag = i;
listView2.Items.Add(weekitem2);
}
weekitem = new ListViewItem("Ngày Lễ");
weekitem.Tag = 8;
listView2.Items.Add(weekitem);
comboBox1.Enabled = false;
}
if (WorkCalendarShowType == "month")
{
for (int i = 1; i < 32; i++)
{
ListViewItem monthitem = new ListViewItem("Ngày " + i.ToString());
monthitem.Tag = i;
listView2.Items.Add(monthitem);
}
ListViewItem item2 = new ListViewItem("Ngày Lễ 32");
item2.Tag = 32;
listView2.Items.Add(item2);
comboBox1.Enabled = false;
}
if (WorkCalendarShowType == "year")
{
comboBox1.Enabled = true;
int dayInMonth = DateTime.DaysInMonth(DateTime.Now.Year, month);
for (int i = 1; i <= dayInMonth; i++)
{
ListViewItem day = new ListViewItem("Ngày " + i.ToString());
day.Tag = i;
listView2.Items.Add(day);
}
ListViewItem item2 = new ListViewItem("Ngày Lễ 32");
item2.Tag = 32;
listView2.Items.Add(item2);
comboBox1.Enabled = true;
}
}
private void SetLichTrinh(LichTrinh lichTrinh)
{
ATINChamCongEntities context = new ATINChamCongEntities();
var lstMap = context.spGetMapLichTrinhNangCaoByLichTrinh(lichTrinh.MaLichTrinh).ToList();
textEdit1.Text = lichTrinh.MaLichTrinh;
textEdit2.Text = lichTrinh.TenLichTrinh;
checkBox1.Checked = false;
checkBox2.Checked = false;
checkBox3.Checked = false;
checkBox4.Checked = false;
checkBox5.Checked = false;
foreach (var map in lstMap)
{
switch (map.MaLichTrinhNangCao)
{
case "NC1": checkBox1.Checked = true; break;
case "NC2": checkBox2.Checked = true; break;
case "NC3": checkBox3.Checked = true; break;
case "NC4": checkBox4.Checked = true; break;
case "NC5": checkBox5.Checked = true; break;
}
}
switch (lichTrinh.LoaiChuKy)
{
case "week":
radioButton1.Checked = true;
WorkCalendarShowType = "week";
break;
case "month":
radioButton2.Checked = true;
WorkCalendarShowType = "monh";
break;
case "year":
radioButton3.Checked = true;
WorkCalendarShowType = "year";
break;
}
RefreshGrid2(lichTrinh.MaLichTrinh);
}
private void Set()
{
ATINChamCongEntities context = new ATINChamCongEntities();
var lstLichTrinh = context.spGetAllLichTrinh().ToList();
LichTrinh lichTrinhNuLL = new LichTrinh {
MaLichTrinh = null, TenLichTrinh = "Chưa Xếp"
};
lstLichTrinh.Add(lichTrinhNuLL);
List <LichTrinh> lstLichTrinh2 = new List <LichTrinh>(lstLichTrinh);
comboBox1.DataSource = lstLichTrinh;
comboBox2.DataSource = lstLichTrinh2;
comboBox1.DisplayMember = "TenLichTrinh";
comboBox2.DisplayMember = "TenLichTrinh";
comboBox1.ValueMember = "MaLichTrinh";
comboBox2.ValueMember = "MaLichTrinh";
dateEditFromDate.DateTime = DateTime.Now;
dateEditToDate.DateTime = DateTime.Now;
}
public virtual bool UpdateLichTrinh(LichTrinh _item)
{
if (_item == null)
{
throw new ArgumentNullException("LichTrinh");
}
var existitem = 0;
if (existitem == 0)
{
_LichTrinhRepository.Update(_item);
//update loai xe cua nguon ve theo lich trinh
var nguonve = GetNguonVeXeToanTuyen(_item.Id);
nguonve.LoaiXeId = _item.LoaiXeId;
nguonve.ThoiGianDi = _item.ThoiGianDi;
nguonve.ThoiGianDen = _item.ThoiGianDen;
_NguonVeXeRepository.Update(nguonve);
return(true);
}
return(false);
}
//using Singleton to create only one Instance of form
private PrepareEmployeeCalenda()
{
InitializeComponent();
this.Dock = DockStyle.Fill;
SetDoubleBuffer(dataGridView1, true);
SetDoubleBuffer(dataGridView2, true);
TreeView1Config();
ATINChamCongEntities context = new ATINChamCongEntities();
var lstLichTrinh = context.spGetAllLichTrinh().ToList();
LichTrinh lichTrinhEmpty = new LichTrinh {
MaLichTrinh = null, TenLichTrinh = "Chưa Xếp", LoaiChuKy = null
};
lstLichTrinh.Add(lichTrinhEmpty);
DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
col.DataSource = lstLichTrinh;
col.Name = "col";
col.DisplayMember = "TenLichTrinh";
col.DataPropertyName = "MaLichTrinh";
col.ValueMember = "MaLichTrinh";
col.HeaderText = "Lịch trình";
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
col.DefaultCellStyle.NullValue = lichTrinhEmpty.TenLichTrinh;
col.DefaultCellStyle.DataSourceNullValue = lichTrinhEmpty.MaLichTrinh;
dataGridView1.Columns.Add(col);
DataGridViewCheckBoxColumn checkCol = new DataGridViewCheckBoxColumn();
checkCol.Name = "Checkbox";
checkCol.DataPropertyName = "Checkbox";
checkCol.HeaderText = "";
checkCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
checkCol.Width = 120;
checkCol.DefaultCellStyle.NullValue = false;
checkCol.DefaultCellStyle.DataSourceNullValue = false;
dataGridView1.Columns.Add(checkCol);
Set();
}
public ActionResult EditLichTrinh(LichTrinh lichTrinh, HttpPostedFileBase postfiles)
{
try
{
var dd = _context.DiaDiems.Find(lichTrinh.MaTinhNang);
if (postfiles != null)
{
var paths = Server.MapPath("~/content/images/Destinations/");
var path = "/Content/images/Destinations/";
postfiles.SaveAs(paths + postfiles.FileName);
lichTrinh.DuongDanAnh = path + postfiles.FileName;
dd.DuongDanAnh = lichTrinh.DuongDanAnh;
}
_context.LichTrinhs.Add(lichTrinh);
_context.SaveChanges();
return(RedirectToAction("QuanLyLichTrinh"));
}
catch
{
return(View());
}
}
private LichTrinh GetLichTrinh()
{
LichTrinh lichTrinh = new LichTrinh();
lichTrinh.MaLichTrinh = textEdit1.Text.Trim();
lichTrinh.TenLichTrinh = textEdit2.Text.Trim();
if (radioButton1.Checked)
{
lichTrinh.LoaiChuKy = "week";
}
if (radioButton2.Checked)
{
lichTrinh.LoaiChuKy = "month";
}
if (radioButton3.Checked)
{
lichTrinh.LoaiChuKy = "year";
}
else
{
lichTrinh.LoaiChuKy = "week";
}
return(lichTrinh);
}
private void Save(string MaLichTrinhChon, LichTrinh lichTrinh, ref bool allowInsert)
{
try
{
//insert
if (allowInsert)
{
ATINChamCongEntities context = new ATINChamCongEntities();
context.spInsertLichTrinh(
lichTrinh.MaLichTrinh,
lichTrinh.TenLichTrinh,
lichTrinh.LoaiChuKy
);
if (checkBox1.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC1");
}
if (checkBox2.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC2");
}
if (checkBox3.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC3");
}
if (checkBox4.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC4");
}
if (checkBox5.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC5");
}
}
//update
else
{
ATINChamCongEntities context = new ATINChamCongEntities();
context.spUpdateLichTrinh(
MaLichTrinhChon,
lichTrinh.MaLichTrinh,
lichTrinh.TenLichTrinh,
lichTrinh.LoaiChuKy
);
if (checkBox1.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC1");
}
else
{
context.spDeleteMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC1");
}
if (checkBox2.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC2");
}
else
{
context.spDeleteMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC2");
}
if (checkBox3.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC3");
}
else
{
context.spDeleteMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC3");
}
if (checkBox4.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC4");
}
else
{
context.spDeleteMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC4");
}
if (checkBox5.Checked)
{
context.spInsertMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC5");
}
else
{
context.spDeleteMapLichTrinhNangCao(lichTrinh.MaLichTrinh, "NC5");
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
LichTrinh.Cap_Nhap(dgDieuXe.CurrentRow.Cells[0].Value.ToString(), txtDiaDiem.Text, cbTrangThai.Text, txtGhiChu.Text);
dgDinhVi.DataSource = LichTrinh.HienThi(dgDieuXe.CurrentRow.Cells[0].Value.ToString());
}
