private void BtnLogin_Click(object sender, EventArgs e)
{
//try
//{
lblNote.Text = "";
string query = "Select * from Users u where u.Username=@username and u.Password=@password";
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand(query, sqlconnect.connect());
cmd.Parameters.AddWithValue("@username", txtUserName.Text);
cmd.Parameters.AddWithValue("@password", txtUserPassword.Text);
SqlDataReader rd = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(rd);
if (dt.Rows.Count != 0)
{
user_name = Convert.ToString(dt.Rows[0]["Name"]);
user_ID = Int32.Parse(Convert.ToString(dt.Rows[0]["ID"]));
sqlconnect.close();
this.Hide();
frmMainPage frmMainPage = new frmMainPage();
frmMainPage.Show();
}
else
{
lblNote.Text = "İstifadəçi adı və ya parolu yalnışdır!";
}
// loggedUsers();
//}
//catch (Exception)
//{
// MessageBox.Show("Sistemdə xəta baş verdi, təkrar cəhd edin");
//}
}
private void timer1_Tick_1(object sender, EventArgs e)
{
this.Hide();
timer1.Enabled = false;
frmMainPage Main_Page = new frmMainPage("login");
Main_Page.Show();
}
public static void Main()
{
Settings.UseNameForInputPlaceholders = true;
var x = new frmMainPage();
x.Show();
}
public static void UpdateActivation(String value, string selectedIndex, frmMainPage mainScreen)
{
try
{
if (value.Equals("True"))
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentDetails set StudentStatus='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == true)
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentBatchDetails set current_status='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "' and studentbatchid=(select max(studentbatchid)" +
" from tblStudentBatchDetails where studentid='" + selectedIndex + "')") == false)
{
SystemLogFile.WriteSystemLog("Seudent Batch Details Deactivation Error", "Student Deactivation");
}
mainScreen.SucessMessageShow("Sucessfully Activated", "INFO");
}
else
{
new frmMessageBox("error", "Activate", "You can not Activate this. Some errors occurred!", false, mainScreen).ShowDialog();
}
}
else
{
clsDatabase_Connection.Get_Table("select * from tblStudentDetails A inner join tblStudentBatchDetails B on A.StudentId=B.studentid where A.StudentId='" + selectedIndex + "'");
if (clsDatabase_Connection.objDataSet.Tables[0].Rows.Count > 1)
{
}
new frmMessageBox("question", "Batches", "Selected Students is studying for more batches, would you like to Deactivate all?", true, mainScreen).ShowDialog();
if (IMS_System.Properties.Settings.Default.MessageBoxResults.Equals("Yes"))
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentDetails set StudentStatus='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == true)
{
if (clsDatabase_Connection.ExecuteQuery("update tblStudentBatchDetails set current_status='" + value +
"',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id +
"',CreatedDate=GETDATE() where StudentId='" + selectedIndex + "'") == false)
{
SystemLogFile.WriteSystemLog("Seudent Batch Details Deactivation Error - FULL", "Student Deactivation");
}
mainScreen.SucessMessageShow("Sucessfully Deactivated", "INFO");
}
else
{
new frmMessageBox("error", "Deactivate", "You can not Deactivate this. Some errors occurred!", false, mainScreen).ShowDialog();
}
}
else /** no need of deactivation **/ } {
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
public frmLogin(frmMainPage MainPage)
{
InitializeComponent();
// clsDatabase_Connection = new clsDatabase_Connection();
// clsLogin = new clsLogin();
MainScreen = MainPage;
this.Width = MainScreen.Width - 20;
pictureBox2.Left = this.Width - pictureBox2.Width - 10;
label7.Left = pictureBox2.Left - label7.Width;
}
private void btnSignIn_Click(object sender, EventArgs e)
{
if (isAdoLogin(txtUseName.Text, txtPassword.Text))
{
frmmainpage = new frmMainPage();
frmmainpage.ShowDialog();
}
else
{
MessageBox.Show("Kullanıcı adı yada Şifre Hatalı");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (txtUserName.Text.ToLower() == "admin" && txtPassword.Text == "12345")
{
this.Hide();
frmMainPage frmMainPage = new frmMainPage();
frmMainPage.Show();
}
else
{
MessageBox.Show("Invalid User", "Validation Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
}
}
private void tmSplash_Tick(object sender, EventArgs e)
{
if (effect)
{
this.Opacity -= 1D; //E Diminui a opacidade do form
}
if (this.Opacity == 0)
{
effect = false;
tmSplash.Enabled = false; //Desliga o Timer
frmMainPage frmMain = new frmMainPage(); //Instancia um form Login
frmMain.Show(); //Mostra o login
this.Hide(); //Oculta o formulario Splash sem tira-lo da memória
}
}
