public static ChiNhanh getChinhanh(string macn) { ChiNhanh chinhanh = null; SqlConnection con = Connector.GetConnection(); string sql = "SELECT * FROM CHINHANH WHERE MACN = '" + macn + "'"; try { SqlCommand sqlCommand = new SqlCommand(sql, con); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); if (dataTable.Rows.Count != 0) { chinhanh = new ChiNhanh(); chinhanh.Macn = dataTable.Rows[0][0].ToString(); chinhanh.Chinhanh = dataTable.Rows[0][1].ToString(); chinhanh.Diachi = dataTable.Rows[0][2].ToString(); chinhanh.Sodt = dataTable.Rows[0][3].ToString(); } } catch (Exception) { // } finally { Connector.CloseConnection(con); } return(chinhanh); }
public static void doLogin() { string sql = "exec SP_DANG_NHAP '" + Login.LgName + "'"; SqlConnection con = Connector.GetConnection(); SqlCommand sqlCommand = new SqlCommand(sql, con); SqlDataAdapter data = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); data.Fill(dataTable); Login.Username = Int32.Parse(dataTable.Rows[0][0].ToString()); Login.Role = dataTable.Rows[0][2].ToString(); Program.NHAN_VIEN = NhanVien.getThongtinNhanvien(Login.Username); Program.CHI_NHANH = ChiNhanh.getChinhanh(Program.NHAN_VIEN.Macn); }