public frm_Main()
{
InitializeComponent();
dgv_ContentTermin.RowTemplate.Height = 50;
DataAccessLayer DAL = new DataAccessLayer();
if (frm == null)
{
frm = this;
}
//Properties.Settings.Default.Reset();
try
{
string selectQuery = "select * from tbl_users where userName = '******' and userPass = '******'";
DataTable Dt = new DataTable();
Dt = DAL.fetchData(selectQuery);
if (Dt.Rows.Count == 0)
{
Properties.Settings.Default.Reset();
btn_AddKalender.Enabled = false;
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
// Connect to Database
MySqlConnection mySqlConnection = DAL.myConnection();
try
{
mySqlConnection.Open();
lbl_OnOff.BackColor = Color.Green;
}
catch (Exception ex)
{
//To write log file when some problem hapend with the connection to database
using (StreamWriter w = File.AppendText(Environment.CurrentDirectory + "\\log.txt"))
{
w.WriteLine(DateTime.Now + "-->" + ex.Message);
}
lbl_OnOff.BackColor = Color.Red;
}
//to get Days of current month
int DaysOfMonth = DateTime.DaysInMonth(int.Parse(DateTime.Now.ToString("yyyy")), int.Parse(DateTime.Now.ToString("MM")));
DAL.disconnect(mySqlConnection);
if (string.IsNullOrEmpty(Properties.Settings.Default.userName) && string.IsNullOrEmpty(Properties.Settings.Default.Password))
{
ts_btn_Termin.Enabled = false;
frm_Login frm_Login = new frm_Login();
frm_Login.ShowDialog();
}
else
{
ts_btn_Login.Text = "Abmelden";
ts_btn_Login.Name = "ts_btn_Abmelden";
//ts_btn_Login.Image = Image.FromFile(Environment.CurrentDirectory + "\\icon\\Logout.png");
}
lbl_UserName.Text = "Benutzer: " + Properties.Settings.Default.userName;
//fuctions.cmbGenrator(red, green, blue, cbName, cbTitel);
//TODO: All in one function
try
{
fLP_Kalender.Controls.Clear();
string query = "select * from tbl_kalender where userId = " + Properties.Settings.Default.userId;
DataTable Dt = DAL.fetchData(query);
for (int i = 0; i < Dt.Rows.Count; i++)
{
string kalenderColor = Dt.Rows[i]["color"].ToString();
string[] colorArray = kalenderColor.Split(' ');
red = int.Parse(colorArray[0]);
green = int.Parse(colorArray[1]);
blue = int.Parse(colorArray[2]);
CheckBox cb = new CheckBox();
cb.Name = "cb_" + Dt.Rows[i]["kalenderName"].ToString();
cb.Text = Dt.Rows[i]["kalenderName"].ToString();
cb.BackColor = Color.FromArgb(red, green, blue);
cb.CheckedChanged += Cb_Selected;
cb.MouseHover += Item_MouseHover;
cb.ContextMenuStrip = frm_Main.getMainForm.contextMS_Kalender;
frm_Main.getMainForm.fLP_Kalender.Controls.Add(cb);
}
Dt.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
fLP_SharedCalender.Controls.Clear();
string query = "select k.kalenderName, k.color,u.userName from tbl_kalender as k " +
"inner join tbl_shared as s on k.kalender_Id = s.kalenderId " +
"inner join tbl_users as u on k.userId = u.user_Id " +
"where s.userId = " + Properties.Settings.Default.userId;
DataTable Dt = DAL.fetchData(query);
for (int i = 0; i < Dt.Rows.Count; i++)
{
//TO call the value from Color Columns
string kalenderColor = Dt.Rows[i]["color"].ToString();
string[] colorArray = kalenderColor.Split(' ');
red = int.Parse(colorArray[0]);
green = int.Parse(colorArray[1]);
blue = int.Parse(colorArray[2]);
CheckBox cb = new CheckBox();
cb.Name = "cb_" + Dt.Rows[i]["kalenderName"].ToString();
cb.Text = Dt.Rows[i]["kalenderName"].ToString() + "-(" + Dt.Rows[i]["userName"].ToString() + ")";
cb.BackColor = Color.FromArgb(red, green, blue);
cb.CheckedChanged += Cb_Shared_CheckedChanged;
cb.MouseHover += Item_MouseHover;
//cb.ContextMenuStrip = frm_Main.getMainForm.contextMS_Kalender;
fLP_SharedCalender.Controls.Add(cb);
}
Dt.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private static void Frm_FormClosed(object sender, FormClosedEventArgs e)
{
frm = null;
}