private void Login_Button_Click(object sender, EventArgs e)
{
if (OldPassword_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Old Password Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
OldPassword_tb.Focus();
}
else if (NewPassword_tb.Text.Equals(string.Empty))
{
MessageBox.Show("New Password Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
NewPassword_tb.Focus();
}
else if (!NewPassword_tb.Text.Equals(ConfirmPassword_tb.Text))
{
MessageBox.Show("Confirm Password Is Invalid", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
ConfirmPassword_tb.Focus();
}
else
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
con.Execute("Update dbo.StaffRegistration Set Password = @Password Where Email = @Email", new
{
@Password = NewPassword_tb.Text,
@Email = Session.Email
});
MessageBox.Show("Password Changed Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
};
}
}
private void Login_Button_Click(object sender, EventArgs e)
{
if (Email_tb.Text.Equals(string.Empty))
{
MessageBox.Show(" Email Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (Password_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Password Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
var user = con.Query <StaffRegistration>("Select * from dbo.StaffRegistration Where Email = @Email", new
{
@Email = Email_tb.Text
}).FirstOrDefault();
if (user != null)
{
if (user.Password.Equals(Password_tb.Text))
{
Session.FullName = user.FirstName + " " + user.MiddleName + " " + user.LastName;
Session.Email = user.Email;
Session.Faculty = user.Faculty;
Session.PhoneNo = user.PhoneNo;
Session.LoginDateTime = DateTime.Now;
this.Hide();
MDIParent1 mDIParent1 = new MDIParent1();
mDIParent1.ShowDialog();
}
else
{
MessageBox.Show("Invalid Email or Password.", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
Email_tb.Focus();
}
}
else
{
MessageBox.Show("Invalid Email or Password.", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
Email_tb.Focus();
}
}
}
}
protected void BindData()
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
var lst = con.Query <FeeColumns>(@"Select * From FeeColumns Where Class = @Class", new { @Class = Class_cb.Text }).ToList();
con.Close();
dataGridView1.AutoGenerateColumns = false;
dataGridView1.Columns["Id"].DataPropertyName = "Id";
dataGridView1.Columns["FeeColumn"].DataPropertyName = "FeeColumn";
dataGridView1.Columns["Rate"].DataPropertyName = "Rate";
dataGridView1.DataSource = lst;
};
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = dataGridView1.CurrentRow;
DataGridViewCell cell = dataGridView1.CurrentCell;
if (cell.Value.Equals("Modify"))
{
DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
var lst = con.Query <FeeColumns>(@"Select * from dbo.FeeColumns Where Id = @Id", new { @Id = dtId.Value }).FirstOrDefault();
con.Close();
lblHiddenId.Text = lst.Id.ToString();
Class_cb.Text = lst.Class;
FeeColumn_tb.Text = lst.FeeColumn;
Rate_tb.Text = lst.Rate.ToString();
}
}
else if (cell.Value.Equals("Delete"))
{
DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
if (DialogResult.Yes == MessageBox.Show("Are you sure to Delete ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
con.Execute("Delete from dbo.FeeColumns Where Id = @Id", new { @Id = dtId.Value });
con.Close();
MessageBox.Show("Data Deleted Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData();
};
}
}
}
protected void BindData()
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
var lst = con.Query <Admission>(@"Select *,FirstName + ' ' + MiddleName + ' ' + LastName as FullName from Admission Where Class = @Class", new { @Class = Class_Cb.Text }).ToList();
con.Close();
dataGridView1.AutoGenerateColumns = false;
dataGridView1.Columns["Id"].DataPropertyName = "Id";
dataGridView1.Columns["FullName"].DataPropertyName = "FullName";
dataGridView1.Columns["AdmissionDate"].DataPropertyName = "AdmissionDate";
dataGridView1.Columns["Class"].DataPropertyName = "Class";
dataGridView1.Columns["FatherName"].DataPropertyName = "FatherName";
dataGridView1.Columns["Email"].DataPropertyName = "Email";
dataGridView1.Columns["Gender"].DataPropertyName = "Gender";
dataGridView1.DataSource = lst;
};
}
protected void BindData()
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
var lst = con.Query <Admission>(@"Select *,FirstName + ' ' + MiddleName + ' ' + LastName as FullName from StaffRegistration ").ToList();
con.Close();
dataGridView1.AutoGenerateColumns = false;
dataGridView1.Columns["Id"].DataPropertyName = "Id";
dataGridView1.Columns["FullName"].DataPropertyName = "FullName";
dataGridView1.Columns["JoinDate"].DataPropertyName = "JoinDate";
dataGridView1.Columns["PhoneNo"].DataPropertyName = "PhoneNo";
dataGridView1.Columns["Faculty"].DataPropertyName = "Faculty";
dataGridView1.Columns["Email"].DataPropertyName = "Email";
dataGridView1.Columns["Gender"].DataPropertyName = "Gender";
dataGridView1.DataSource = lst;
};
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (FeeColumn_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Fee Column Is Required", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (Rate_tb.Text.Equals(string.Empty) || Convert.ToDecimal(Rate_tb.Text) == 0)
{
MessageBox.Show("Fee Rate Is Required", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
if (con.Query <int>("Select 1 from dbo.FeeColumns Where FeeColumn = @FeeColumn", new { @FeeColumn = FeeColumn_tb.Text }).FirstOrDefault() == 1 && lblHiddenId.Text == "0")
{
MessageBox.Show("Fee Column Already Exists.", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (lblHiddenId.Text == "0")
{
con.Execute("Insert Into dbo.FeeColumns (Class, FeeColumn, Rate) Values (@Class, @FeeColumn, @Rate)", new
{
@Class = Class_cb.Text,
@FeeColumn = FeeColumn_tb.Text,
@Rate = Rate_tb.Text
});
}
else
{
con.Execute("Update dbo.FeeColumns Set Class = @Class, FeeColumn = @FeeColumn, Rate = @Rate Where Id = @Id", new
{
@Id = lblHiddenId.Text,
@Class = Class_cb.Text,
@FeeColumn = FeeColumn_tb.Text,
@Rate = Rate_tb.Text
});
}
MessageBox.Show("Fee Rate Saved Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData();
lblHiddenId.Text = "0";
FeeColumn_tb.Text = string.Empty;
Rate_tb.Text = string.Empty;
FeeColumn_tb.Focus();
}
};
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void Save_Btn_Click(object sender, EventArgs e)
{
if (FirstName_Txt.Text.Equals(string.Empty))
{
MessageBox.Show("First Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
FirstName_Txt.Focus();
}
else if (LastName_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Last Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
LastName_tb.Focus();
}
else if (FatherName_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Father Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
FatherName_tb.Focus();
}
else
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
string gender = "";
if (Male_radioButton.Checked)
{
gender = "Male";
}
else if (Female_radioButton.Checked)
{
gender = "Female";
}
else
{
gender = "Other";
}
if (!Directory.Exists(Application.StartupPath + "\\Student"))
{
Directory.CreateDirectory(Application.StartupPath + "\\Student");
}
if (!string.IsNullOrEmpty(Image_Path.Text))
{
pictureBox1.Image.Save(Application.StartupPath + "\\Student\\" + FirstName_Txt.Text + MiddleName_tb.Text + LastName_tb.Text, System.Drawing.Imaging.ImageFormat.Jpeg);
}
if (!lblHiddenId.Text.Equals("0"))
{
con.Execute("Update dbo.Admission Set AdmissionDate = @AdmissionDate, Class = @Class, Section = @Section, FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, FatherName = @FatherName, TemporaryAddress = @TemporaryAddress, PermanentAddress = @PermanentAddress, Email = @Email, PhoneNo = @PhoneNo, DateOfBirth = @DateOfBirth, Gender = @Gender, Image_Path = @Image_Path Where Id = @Id", new
{
@Id = lblHiddenId.Text,
@AdmissionDate = AdmisionDate_dtp.Text,
@Class = Class_Cb.Text,
@Section = Section_cb.Text,
@FirstName = FirstName_Txt.Text,
@MiddleName = MiddleName_tb.Text,
@LastName = LastName_tb.Text,
@FatherName = FatherName_tb.Text,
@TemporaryAddress = TemporaryAddress_tb.Text,
@PermanentAddress = PermanentAddress_textBox.Text,
@Email = EmailAddress_tb.Text,
@PhoneNo = PhoneNumber_tb.Text,
@DateOfBirth = DateOfBirth_dtp.Text,
@Gender = gender,
@Image_Path = Image_Path.Text,
@Ent_User = Session.Email,
@Ent_DateTime = DateTime.Now
});
}
else
{
con.Execute("Insert into dbo.Admission (AdmissionDate, Class, Section, FirstName, MiddleName, LastName, FatherName, TemporaryAddress, PermanentAddress, Email, PhoneNo, DateOfBirth, Gender, Image_Path, Ent_User, Ent_DateTime) Values (@AdmissionDate, @Class, @Section, @FirstName, @MiddleName, @LastName, @FatherName, @TemporaryAddress, @PermanentAddress, @Email, @PhoneNo, @DateOfBirth, @Gender, @Image_Path, @Ent_User, @Ent_DateTime)", new
{
@AdmissionDate = AdmisionDate_dtp.Text,
@Class = Class_Cb.Text,
@Section = Section_cb.Text,
@FirstName = FirstName_Txt.Text,
@MiddleName = MiddleName_tb.Text,
@LastName = LastName_tb.Text,
@FatherName = FatherName_tb.Text,
@TemporaryAddress = TemporaryAddress_tb.Text,
@PermanentAddress = PermanentAddress_textBox.Text,
@Email = EmailAddress_tb.Text,
@PhoneNo = PhoneNumber_tb.Text,
@DateOfBirth = DateOfBirth_dtp.Text,
@Gender = gender,
@Image_Path = Image_Path.Text,
@Ent_User = Session.Email,
@Ent_DateTime = DateTime.Now
});
}
MessageBox.Show("Data Saved Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData();
lblHiddenId.Text = "0";
FirstName_Txt.Text = string.Empty;
MiddleName_tb.Text = string.Empty;
LastName_tb.Text = string.Empty;
Section_cb.Text = string.Empty;
FatherName_tb.Text = string.Empty;
Class_Cb.Text = string.Empty;
TemporaryAddress_tb.Text = string.Empty;
PermanentAddress_textBox.Text = string.Empty;
EmailAddress_tb.Text = string.Empty;
PhoneNumber_tb.Text = string.Empty;
DateOfBirth_dtp.Text = string.Empty;
};
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = dataGridView1.CurrentRow;
DataGridViewCell cell = dataGridView1.CurrentCell;
if (cell.Value.Equals("Modify"))
{
DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
var lst = con.Query <Admission>(@"Select * from dbo.Admission Where Id = @Id", new { @Id = dtId.Value }).FirstOrDefault();
con.Close();
lblHiddenId.Text = lst.Id.ToString();
AdmisionDate_dtp.Value = lst.AdmissionDate;
Class_Cb.Text = lst.Class;
Section_cb.Text = lst.Section;
FirstName_Txt.Text = lst.FirstName;
MiddleName_tb.Text = lst.MiddleName;
LastName_tb.Text = lst.LastName;
FatherName_tb.Text = lst.FatherName;
TemporaryAddress_tb.Text = lst.TemporaryAddress;
PermanentAddress_textBox.Text = lst.PermanentAddress;
EmailAddress_tb.Text = lst.Email;
PhoneNumber_tb.Text = lst.PhoneNo;
DateOfBirth_dtp.Value = lst.DateOfBirth;
Image_Path.Text = lst.Image_Path;
if (lst.Gender.Equals("Male"))
{
Male_radioButton.Checked = true;
}
else if (lst.Gender.Equals("Female"))
{
Female_radioButton.Checked = true;
}
else
{
Other_radioButton.Checked = true;
}
if (!string.IsNullOrEmpty(lst.Image_Path))
{
pictureBox1.Image = new Bitmap(lst.Image_Path);
Image_Path.Text = lst.Image_Path;
}
else
{
pictureBox1.Image = null;
Image_Path.Text = "";
}
}
}
else if (cell.Value.Equals("Delete"))
{
DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
if (DialogResult.Yes == MessageBox.Show("Are you sure to Delete ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
con.Execute("Delete from dbo.Admission Where Id = @Id", new { @Id = dtId.Value });
con.Close();
MessageBox.Show("Data Deleted Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData();
};
}
}
}
private void Save_b_Click(object sender, EventArgs e)
{
if (FirstName_tb.Text.Equals(string.Empty))
{
MessageBox.Show("First Name Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
FirstName_tb.Focus();
}
else if (LastName_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Last Name Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (EmailAddress_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Email Address Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (JoinDate_dtp.Text.Equals(string.Empty))
{
MessageBox.Show("Join Date Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (Password_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Password Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (PhoneNumber_tb.Text.Equals(string.Empty))
{
MessageBox.Show("Phone Number Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (Faculty_cb.Text.Equals(string.Empty))
{
MessageBox.Show("Faculty Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
{
con.Open();
if (con.Query <int>("Select 1 from dbo.StaffRegistration Where Email = @Email", new { @Email = EmailAddress_tb.Text }).FirstOrDefault() == 1 && lblHiddenId.Text == "0")
{
MessageBox.Show("Email Already Exists.", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
string gender = "";
if (Male_rb.Checked)
{
gender = "Male";
}
else if (Female_rb.Checked)
{
gender = "Female";
}
else
{
gender = "Other";
}
if (!Directory.Exists(Application.StartupPath + "\\Staff"))
{
Directory.CreateDirectory(Application.StartupPath + "\\Staff");
}
if (!string.IsNullOrEmpty(Image_Path.Text))
{
pictureBox1.Image.Save(Application.StartupPath + "\\Staff\\" + FirstName_tb.Text + MiddleName_tb.Text + LastName_tb.Text, System.Drawing.Imaging.ImageFormat.Jpeg);
}
if (!lblHiddenId.Text.Equals("0"))
{
con.Execute("Update dbo.StaffRegistration Set FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, Address = @Address, Email = @Email, PhoneNo = @PhoneNo, JoinDate = @JoinDate, Faculty = @Faculty, Gender = @Gender, Password = @Password, Image_Path = @Image_Path Where Id = @Id", new
{
@Id = lblHiddenId.Text,
@FirstName = FirstName_tb.Text,
MiddleName = MiddleName_tb.Text,
LastName = LastName_tb.Text,
Address = Address_tb.Text,
Email = EmailAddress_tb.Text,
PhoneNo = PhoneNumber_tb.Text,
JoinDate = JoinDate_dtp.Value,
Faculty = Faculty_cb.Text,
Password = Password_tb.Text,
@Gender = gender,
@Image_Path = Image_Path.Text,
@Ent_User = Session.Email,
@Ent_DateTime = DateTime.Now
});
}
else
{
con.Execute("Insert into dbo.StaffRegistration (FirstName, MiddleName, LastName, Address, Email, PhoneNo, JoinDate, Faculty, Gender, Password, Image_Path, Ent_User, Ent_DateTime) Values ( @FirstName, @MiddleName, @LastName , @Address , @Email, @PhoneNo, @JoinDate,@Faculty, @Gender,@Password, @Image_Path, @Ent_User, @Ent_DateTime)", new
{
@FirstName = FirstName_tb.Text,
@MiddleName = MiddleName_tb.Text,
@LastName = LastName_tb.Text,
@Address = Address_tb.Text,
@Email = EmailAddress_tb.Text,
@PhoneNo = PhoneNumber_tb.Text,
@JoinDate = JoinDate_dtp.Text,
@Faculty = Faculty_cb.Text,
@Gender = gender,
@Password = Password_tb.Text,
@Image_Path = "",
@Ent_User = Session.Email,
@Ent_DateTime = DateTime.Now
});
}
MessageBox.Show("Data Saved Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
BindData();
lblHiddenId.Text = "0";
FirstName_tb.Text = string.Empty;
MiddleName_tb.Text = string.Empty;
LastName_tb.Text = string.Empty;
Address_tb.Text = string.Empty;
EmailAddress_tb.Text = string.Empty;
PhoneNumber_tb.Text = string.Empty;
JoinDate_dtp.Text = string.Empty;
Password_tb.Text = string.Empty;
}
}
}
}
