public void simpleButtonMo_Click(object sender, EventArgs e)
{
if (dataGridViewKeHoach.SelectedRows == null)
{
MessageBox.Show("Hãy chọn kế hoạch để mở");
}
else
{
//KeHoach selectedKeHoach = new KeHoach()
//{
// MaKeHoach = Int32.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaKeHoach].Value.ToString()),
// TenKeHoach = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.TenKeHoach].Value.ToString(),
// MaNguoiLap = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaNguoiLap].Value.ToString(),
// ThoiGianTao = DateTime.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.ThoiGianLap].Value.ToString()),
// TenNguoiLap = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.NguoiLapKeHoach].Value.ToString(),
//};
int ma = Int32.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaKeHoach].Value
.ToString());
KeHoach selectedKeHoach = Program.KeHoachSql.GetKeHoachAndDetailById(ma);
MoKeHoach(selectedKeHoach);
// Kiểm tra xem file có đúng định dạng không
if (Program.frm_Map.KeHoach.FileDem == null)
{
var result = MessageBox.Show(
"File dữ liệu không tồn tại hoặc không đúng định dạng ! Bạn có muốn mở hướng dẫn sử dụng ?", "Lỗi", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (result == DialogResult.Yes)
{
string filePath = @"..\..\..\TỔNG QUAN.docx";
System.Diagnostics.Process.Start(filePath);
}
}
}
}
// Load Thong tin ke hoach vao trong cac text box
public void LoadKeHoachDeTail(KeHoach keHoach)
{
textEditTenPhuongAn.Text = keHoach.TenKeHoach;
timeEditThoiGianLap.DateTime = keHoach.ThoiGianTao;
if (keHoach.BanDo != null)
{
foreach (ComboBoxItemBanDo comboBoxItemBanDo in comboBoxMaBanDo.Items)
{
if (comboBoxItemBanDo.MaBanDo == keHoach.BanDo.MaBanDo)
{
comboBoxMaBanDo.SelectedItem = comboBoxItemBanDo;
comboBoxTenBanDo.SelectedItem = comboBoxItemBanDo;
}
}
}
if (keHoach.FileDem != null)
{
foreach (ComboBoxItemFileDem comboBoxItemFileDem in comboBoxMaFile.Items)
{
if (comboBoxItemFileDem.MaFile == keHoach.FileDem.MaFile)
{
comboBoxMaBanDo.SelectedItem = comboBoxItemFileDem;
}
}
}
}
public void Update(KeHoach kehoach)
{
var entry = db.Entry(kehoach); //provides information, ability to perform actions on the entity
entry.State = EntityState.Modified;
db.SaveChanges();
}
public void load(string id)
{
checkString c = new checkString();
k = bus.getKeHoach(id);
View(id);
labelXemThoiGian.Text = k.NgayThucHien.ToString("dd/MM/yyyy");
richTextBoxND.Text = k.NoiDung;
richTextBoxCT.Text = k.ChuThich;
}
// GET: QuanLyKeHoach
public ActionResult ThemMoi(string id, FormCollection model)
{
//kiểm tra tham số truyền vào có rổng hay không
if (id == null)
{
return(new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest));
}
//nếu không truy xuất csdl lấy ra sản phẩm tướng ứng
MonAn monAn = db.MonAns.SingleOrDefault(n => n.Id == id);
if (monAn == null)
{
//Thôn báo nếu không có sản phẩm đó
return(HttpNotFound());
}
//ViewBag.Thu = new SelectList(db.Thus.OrderBy(n => n.Name), "Id", "Name");
//ViewBag.Buoi = new SelectList(db.Buois.OrderBy(n => n.Name), "Id", "Name");
if (model["Name"] == null)
{
Session["IDMon"] = id;
}
else
{
string name = model["Name"];
string ghichu = model["GhiChu"];
string soluong = model["SoLuong"];
string date = model["datepicker"];
string buoi = model["select"];
string thu = model["select2"];
string idthucdon = (dbthucdon.getCount() + 1).ToString();
//add thực đơn
//Add a thuc don in table Login
ThucDon thucdon = new ThucDon();
thucdon.Id = idthucdon;
thucdon.IdMonAn = (string)Session["IDMon"];
thucdon.IdNguoiDung = (string)Session["ID"];
thucdon.Name = name;
thucdon.SoLuong = int.Parse(soluong.ToString());
thucdon.GhiChu = ghichu;
dbthucdon.Add(thucdon);
//Add a ke hoach in table Login
KeHoach kehoach = new KeHoach();
kehoach.IdThucDon = idthucdon;
kehoach.IdThu = thu;
kehoach.IdBuoi = buoi;
kehoach.NgayLapKeHoach = Convert.ToDateTime(date);
kehoach.GhiChu = ghichu;
dbkehoach.Add(kehoach);
}
//Session["IDMon"] = id;
return(View());
}
public void simpleButtonMo_Click(object sender, EventArgs e)
{
if (dataGridViewKeHoach.SelectedRows == null)
{
MessageBox.Show("Hãy chọn kế hoạch để mở");
}
else
{
//KeHoach selectedKeHoach = new KeHoach()
//{
// MaKeHoach = Int32.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaKeHoach].Value.ToString()),
// TenKeHoach = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.TenKeHoach].Value.ToString(),
// MaNguoiLap = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaNguoiLap].Value.ToString(),
// ThoiGianTao = DateTime.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.ThoiGianLap].Value.ToString()),
// TenNguoiLap = dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.NguoiLapKeHoach].Value.ToString(),
//};
int ma = Int32.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaKeHoach].Value
.ToString());
KeHoach selectedKeHoach = Program.KeHoachSql.GetKeHoachAndDetailById(ma);
MoKeHoach(selectedKeHoach);
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
// kiểm tra nội dung vừa nhập
if (check() == false)
{
return;
}
//danh sách chứa check box được chọn
List <int> l = new List <int>();
foreach (CheckBox item in listCheck)
{
if (item.Checked == true)
{
int key = loai.FirstOrDefault(x => x.Value == item.Text).Key;
l.Add(key);
}
}
//MessageBox.Show(l.Count.ToString());
// kiểm tra đã chọn công việc chưa
if (l.Count != 0)
{
KeHoach o = new KeHoach();
o.NgayThucHien = DatepickerThucHien.Value.Date;
o.NoiDung = richTextBoxND.Text;
o.ChuThich = richTextBoxCT.Text;
o.SoLuongCongViec = l.Count;
o.SoLuongCongViecHoanThanh = 0;
//// set lại đăng nhập
o.MaNguoiLap = 1;
bus.Add(o, l);
MessageBox.Show("Đã lập thành công");
Close();
}
}
public void MoKeHoach(KeHoach keHoach)
{
if (Program.frm_Map.listAdd.Count != 0 || Program.frm_Map.listUpdate.Count != 0 || Program.frm_Map.listRemove.Count != 0)
{
DialogResult dialogResult = MessageBox.Show("Bạn có thông tin chưa lưu lại ! Bạn có muốn lưu lại trước khi mở một kế hoạch khác", "Cảnh báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
simpleButtonLuu_Click(null, null);
}
}
Program.frm_Map.KeHoach = keHoach;
if (keHoach.BanDo != null)
{
Frm_test1.bitmapInit1 = new Bitmap(keHoach.BanDo.DuongDanAnh);
// Resize bitmap background
Program.frm_Map.bitmapInit = new Bitmap(Frm_test1.bitmapInit1, 1201, 1201);
Program.frm_Map.pictureBoxMap.Image = Program.frm_Map.bitmapInit;
// Bitmap Temp to be used in virtualization
Program.frm_Map.bitmapTemp = new Bitmap(Frm_test1.bitmapInit1, 1201, 1201);
// Bitmap to be used in resize mode
Program.frm_Map.bitmapResize = new Bitmap(Frm_test1.bitmapInit1, 1201, 1201);
}
if (keHoach.FileDem != null)
{
if (System.IO.File.Exists(keHoach.FileDem.DuongDan))
{
Program.frm_Map.path = keHoach.FileDem.DuongDan;
Frm_test1._mDem = new DemDocument();
Frm_test1._mDem.Read(keHoach.FileDem.DuongDan);
Program.frm_Map.txtOutput.Text = string.Empty;
Program.frm_Map.txtOutput.Text += "DEM Name: " + new string(Frm_test1._mDem.ARecord.file_name) + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "SE Coord: " + new string(Frm_test1._mDem.ARecord.SE_geographic_corner_S) + ", " +
new string(Frm_test1._mDem.ARecord.SE_geographic_corner_E) + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "DEM Level Code: " + Frm_test1._mDem.ARecord.dem_level_code + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Ground Reference System: " +
(GROUND_REF_SYSTEM)Frm_test1._mDem.ARecord.ground_ref_system + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Ground Reference Zone: " + Frm_test1._mDem.ARecord.ground_ref_zone + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Ground Unit: " + (GROUND_UNIT)Frm_test1._mDem.ARecord.ground_unit + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Elevation Unit: " + (ELEVATION_UNIT)Frm_test1._mDem.ARecord.elevation_unit +
Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Ground Resolution (lat, lng, elev): " + Frm_test1._mDem.ARecord.xyz_resolution[0] + ", " +
Frm_test1._mDem.ARecord.xyz_resolution[1] + ", " + Frm_test1._mDem.ARecord.xyz_resolution[2] +
Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Elavation Array Szie: " + Frm_test1._mDem.ARecord.northings_rows + " x " +
Frm_test1._mDem.ARecord.eastings_cols + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "Percentage void: " + Frm_test1._mDem.ARecord.percent_void + Environment.NewLine;
Program.frm_Map.txtOutput.Text += "SW Coord: " + Frm_test1._mDem.ARecord.sw_coord[0] + ", " + Frm_test1._mDem.ARecord.sw_coord[1] +
Environment.NewLine;
Program.frm_Map.txtOutput.Text += "NW Coord: " + Frm_test1._mDem.ARecord.nw_coord[0] + ", " + Frm_test1._mDem.ARecord.nw_coord[1] +
Environment.NewLine;
Program.frm_Map.txtOutput.Text += "NE Coord: " + Frm_test1._mDem.ARecord.ne_coord[0] + ", " + Frm_test1._mDem.ARecord.ne_coord[1] +
Environment.NewLine;
Program.frm_Map.txtOutput.Text += "SE Coord: " + Frm_test1._mDem.ARecord.se_coord[0] + ", " + Frm_test1._mDem.ARecord.se_coord[1] +
Environment.NewLine;
}
}
this.isChange.DoiTuongs = Program.ThongTinChiTietDoiTuongSql.LayCacDoiTuongTuKeHoach(keHoach.MaKeHoach, TreeView, ImageList, Count);
this.isChange.BoolVar = true;
this.Dispose();
}
// Luu lai ke hoach da tao
private void simpleButtonLuu_Click(object sender, EventArgs e)
{
// Neu chua dang nhap thi bao loi
if (Program.lg.UserLogin == null)
{
MessageBox.Show("Bạn Phải Đăng Nhập");
return;
}
// Neu dang mo mot ke hoach
if (Program.frm_Map.KeHoach != null)
{
// Neu chon ke hoach khac de luu thi bao canh bao
//if (Program.frm_Map.KeHoach.MaKeHoach
// != Int32.Parse(dataGridViewKeHoach.SelectedRows[0].Cells[(int)ThongTinKeHoach.MaKeHoach].Value.ToString()))
//{
// MessageBox.Show("Bạn đang chọn lưu vào một phương án khác\n Hãy tạo phương án mới hoặc mở phương án trước khi lưu");
// return;
//}
//else
{
Program.frm_Map.KeHoach.TenKeHoach = textEditTenPhuongAn.Text;
Program.frm_Map.KeHoach.ThoiGianTao = timeEditThoiGianLap.DateTime;
Program.KeHoachSql.UpdateKeHoach(Program.frm_Map.KeHoach);
List <ThongTinChiTietDoiTuong> list = new List <ThongTinChiTietDoiTuong>();
// Them cac doi tuong moi
foreach (DoiTuong doiTuong in Program.frm_Map.listAdd)
{
list.Add(doiTuong.ThongTinChiTietDoiTuong);
}
Program.ThongTinChiTietDoiTuongSql.AddDoiTuong(list);
// Sua cac doi tuong duoc sua doi
Program.ThongTinChiTietDoiTuongSql.SuaDoiTuong(Program.frm_Map.listUpdate);
// Xoa cac doi tuong khong con tren ban do
Program.ThongTinChiTietDoiTuongSql.XoaDoiTuong(Program.frm_Map.listRemove);
// Lưu lại bản đồ và file dem
if (comboBoxMaBanDo.SelectedItem != null)
{
if (Program.frm_Map.KeHoach.BanDo != null)
{
Program.ThongTinBanDoKeHoachSql.RemoveThongTinBanDoKeHoach(Program.frm_Map.KeHoach.MaThongTinBanDoKeHoach);
}
ComboBoxItemBanDo banDo = (ComboBoxItemBanDo)comboBoxMaBanDo.SelectedItem;
Program.frm_Map.KeHoach.BanDo = new BanDo()
{
MaBanDo = banDo.MaBanDo,
DuongDanAnh = banDo.DuongDan,
TenBanDo = banDo.TenBanDo
};
Program.ThongTinBanDoKeHoachSql.AddThongTinBanDoKeHoach(new ThongTinBanDoKeHoach()
{
MaKeHoach = Program.frm_Map.KeHoach.MaKeHoach,
MaBanDo = Program.frm_Map.KeHoach.BanDo.MaBanDo,
});
}
if (comboBoxMaFile.SelectedItem != null)
{
if (Program.frm_Map.KeHoach.FileDem != null)
{
Program.ThongTinFileDemKeHoachSql.RemoveThongTinFileDemKeHoach(Program.frm_Map.KeHoach.MaThongTinFileDemKeHoach);
}
ComboBoxItemFileDem file = (ComboBoxItemFileDem)comboBoxMaFile.SelectedItem;
Program.frm_Map.KeHoach.FileDem = new Dem()
{
MaFile = file.MaFile,
TenFile = file.TenFile,
DuongDan = file.DuongDan
};
Program.ThongTinFileDemKeHoachSql.AddThongTinFileDemKeHoach(new ThongTinFileDemKeHoach()
{
MaKeHoach = Program.frm_Map.KeHoach.MaKeHoach,
MaFile = Program.frm_Map.KeHoach.FileDem.MaFile,
});
}
}
}
else
{
if (this.timeEditThoiGianLap.DateTime <= DateTime.Now)
{
if (comboBoxMaBanDo.SelectedItem == null || comboBoxMaFile.SelectedItem == null)
{
DialogResult dialogResult = MessageBox.Show("Bạn chưa chọn bản đồ hoặc kế hoạch ! Bạn có lưu lại luôn không?", "Lưu ý", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
KeHoach keHoach = new KeHoach()
{
MaNguoiLap = Program.lg.UserLogin.MaDangNhapNguoiDung,
TenKeHoach = textEditTenPhuongAn.Text
};
List <ThongTinChiTietDoiTuong> list = new List <ThongTinChiTietDoiTuong>();
for (int i = 0; i < Count.IntVar; i++)
{
list.Add(new ThongTinChiTietDoiTuong()
{
MaKeHoach = keHoach.MaKeHoach,
MaDonVi = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.MaDonVi,
ToaDoX = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ToaDoX,
ToaDoY = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ToaDoY,
ChieuDaiAnh = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuDaiAnh,
ChieuRongAnh = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuRongAnh,
ChieuNgang = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuNgang,
ChieuDoc = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuDoc,
TenDoiTuong = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.TenDoiTuong
});
}
Program.KeHoachSql.ThemKeHoach(keHoach);
Program.frm_Map.KeHoach = keHoach;
Program.ThongTinChiTietDoiTuongSql.AddDoiTuong(list);
MessageBox.Show("Thành Công");
LoadKeHoach();
LoadKeHoachDeTail();
}
else
{
return;
}
}
else
{
KeHoach keHoach = new KeHoach()
{
MaNguoiLap = Program.lg.UserLogin.MaDangNhapNguoiDung,
TenKeHoach = textEditTenPhuongAn.Text
};
Program.KeHoachSql.ThemKeHoach(keHoach);
// Lưu lại bản đồ và file dem
ComboBoxItemBanDo banDo = (ComboBoxItemBanDo)comboBoxMaBanDo.SelectedItem;
keHoach.BanDo = new BanDo()
{
MaBanDo = banDo.MaBanDo,
DuongDanAnh = banDo.DuongDan,
TenBanDo = banDo.TenBanDo
};
Program.ThongTinBanDoKeHoachSql.AddThongTinBanDoKeHoach(new ThongTinBanDoKeHoach()
{
MaKeHoach = keHoach.MaKeHoach,
MaBanDo = keHoach.BanDo.MaBanDo,
});
ComboBoxItemFileDem file = (ComboBoxItemFileDem)comboBoxMaFile.SelectedItem;
keHoach.FileDem = new Dem()
{
MaFile = file.MaFile,
TenFile = file.TenFile,
DuongDan = file.DuongDan
};
Program.ThongTinFileDemKeHoachSql.AddThongTinFileDemKeHoach(new ThongTinFileDemKeHoach()
{
MaKeHoach = keHoach.MaKeHoach,
MaFile = keHoach.FileDem.MaFile,
});
// Thêm các đối tượng
List <ThongTinChiTietDoiTuong> list = new List <ThongTinChiTietDoiTuong>();
for (int i = 0; i < Count.IntVar; i++)
{
list.Add(new ThongTinChiTietDoiTuong()
{
MaKeHoach = keHoach.MaKeHoach,
MaDonVi = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.MaDonVi,
ToaDoX = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ToaDoX,
ToaDoY = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ToaDoY,
ChieuDaiAnh = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuDaiAnh,
ChieuRongAnh = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuRongAnh,
ChieuNgang = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuNgang,
ChieuDoc = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.ChieuDoc,
TenDoiTuong = isChange.DoiTuongs[i].ThongTinChiTietDoiTuong.TenDoiTuong
});
}
Program.ThongTinChiTietDoiTuongSql.AddDoiTuong(list);
Program.frm_Map.KeHoach = keHoach;
MessageBox.Show("Thành Công");
LoadKeHoach();
LoadKeHoachDeTail();
}
}
else
{
MessageBox.Show("Hãy chọn ngày đúng");
return;
}
}
MessageBox.Show("Lưu lại thành công");
Program.frm_Map.listUpdate.Clear();
Program.frm_Map.listAdd.Clear();
Program.frm_Map.listRemove.Clear();
LoadKeHoach();
}
public void Add(KeHoach Kehoach)
{
db.KeHoaches.Add(Kehoach);
db.SaveChanges();
}
// Load Thong tin ke hoach vao trong cac text box
public void LoadKeHoachDeTail(KeHoach keHoach)
{
textEditTenPhuongAn.Text = keHoach.TenKeHoach;
timeEditThoiGianLap.DateTime = keHoach.ThoiGianTao;
if (keHoach.BanDo != null)
{
foreach (ComboBoxItemBanDo comboBoxItemBanDo in comboBoxMaBanDo.Items)
{
if (comboBoxItemBanDo.MaBanDo == keHoach.BanDo.MaBanDo)
{
comboBoxMaBanDo.SelectedItem = comboBoxItemBanDo;
}
}
}
else
{
comboBoxMaBanDo.SelectedIndex = -1;
comboBoxTenBanDo.SelectedIndex = -1;
}
if (keHoach.FileDem != null)
{
foreach (ComboBoxItemFileDem comboBoxItemFileDem in comboBoxMaFile.Items)
{
if (comboBoxItemFileDem.MaFile == keHoach.FileDem.MaFile)
{
comboBoxMaFile.SelectedItem = comboBoxItemFileDem;
}
}
}
else
{
comboBoxMaFile.SelectedIndex = -1;
comboBoxTenFile.SelectedIndex = -1;
}
if (keHoach.ThamSoDauVao != null)
{
foreach (ComboBoxThamSoDauVao comboBoxThamSoDauVao in comboBoxIdThamSoDauVao.Items)
{
if (comboBoxThamSoDauVao.MaThamSo == keHoach.ThamSoDauVao.Mathamso)
{
comboBoxIdThamSoDauVao.SelectedItem = comboBoxThamSoDauVao;
}
}
}
else
{
comboBoxIdThamSoDauVao.SelectedIndex = -1;
comboBoxIdThamSoDauVao.SelectedIndex = -1;
}
//if (keHoach.idThamSo != 0)
// foreach (ComboBoxThamSoDauVao comboBoxThamSoDauVao in comboBoxIdThamSoDauVao.Items)
// {
// if (comboBoxThamSoDauVao.MaThamSo == keHoach.idThamSo)
// {
// comboBoxIdThamSoDauVao.SelectedItem = comboBoxThamSoDauVao;
// }
// }
//else
//{
// comboBoxIdThamSoDauVao.SelectedIndex = -1;
// comboBoxIdThamSoDauVao.SelectedIndex = -1;
//}
}
