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);
}
