private void handding()
{
DataTable data;
User = new User();
ConnectDatabase cnn = new ConnectDatabase();
data = cnn.getdata("select * from tai_khoan, nhan_vien where tai_khoan.id = nhan_vien.id_tKhoan and tai_khoan.t_khoan = '" + txtTaiKhoan.Text + "' and tai_khoan.m_khau='" + txtMatKhau.Text + "'");
foreach (DataRow dr in data.Rows)
{
User.H_ten = dr["h_ten"].ToString();
User.User_type = Int32.Parse(dr["User_type"].ToString());
User.Id_nvien = Int32.Parse(dr["id"].ToString());
}
if (User.H_ten == null)
{
MessageBox.Show("Sai tên tài khoản hoặc mật khẩu");
}
else
{
Home h = new Home();
h.getType(User.H_ten, User.User_type, User.Id_nvien);
h.Show();
this.Visible = false;
}
}
static public MenuEform[] getMenu(string oEmpcode, string oRoleId)
{
string sql = @"SELECT m.Menu_Code, m.Menu_Name, m.Menu_Parent, m.Menu_PageURL, m.Menu_Type,
m.Menu_Order, m.Menu_Status, m.Menu_Seq, ro.Role_All, ru.Role_id
FROM T_Role_User as ru INNER JOIN
T_Role_Object as ro ON ru.Role_id = ro.Role_id INNER JOIN
T_Menu_Mee as m ON ro.Search_header_id = m.Menu_Code where ru.Role_id in (" + oRoleId + ")" +
" and ru.emp_code = '" + oEmpcode + "' and m.Menu_Status = 1 ";
ConnectDatabase fn = new ConnectDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["Myconnect"].ConnectionString);
DataTable dtbMenu = fn.GetDataAdapter(sql);
if (dtbMenu.Rows.Count > 0)
{
List <MenuEform> oMenu = new List <MenuEform>();
foreach (DataRow drv in dtbMenu.Rows)
{
MenuEform menu = new MenuEform(drv["Menu_Code"].ToString(), drv["Menu_Name"].ToString(), drv["Menu_PageURL"].ToString(), drv["Menu_Type"].ToString(),
bool.Parse(drv["Menu_Status"].ToString()), int.Parse(drv["Menu_Parent"].ToString()), int.Parse(drv["Menu_Order"].ToString()),
int.Parse(drv["Menu_Seq"].ToString()));
oMenu.Add(menu);
}
return(oMenu.ToArray());
}
return(null);
}
public FinanceWindow(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
hellotxt.Content = "Hello, " + emp.name;
notifcircle.Visibility = Visibility.Hidden;
notifcount.Visibility = Visibility.Hidden;
listbox.Visibility = Visibility.Hidden;
DataTable dt = new DataTable();
dt = connect.executeQuery("select * from financenotif");
if (dt.Rows.Count > 0)
{
notifcount.Text = dt.Rows.Count.ToString();
notifcount.Visibility = Visibility.Visible;
notifcircle.Visibility = Visibility.Visible;
notifcounts = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow data = dt.Rows[i];
lists.Add(data["type"] + " from " + data["division"] + "\n" + data["amount"]);
}
}
else
{
lists.Add("There is no notification currently!");
}
listbox.ItemsSource = lists;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)(sender);
string maBS = btn.CommandArgument;
ConnectDatabase conn = new ConnectDatabase();
using (SqlConnection myCnn = conn.connectDatabase())
{
SqlCommand cmd = new SqlCommand("delete_lylichbosung", myCnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaBS", maBS);
int rs = cmd.ExecuteNonQuery();
if (rs > 0)
{
Session["type"] = "text-success";
Session["mess"] = "Xoá lý lịch bổ sung thành công";
}
else
{
Session["type"] = "text-danger";
Session["mess"] = "Xoá lý lịch bổ sung không thành công";
}
}
Response.Redirect("BoSungLyLich.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["mabs"] != null)
{
ConnectDatabase conn = new ConnectDatabase();
using (SqlConnection sqlConnection = conn.connectDatabase())
{
SqlCommand cmd = new SqlCommand("layLyLichTheoMaBS", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mabs", Request.QueryString["mabs"].ToString());
SqlDataReader rd = cmd.ExecuteReader();
if (rd.HasRows)
{
while (rd.Read())
{
sTenDeTai.Text = rd["TenDeTaiNC"].ToString();
DateTime dt1 = Convert.ToDateTime(rd["NamBatDau"].ToString());
NamBatDau.Text = dt1.ToString("yyyy-MM-dd");
DateTime dt = Convert.ToDateTime(rd["NamKetThuc"].ToString());
NamKetThuc.Text = dt.ToString("yyyy-MM-dd");
GiaiThuong.Text = rd["GiaiThuong"].ToString();
MaBS.Value = rd["MaBS"].ToString();
}
}
}
}
}
private void label1_Click(object sender, EventArgs e)
{
ConnectDatabase cnn = new ConnectDatabase();
dataGridView1.DataSource = cnn.getdata("select 'Nhân viên nhận phòng' = (select h_ten from nhan_vien where id = hoa_don.id_tKhoan_vao),'Nhân viên trả phòng' = (select h_ten from nhan_vien where id = hoa_don.id_tKhoan_ra),khach_hang.t_khang as 'Khách hàng', 'Giờ vào'=concat(DATEPART(hh, gio_vao),':', DATEPART(mi, gio_vao)), 'Ngày vào'=concat(DATEPART(dd, gio_vao),'/', DATEPART(mm, gio_vao),'/', DATEPART(YY, gio_vao)), 'Giờ ra'=concat(DATEPART(hh, gio_ra),':', DATEPART(mi, gio_ra)), 'Ngày ra'=concat(DATEPART(dd, gio_ra),'/', DATEPART(mm, gio_ra),'/', DATEPART(YY, gio_ra)), phong.t_phong as 'Phòng', t_tien as 'Số tiền' from hoa_don, phong, khach_hang where hoa_don.id_phong = phong.id and hoa_don.cmnd = khach_hang.cmnd order by hoa_don.id desc");
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public HRMViewEmployee(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddata();
}
public ActionResult Index()
{
var item = new List <MyClassViewModels>();
var type = "";
ConnectDatabase db = new ConnectDatabase();
foreach (var i in db.AccountBook.ToList())
{
if (i.Categoryyy == 0)
{
type = "支出";
}
else
{
type = "收入";
}
item.Add(new MyClassViewModels
{
ID = i.Id.ToString(),
類別 = type,
日期 = i.Dateee,
金額 = i.Amounttt,
備註 = i.Remarkkk
});
}
return(View(item));
}
public HRMRecruitmentWindow(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
countposition();
}
public SMViewSchedule(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
initlistview();
}
public SMHandleItems(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
initlistview();
}
public ManagerCheckFireRequest(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddata();
}
private void btIn_Click(object sender, EventArgs e)
{
ConnectDatabase cnn = new ConnectDatabase();
int row = 1;
if (cnn.RepairData("update hoa_don set id_tKhoan_ra = " + hd.Id_tkhoan + ", gio_ra = GETDATE(), t_tien =" + hd.S_tien + " where id=" + hd.Id_hoaDon + ";") != 0)
{
if (cnn.RepairData("update phong set t_thai = 1 where id =" + hd.Id_phong + ";") != 0 && cnn.RepairData("delete from ds_dich_vu where id_phong =" + hd.Id_phong + "") != 0)
{
row = 1;
MessageBox.Show("In hóa đơn thành công");
this.Dispose();
}
else
{
Console.WriteLine("Lỗi phần phòng");
row = 0;
}
}
else
{
Console.WriteLine("Lỗi phần hóa đơn");
row = 0;
}
}
public ManagerTransactionReportTranscript(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
init();
}
public QMGenerateQueue(string action)
{
this.connect = ConnectDatabase.getInstance();
this.action = action;
Guid g = Guid.NewGuid();
string GuidString = Convert.ToBase64String(g.ToByteArray());
GuidString = GuidString.Replace("=", "");
GuidString = GuidString.Replace("+", "");
InitializeComponent();
label.Content = action;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(GuidString, QRCodeGenerator.ECCLevel.H);
XamlQRCode qrCode = new XamlQRCode(qrCodeData);
DrawingImage qrCodeAsXaml = qrCode.GetGraphic(20);
qrcode.Source = qrCodeAsXaml;
if (action.Equals("Teller"))
{
DataTable dt = new DataTable();
dt = connect.executeQuery("select * from queue where division = 'Teller'");
connect.executeUpdate("insert into queue values ('A" + (dt.Rows.Count + 1).ToString() + "', '" + GuidString + "', 'Teller', 'Not Done')");
queueno.Content = 'A' + (dt.Rows.Count + 1).ToString();
}
else
{
DataTable dt = new DataTable();
dt = connect.executeQuery("select * from queue where division = 'Customer Service'");
connect.executeUpdate("insert into queue values ('B" + (dt.Rows.Count + 1).ToString() + "', '" + GuidString + "', 'Customer Service', 'Not Done')");
queueno.Content = 'B' + (dt.Rows.Count + 1).ToString();
}
}
private void LayThongTinNv()
{
if (id_nvien != 0)
{
//Lấy dữ liệu nhân viên đẩy vào các lable
ConnectDatabase conn = new ConnectDatabase();
DataTable dataTable = conn.getdata("select * from tai_khoan, nhan_vien where tai_khoan.id = nhan_vien.id and tai_khoan.id = " + this.id_nvien + "");
if (dataTable.Rows.Count != 0 && dataTable != null)
{
lbTaiKhoan.Text = dataTable.Rows[0]["t_khoan"].ToString();
lbMatKhau.Text = dataTable.Rows[0]["m_khau"].ToString();
lbQuyen.Text = "Nhân viên";
if (dataTable.Rows[0]["user_type"].ToString() == "1")
{
lbQuyen.Text = "Quản lý";
}
lbHoTen.Text = dataTable.Rows[0]["h_ten"].ToString();
lbGioiTinh.Text = "Nam";
if (dataTable.Rows[0]["gioi_tinh"].ToString() == "1")
{
lbGioiTinh.Text = "Nữ";
}
lbQueQuan.Text = dataTable.Rows[0]["q_quan"].ToString();
lbNgayLam.Text = dataTable.Rows[0]["ngay_lam"].ToString();
DateTime date = DateTime.Parse(lbNgayLam.Text);
lbNgayLam.Text = date.ToString("dd/MM/yyyy");
}
}
}
public ManagerExpensesAndRevenueReportTranscript(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddata();
}
protected void SetTextbox_Test(object sender, EventArgs e)
{
ConnectDatabase conn = new ConnectDatabase();
string Item = conn.GetStock().ToUpper();
StockItemTest.Text = Item;
}
public ManagerHandleFiring(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddata();
}
public DataSet layThongTinItem(string idSP, int SL, string idMau)
{
ConnectDatabase con = new ConnectDatabase();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
string sql = @"SELECT SanPhamDT.idSP, SanPhamDT.tenSP, SanPham_Mau_ChiTiet.Gia, SanPham_Mau.TenMau,SanPham_Mau_ChiTiet.Gia*'" + SL + @"' as thanhTien,SanPhamDT.urlHinh, SanPham_Mau_ChiTiet.idMau as mamau
FROM SanPhamDT INNER JOIN
SanPham_Mau_ChiTiet ON SanPhamDT.idSP = SanPham_Mau_ChiTiet.idSP INNER JOIN
SanPham_Mau ON SanPham_Mau_ChiTiet.idMau = SanPham_Mau.idMau
where SanPhamDT.idSP = '" + int.Parse(idSP) + "' and SanPham_Mau.idMau = '" + int.Parse(idMau) + "' ";
SqlConnection conn = new SqlConnection();
conn = con.getConnection();
try{
conn.Open();
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
finally{
conn.Close();
}
return(ds);
}
private void txt_connect_Click(object sender, EventArgs e)
{
try
{
if (cbLoginMode.SelectedIndex + 1 == 1)
{
LoginMode = "WindowsMode";
ConnectDatabase.dbHost = txtHost.Text.Trim();
ConnectDatabase.dbName = txtDBName.Text.Trim();
ConnectDatabase db = new ConnectDatabase();
if (db.conn.State == ConnectionState.Open)
{
this.Hide();
main_form.Show();
}
}
else if (cbLoginMode.SelectedIndex + 1 == 2)
{
LoginMode = "SQLServerMode";
ConnectDatabase.dbHost = txtHost.Text.Trim();
ConnectDatabase.dbName = txtDBName.Text.Trim();
ConnectDatabase.dbUser = txtUserDB.Text.Trim();
ConnectDatabase.dbPassword = txtPassDB.Text.Trim();
ConnectDatabase db = new ConnectDatabase();
if (db.conn.State == ConnectionState.Open)
{
this.Hide();
main_form.Show();
}
}
}
catch (Exception ex) { newMessage.error("Error Exception" + ex.ToString()); }
}
protected void btnxacnhan_Click(object sender, EventArgs e)
{
string tk = txttk.Text;
string mk = txtmk.Text;
string em = txtemail.Text;
string dc = txtdiachi.Text;
string sdt = txtsdt.Text;
string ht = txthoten.Text;
TAIKHOAN us = laydulieu();
ConnectDatabase con = new ConnectDatabase();
TAIKHOAN cc = new TAIKHOAN();
if (mk == "" || em == "" || dc == "" || sdt == "" || ht == "")
{
lbthongbao.Text = "Vui Lòng Nhập Đầy Đủ";
}
else
{
bool kt = con.UpDateTK(us);
if (kt)
{
lbthongbao.Text = "Chỉnh Sửa Thành Công";
}
else
{
lbthongbao.Text = "Chỉnh Sửa Thất Bại";
}
}
}
public bool RequestMoney(int value)
{
ConnectDatabase instance = ConnectDatabase.getInstance();
Console.WriteLine(this.name + " requisita R$" + value);
if (value > maxMoney)
{
if (higher.HasHigher())
{
Console.WriteLine(this.name + " solicita ao superior");
return(higher.RequestMoney(value));
}
else
{
Console.WriteLine(this.name + " nega a grana");
return(false);
}
}
else
{
Console.WriteLine(this.name + " libera a grana");
return(true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
ConnectDatabase con = new ConnectDatabase();
grchitiet.DataSource = con.getTable("select *from QUANLY where TAIKHOAN='" + Session["TAIKHOAN"] + "'");
grchitiet.DataBind();
}
public ManagerViewResignation(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddata();
}
public SMManageItem(Employee emp, Item item)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
this.item = item;
InitializeComponent();
itemnametxt.Content = item.itemname;
}
private void LoadDataTable()
{
cnn = new ConnectDatabase();
DataTable data = cnn.getdata("select tai_khoan.id, t_khoan as N'Tên Tài Khoản', m_khau as N'Mật khẩu', quyen.t_quyen as 'Loại tài khoản', h_ten as N'Họ tên', nhan_vien.gioi_tinh as N'Giới tính', q_quan as N'Quê quán', ngay_lam as N'Ngày làm' from tai_khoan, nhan_vien, quyen where tai_khoan.id = nhan_vien.id_tKhoan and tai_khoan.user_type = quyen.id");
tableDsNhanvien.DataSource = data;
tableDsNhanvien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public TellerRate(Employee emp)
{
this.tq = TellerQueue.getInstance();
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
employeename.Content = emp.name;
}
public ManagerViewReport(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
loaddbdata();
LoadLineChartData();
}
public CSFindCustomerByAccountNum(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
nextbutton.Visibility = Visibility.Hidden;
listbox.Visibility = Visibility.Hidden;
}
