static void Main(string[] args)
{
ThoiGian time = new ThoiGian();
time.inputtime();
time.Formattime(time);
Console.WriteLine("Thoi gian hien tai la: ");
time.outputtime();
Console.WriteLine("Nhap vao so ngay muon them vao thoi gian hien tai: ");
int day = Convert.ToInt32(Console.ReadLine());
time.AddDay(day);
time.outputtime();
Console.WriteLine("Nhap vao so ngay muon bo di khoi thoi gian hien tai: ");
int day2 = Convert.ToInt32(Console.ReadLine());
time.SubDay(day);
time.outputtime();
Console.WriteLine("Nhap vao so thang muon them vao thoi gian hien tai: ");
int thang = Convert.ToInt32(Console.ReadLine());
time.AddMonth(thang);
time.outputtime();
Console.WriteLine("Nhap vao so thang muon bo di khoi thoi gian hien tai: ");
int thang2 = Convert.ToInt32(Console.ReadLine());
time.AddMonth(thang2);
time.outputtime();
}
public bool ThoiGian_Select(BacSi bacSi, ThoiGian thoiGian)
{
string query = "ThoiGian_Select N'" + bacSi.TenBS + "' , '" + thoiGian.NgayKham + "' , '" + thoiGian.Time + "'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
return(result.Rows.Count > 0);
}
public DatTrongSave(DatTrong dat)
{
DiaChi = dat.getDiaChi();
Tree.CODE = dat.GetCODE();
ThoiGianBatDauTrong = new ThoiGian(dat.getThoiGianTrong());
TrangThai = dat.getTrangThai();
}
static void Main()
{
System.DateTime currentTime = System.DateTime.Now;
ThoiGian t = new ThoiGian(currentTime);
t.ThoiGianHienHanh();
}
private void cbLichKham_SelectedValueChanged(object sender, EventArgs e)
{
flpTime.Controls.Clear();
BacSi bacSi = new BacSi(-1, lbTenBS.Text, "", -1, -1, -1, "");
string[] formats = { "dd/MM/yyyy", "dd-MMM-yyyy", "yyyy-MM-dd",
"dd-MM-yyyy", "M/d/yyyy", "dd MMM yyyy" };
string converted = DateTime.ParseExact(cbLichKham.Text, formats, CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("MM/dd/yyyy");
ThoiGian thoiGian = new ThoiGian(-1, "", converted, -1);
List <ThoiGian> ListThoiGian = Bacsi.ViewTime(bacSi, thoiGian);
foreach (ThoiGian item in ListThoiGian)
{
Button btn = new Button()
{
Width = BacSiDAO.TimeWight, Height = BacSiDAO.TimeHight
};
btn.Text = item.Time;
btn.BackColor = Color.Green;
flpTime.Controls.Add(btn);
btn.Click += (object sender1, EventArgs ee) =>
{
frmDatLich datLich = new frmDatLich(lbTenBS.Text, item.Time, cbLichKham.Text);
datLich.ShowDialog();
};
}
}
public void ListChecked()
{
foreach (string s in clbSang.CheckedItems)
{
BacSi bacSi = new BacSi(-1, lbTenBS.Text, "", -1, -1, -1, "");
ThoiGian thoiGian = new ThoiGian(-1, s, dtgNgayKham.Value.ToString("MM/dd/yyyy"), -1);
BacSi.ThoiGian_Insert(bacSi, thoiGian);
}
}
public static void TinhCong_HangNgay(cNgayCong ngayCong, TimeSpan startNT, TimeSpan endddNT,
out ThoiGian TG, out PhuCap PhuCaps, out float TongCong, out float TongNgayLV, out bool QuaDem)
{
TG = new ThoiGian();
PhuCaps = new PhuCap();
TongCong = 0f;
TongNgayLV = 0f; //ver4.0.0.1
QuaDem = false;
}
private void LoadTuyenDiTuyenDen()
{
DropDownListTuyenDiTuyenDen.DataValueField = "MaTuyen";
DropDownListTuyenDiTuyenDen.DataTextField = "BenDiBenDen";
DropDownListTuyenDiTuyenDen.DataSource = TuyenDi.ListTuyenDi();
DropDownListTuyenDiTuyenDen.DataBind();
//
DropDownListLoaiXe.DataValueField = "MaXe";
DropDownListLoaiXe.DataTextField = "KieuiXe";
DropDownListLoaiXe.DataSource = LoaiXe.LoaiXe_DropDownList();
DropDownListLoaiXe.DataBind();
//
DropDownListThoiGian.DataValueField = "MaTG";
DropDownListThoiGian.DataTextField = "GioXuatBen";
DropDownListThoiGian.DataSource = ThoiGian.ThoiGian_DropDownList();
DropDownListThoiGian.DataBind();
//
string stringId = Request.QueryString["Id"] ?? "";
if (stringId != "")
{
//Lay ve xe theo ID
VeXe data = VeXe.VeXe_Single(stringId);
if (data == null)
{
Response.Redirect("~/Datve.aspx");
}
//Dua du lieu vao fomr de cap nhat
lbMaVe.Text = data.MaVe.ToString();
txtHoVaTen.Text = data.HoTen;
//string gt = "";
if (data.GioiTinh == "Nam")
{
RadioButtonNam.Checked = true;
}
else
{
RadioButtonNu.Checked = true;
}
//gt = data.GioiTinh;
txtTuoi.Text = data.Tuoi.ToString();
txtDiaChi.Text = data.DiaChi;
txtSoDT.Text = data.SoDT;
txtNgayThangXuatBen.Text = data.NgayXuatBen.ToShortDateString();
CheckBoxTrangThaiVeXe.Checked = data.TrangThaiVeXe;
DropDownListThoiGian.SelectedValue = data.MaTG.ToString();
DropDownListTuyenDiTuyenDen.SelectedValue = data.MaTuyen.ToString();
DropDownListLoaiXe.SelectedValue = data.MaXe.ToString();
lbUsername.Text = data.MaTKKH;
}
}
//public DataTable ViewBS()
//{
// string query = "BacSi_Select";
// DataTable result = DataProvider.Instance.ExecuteQuery(query);
// return result;
//}
public List <ThoiGian> ViewTime(BacSi bacSi, ThoiGian thoiGian)
{
List <ThoiGian> ListThoiGian = new List <ThoiGian>();
string query = "ThongTinDatPhong N'" + bacSi.TenBS + "' , '" + thoiGian.NgayKham + "'";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in result.Rows)
{
ThoiGian thoigian = new ThoiGian(item);
ListThoiGian.Add(thoigian);
}
return(ListThoiGian);
}
public void setStart(DatTrongSave dat)
{
if (dat.Tree.CODE != "")
{
Tree = GetCayTrongbyCODE(Data.Trees, dat.Tree.CODE);
}
TrangThai = dat.TrangThai;
DiaChi = dat.DiaChi;
ThoiGian a = dat.ThoiGianBatDauTrong;
ThoiGianTrong = new DateTime(a.Nam, a.Thang, a.Ngay, a.Gio, a.Phut, a.Giay);
StartGame();
}
IEnumerator LoadObject()
{
model = GameObject.FindGameObjectWithTag("Model");
manHinh = model.GetComponent <ManHinh>();
manHinh.loadingScreen.SetActive(true);
yield return(new WaitForEndOfFrame());
menu = model.GetComponent <Menu>();
yield return(new WaitForSeconds(0.1f));
eve = model.GetComponent <Event>();
eve.textNum = 0;
menu.menuList.SetActive(false);
yield return(new WaitForSeconds(0.1f));
backGround = model.GetComponent <BackGround>();
yield return(new WaitForSeconds(0.1f));
tg = model.GetComponent <ThoiGian>();
tg.dayNow = DateTime.Now.Day;
tg.dayPrev = tg.dayNow - 1;
yield return(new WaitForSeconds(0.1f));
if (!thPlay)
{
calendar = GameObject.FindGameObjectWithTag("Calendar").GetComponent <CalendarController>();
yield return(new WaitForSeconds(0.1f));
GetSelectedDayInCal();
}
music = GameObject.FindGameObjectWithTag("Music").GetComponent <Music>();
yield return(new WaitForSeconds(0.1f));
sound = model.GetComponent <AudioSource>();
music.musicSound = GameObject.FindGameObjectWithTag("Music").GetComponent <AudioSource>();
yield return(new WaitForSeconds(0.1f));
if (!thPlay)
{
ThayDoiNhacNen(music.normalMusic);
}
yield return(new WaitForSeconds(0.1f));
stat = model.GetComponent <PlayerStat>();
stat.LoadStat(PlayerPrefs.GetInt("idTKCurrent"));
gameObject.GetComponent <EventController>().LoadCotTruyen();
yield return(new WaitForSeconds(0.1f));
loadComplete = true;
manHinh.loadingScreen.SetActive(false);
}
private void LoadControl()
{
//
DropDownListLoaiXe.DataValueField = "MaXe";
DropDownListLoaiXe.DataTextField = "KieuiXe";
DropDownListLoaiXe.DataSource = LoaiXe.LoaiXe_DropDownList();
DropDownListLoaiXe.DataBind();
//
DropDownListThoiGian.DataValueField = "MaTG";
DropDownListThoiGian.DataTextField = "GioXuatBen";
DropDownListThoiGian.DataSource = ThoiGian.ThoiGian_DropDownList();
DropDownListThoiGian.DataBind();
//
string stringID = Request.QueryString["Id"] ?? "";
if (stringID != "")
{
TuyenDi data = TuyenDi.TuyenDi_Single(stringID);
if (data == null)
{
Response.Redirect("~/Admin/TuyenDi.aspx");
}
lbMaTuyen.Text = data.MaTuyen.ToString();
txtBenDiBenDen.Text = data.BenDiBenDen;
DropDownListThoiGian.SelectedValue = data.MaTG.ToString();
DropDownListLoaiXe.SelectedValue = data.MaXe.ToString();
txtGiaVe.Text = data.GiaVe.ToString();
txtSoGheDat.Text = data.SoGheDat.ToString();
txtPhuThu.Text = data.PhuThu;
btReset.Visible = false;
}
else
{
btReset.Visible = true;
}
}
/// <summary>
/// Cập nhật dữ liệu tạm vào bản DIEMDANH ----- Bien tuan = tuan + 1
/// </summary>
private void UpdateDataToDiemDanh(String Mahocphan, int tuan)
{
TrangThaiTuanHoc TrangThai = TrangThaiTuanHocDAO.Instance.getTrangThaiTuanHocByMaHocPhan(Mahocphan);
if (TrangThai.CheckDiemDanh <= 0)
{
//Kiem tra ngay hom nay da diem danh hay chua
if (tuan < 18)
{
//Doi tuong luu gia tri so lan hoc va so lan vang phep
DiemDanh TableDD;
DataTable dt = new DataTable();
try
{
// check: kiem tuan hoc de cap nhat tuan hoc
int check = 0;
// lay tat ca cac dong du lieu voi ma hoc phan tuong ung
dt = TempDiemDanhDAO.Instance.getTableTEMPDIEMDANHByMaHocPhan(Mahocphan);
if (dt.Rows.Count > 0)
{
// quet qua tung dong de luu du lieu vao bang diemdanh
foreach (DataRow row in dt.Rows)
{
//Update = new ImportData(row);
TableDD = DiemDanhDAO.Instance.getTableDIEMDANHByIdMaHocPhan(row["MASINHVIEN"].ToString(), Mahocphan);
//Kiểm tra nếu có dũ liệu trong GhiChu và ThoiGian khac rong thì ghi vào
//if (Update.GhiChu == "" && Update.ThoiGian.Length > 22)
//{
String ThoiGian;
if (row["TG_VAO"].ToString() != "" && row["TG_RA"].ToString() != "")
{
if (row["TG_VAO"].ToString() == "Quên Thẻ")
{
ThoiGian = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString() + " - " + row["TG_VAO"].ToString();
}
else
{
ThoiGian = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString() + " - " + row["TG_VAO"].ToString() + " - " + row["TG_RA"].ToString();
}
//Quên thẻ rơi vào trường hợp này
//goi cau lenh update thoi gian hoc vao cho nay
String sql = @"update DIEMDANH set TUAN_" + tuan + "=N'" + ThoiGian.ToString() + "', SOBUOIHOC ='" + (TableDD.SoBuoiHoc + 1).ToString() + "'" + " WHERE MASINHVIEN = '" + row["MASINHVIEN"] + "' AND MAHOCPHAN ='" + Mahocphan + "'";
if (DataProvider.Instance.ExcuteNonQuery(sql) > 0)
{
check = check + 1;
ShowMessageResult("Đã Lưu " + row["MASINHVIEN"].ToString(), 1);
}
}
//kiem tra neu ghi chu khac rong = sinh vien nghi co phep -> cap nhat so buoi phep
if (row["GHICHU"].ToString() != "")
{
//goi cau lenh cap nhat so buoi nghi co phep
ThoiGian = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString() + " - " + row["GHICHU"].ToString();
String sql = @"update DIEMDANH set TUAN_" + tuan + "=N'" + ThoiGian.ToString() + "', SOBUOIPHEP ='" + (TableDD.SoBuoiPhep + 1).ToString() + "'" + " WHERE MASINHVIEN = '" + row["MASINHVIEN"].ToString() + "' AND MAHOCPHAN ='" + Mahocphan + "'";
if (DataProvider.Instance.ExcuteNonQuery(sql) > 0)
{
check = check + 1;
ShowMessageResult("Đã Lưu " + row["MASINHVIEN"].ToString(), 1);
}
}
//Kiểm tra Thoigian va ghichu
if (row["GHICHU"].ToString() == "" && row["TG_RA"].ToString() == "")
{
ThoiGian = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString() + " - " + row["TG_VAO"].ToString();
String sql = @"update DIEMDANH set TUAN_" + tuan + "='" + ThoiGian.ToString() + "'" + " WHERE MASINHVIEN = '" + row["MASINHVIEN"].ToString() + "' AND MAHOCPHAN ='" + Mahocphan + "'";
if (DataProvider.Instance.ExcuteNonQuery(sql) > 0)
{
check = check + 1;
ShowMessageResult("Đã Lưu " + row["MASINHVIEN"].ToString(), 2);
}
}
}
if (check > 0)
{
ShowMessageResult("Số Sinh Viên Đến Lớp Hôm Nay: " + check.ToString(), 1);
//Cap Nhat Trang thai tuan da hoc
String sql = @"update TrangThaiTuanHoc set TrangThai ='" + (TrangThai.Trangthai + 1).ToString() + "' where MaHocPhan ='" + Mahocphan + "'";
//Cap Nhat so tuan da hoc
TrangThaiTuanHocDAO.Instance.UpdateTrangThaiTuanHoc(Mahocphan, (TrangThai.Trangthai + 1));
//Cap nhat trang thai checkdiemdanh
TrangThaiTuanHocDAO.Instance.UpdateCheckDiemDanh(Mahocphan);
}
}
else
{
ShowMessageResult("Không có dữ liệu để lưu", 0);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Số tuần đã vượt quá giới hạn, không thể ghi thêm!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Hôm Nay Bạn đã điểm danh! và không thể tiếp tục", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool ThoiGian_Insert(BacSi bacSi, ThoiGian thoiGian)
{
return(Bacsi.ThoiGian_Select(bacSi, thoiGian));
}
//public DataTable ViewBS()
//{
// return Bacsi.ViewBS();
//}
public List <ThoiGian> ViewTime(BacSi bacSi, ThoiGian thoiGian)
{
return(Bacsi.ViewTime(bacSi, thoiGian));
}
