private void button2_Click(object sender, EventArgs e)
{
if (this.BackColor == Color.White)
{
LightMood();
}
else if (this.BackColor == Color.Black)
{
DarkMood();
}
Name = textBox1.Text;
Address = textBox2.Text; Email = textBox3.Text;
Phone = textBox4.Text; NID = textBox5.Text;
Montly_Sal = numericUpDown1.Text;
Position = comboBox1.Text; Workking_Status = groupBox5.Text;
Birthday = dateTimePicker1.Text;
bool isValid = IsEMailAddrValid(Email);
if (radioButton1.Checked)
{
Married_Status = "Married";
}
else if (radioButton2.Checked)
{
Married_Status = "Unmarried";
}
else
{
Married_Status = "";
}
if (radioButton4.Checked)
{
Gander = "Male";
}
else if (radioButton3.Checked)
{
Gander = "Female";
}
else
{
Gander = "";
}
if (radioButton6.Checked)
{
Working_Time = "Fulltime"; Shift = "Full";
}
else if (radioButton5.Checked)
{
Working_Time = "Halftime";
}
else
{
Working_Time = "";
}
if (radioButton8.Checked)
{
Shift = "Day";
}
else if (radioButton7.Checked)
{
Shift = "Night";
}
else
{
Shift = "";
}
if (radioButton10.Checked)
{
Workking_Status = "Not Available";
}
else if (radioButton9.Checked)
{
Workking_Status = "Available";
}
else
{
Workking_Status = "";
}
//label1.ForeColor = Color.Black;
//label2.ForeColor = Color.Black;
//label3.ForeColor = Color.Black;
//label4.ForeColor = Color.Black;
//label5.ForeColor = Color.Black;
//label6.ForeColor = Color.Black;
//label7.ForeColor = Color.Black;
//label8.ForeColor = Color.Black;
//label10.ForeColor = Color.Black;
void emptyTextBox()
{
MessageBox.Show("All TaxBox is not Fillup or Any thing Wrong!", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
try
{
FileStream stream = new FileStream(imgLocation, FileMode.Open, FileAccess.Read);
BinaryReader brs = new BinaryReader(stream);
Photo = brs.ReadBytes((int)stream.Length);
}
catch
{
Photo = null;
}
if (Name.Equals(""))
{
label1.ForeColor = Color.Red; emptyTextBox();
}
else if (Address.Equals(""))
{
label2.ForeColor = Color.Red; emptyTextBox();
}
else if (Email.Equals("") || isValid == false)
{
label3.ForeColor = Color.Red; emptyTextBox(); label17.Show();
}
else if (Phone.Equals(""))
{
label4.ForeColor = Color.Red; emptyTextBox();
}
else if (NID.Equals("") || NID.Length != 12)
{
label5.ForeColor = Color.Red; emptyTextBox(); if (NID.Length != 12)
{
label15.Show();
}
else
{
label15.Hide();
}
}
else if (Married_Status.Equals(""))
{
label6.ForeColor = Color.Red; emptyTextBox();
}
else if (Gander.Equals(""))
{
label7.ForeColor = Color.Red; emptyTextBox();
}
else if (Working_Time.Equals(""))
{
label8.ForeColor = Color.Red; emptyTextBox();
}
else if (Montly_Sal.Equals(""))
{
label10.ForeColor = Color.Red; emptyTextBox();
}
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
else if (Photo == null)
{
emptyTextBox();
}
else
{
DialogResult dialog = MessageBox.Show("Do you want to Add This New User?", "Warnning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialog == DialogResult.Yes)
{
// Random rnd = new Random();
// Password = rnd.Next(1000, 5000); ////////////////////////////////////////////////////////////////////////
Password = RandomPass();
//Photo = null;
SqlCommand insert = new SqlCommand("insert into AllUser(Password,Name,NID,Address,Email,Phone,Married_Status,Gander,Working_Time,Montly_Sal,Position,Workking_Status,Shift,Photo,Birthday)" +
"" +
" values(@Password,@Name,@NID,@Address,@Email,@Phone,@Married_Status,@Gander,@Working_Time,@Montly_Sal,@Position,@Workking_Status,@Shift,@Photo,@Birthday)");
insert.Parameters.AddWithValue("@Password", @Password);
insert.Parameters.AddWithValue("@Name", Name);
insert.Parameters.AddWithValue("@NID", NID);
insert.Parameters.AddWithValue("@Address", Address);
insert.Parameters.AddWithValue("@Email", Email);
insert.Parameters.AddWithValue("@Phone", Phone);
insert.Parameters.AddWithValue("@Married_Status", Married_Status);
insert.Parameters.AddWithValue("@Gander", Gander);
insert.Parameters.AddWithValue("@Working_Time", Working_Time);
insert.Parameters.AddWithValue("@Montly_Sal", Montly_Sal);
insert.Parameters.AddWithValue("@Position", Position);
insert.Parameters.AddWithValue("@Workking_Status", Workking_Status);
insert.Parameters.AddWithValue("@Shift", Shift);
insert.Parameters.AddWithValue("@Photo", @Photo);
insert.Parameters.AddWithValue("@Birthday", Birthday);
int row = db.executeQuery(insert);
if (row == 1)
{
PrintUserInfo_Form PUF = new PrintUserInfo_Form();
PUF.Show();
}
string Year = DateTime.Now.ToString("yyyy");
DataTable TampTable = new DataTable();
string qurey = "Select * from AllUser Where NID ='" + NID + "'AND Name ='" + Name + "'";
db.readDatathroughAdapter(qurey, TampTable);
string ID;
ID = TampTable.Rows[0]["ID"].ToString();
SqlCommand insert2 = new SqlCommand("insert into SalaryList(ID,Name,Year) values(@ID,@Name,@Year)"); //insert in salary
insert2.Parameters.AddWithValue("@ID", ID);
insert2.Parameters.AddWithValue("@Name", Name);
insert2.Parameters.AddWithValue("@Year", Year);
row = db.executeQuery(insert2);
if (row == 1)
{
MessageBox.Show("Done");
}
}
}
}
private void button2_Click(object sender, EventArgs e) //Update Button
{
if (this.BackColor == Color.White)
{
LightMood();
//DarkMood();
}
else if (this.BackColor == Color.Black)
{
DarkMood();
}
Name = textBox1.Text;
Address = textBox2.Text; Email = textBox3.Text;
Phone = textBox4.Text; NID = textBox5.Text;
Montly_Sal = numericUpDown1.Text;
Position = comboBox1.Text; Workking_Status = groupBox5.Text;
Password = textBox7.Text;
if (radioButton1.Checked)
{
Married_Status = "Married";
}
else if (radioButton2.Checked)
{
Married_Status = "Unmarried";
}
else
{
Married_Status = "";
}
if (radioButton4.Checked)
{
Gander = "Male";
}
else if (radioButton3.Checked)
{
Gander = "Female";
}
else
{
Gander = "";
}
if (radioButton6.Checked)
{
Working_Time = "FullTime"; Shift = "Full";
}
else if (radioButton5.Checked)
{
Working_Time = "HalfTime";
}
else
{
Working_Time = "";
}
if (radioButton8.Checked)
{
Shift = "Day";
}
else if (radioButton7.Checked)
{
Shift = "Night";
}
else
{
Shift = "";
}
if (radioButton10.Checked)
{
Workking_Status = "Not";
}
else if (radioButton9.Checked)
{
Workking_Status = "Avable";
}
else
{
Workking_Status = "";
}
void emptyTextBox()
{
MessageBox.Show("All TaxBox is not Fillup or Any thing Wrong!", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (Name.Equals(""))
{
label1.ForeColor = Color.Red; emptyTextBox();
}
else if (Address.Equals(""))
{
label2.ForeColor = Color.Red; emptyTextBox();
}
else if (Email.Equals(""))
{
label3.ForeColor = Color.Red; emptyTextBox();
}
else if (Phone.Equals(""))
{
label4.ForeColor = Color.Red; emptyTextBox();
}
else if (NID.Equals("") || NID.Length != 12)
{
label5.ForeColor = Color.Red; emptyTextBox(); if (NID.Length != 12)
{
label15.Show();
}
else
{
label15.Hide();
}
}
else if (Married_Status.Equals(""))
{
label6.ForeColor = Color.Red; emptyTextBox();
}
else if (Gander.Equals(""))
{
label7.ForeColor = Color.Red; emptyTextBox();
}
else if (Working_Time.Equals(""))
{
label8.ForeColor = Color.Red; emptyTextBox();
}
else if (Montly_Sal.Equals(""))
{
label10.ForeColor = Color.Red; emptyTextBox();
}
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
//else if (Email.Equals("")) { label3.ForeColor = Color.Red; emptyTextBox(); }
else
{
DialogResult dialog = MessageBox.Show("Do you want to Add This New User?", "Warnning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialog == DialogResult.Yes)
{
try
{
FileStream stream = new FileStream(imgLocation, FileMode.Open, FileAccess.Read);
BinaryReader brs = new BinaryReader(stream);
Photo = brs.ReadBytes((int)stream.Length);
}
catch { }
string query = "Update AllUser SET Password ='******',Name ='" + Name + "',NID ='" + NID + "',Address ='" + Address + "',Email ='" + Email + "', Phone ='" + Phone + "',Married_Status ='" + Married_Status + "',Gander ='" + Gander + "',Working_Time ='" + Working_Time + "',Montly_Sal ='" + Montly_Sal + "',Position ='" + Position + "',Workking_Status ='" + Workking_Status + "',Shift ='" + Shift + "', Photo = @Photo where ID = ' " + textBox6.Text + " ' ";
SqlCommand updateData = new SqlCommand(query);
updateData.Parameters.AddWithValue("@Password", Password);
updateData.Parameters.AddWithValue("@Name", Name);
updateData.Parameters.AddWithValue("@NID", NID);
updateData.Parameters.AddWithValue("@Address", Address);
updateData.Parameters.AddWithValue("@Email", Email);
updateData.Parameters.AddWithValue("@Phone", Phone);
updateData.Parameters.AddWithValue("@Married_Status", Married_Status);
updateData.Parameters.AddWithValue("@Gander", Gander);
updateData.Parameters.AddWithValue("@Working_Time", Working_Time);
updateData.Parameters.AddWithValue("@Montly_Sal", Montly_Sal);
updateData.Parameters.AddWithValue("@Position", Position);
updateData.Parameters.AddWithValue("@Workking_Status", Workking_Status);
updateData.Parameters.AddWithValue("@Shift", Shift);
updateData.Parameters.AddWithValue("@Photo", Photo);
int row = db.executeQuery(updateData);
if (row == 1)
{
MessageBox.Show("Information Updated", "Warnning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}