public sms_institute get_sms_institute()
{
sms_institute ins = new sms_institute();
using (MySqlConnection con = new MySqlConnection(ConnectionString.con_string))
{
using (MySqlCommand cmd = new MySqlCommand())
{
cmd.CommandText = "SELECT* FROM sms_institute";
cmd.Connection = con;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
con.Open();
Byte[] institute_logo;
Byte[] male_image;
Byte[] female_image;
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
institute_logo = (byte[])(reader["institute_logo"]);
male_image = (byte[])(reader["male_image"]);
female_image = (byte[])(reader["female_image"]);
ins = new sms_institute()
{
institute_name = Convert.ToString(reader["institute_name"].ToString()),
institute_logo = institute_logo,
male_image = male_image,
female_image = female_image,
mac = Convert.ToString(reader["mac"].ToString()),
isMultiPartSMSAccess = Convert.ToString(reader["isMultiPartSMSAccess"]),
};
}
catch (Exception ex)
{
throw ex;
}
return(ins);
}
}
}
public MainWindow()
{
InitializeComponent();
try
{
ReadDatabaseFile();
insDAL = new InstituteDAL();
empDAL = new EmployeeDAL();
digital_clock();
TabControlMain.SelectedIndex = 0;
ins = insDAL.get_sms_institute();
institute_grid.DataContext = ins;
image_grid.DataContext = ins;
}
catch (Exception ex)
{
error_grid.Visibility = Visibility.Visible;
error_grid.DataContext = ex.Message;
isInitialized = false;
}
}
