private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand checkExist = new SqlCommand("select count(*) from Student where RegistrationNo=@registrationNo", con);
checkExist.Parameters.AddWithValue("@registrationNo", txtRegNo.Text);
// checkExist.CommandType = System.Data.CommandType.Text;
con.Open();
int asdas = (int)checkExist.ExecuteScalar();
if (txtRegNo.Text == "" || txtFName.Text == "" || txtLName.Text == "" || txtContact.Text == "" || txtEmail.Text == "" || txtGender.Text == "")
{
label8.Visible = true;
label8.Text = "Please fill the Required Field....";
}
else if (txtRegNo.Text.Count() != 11 || txtRegNo.Text.Split('-')[0].Any(char.IsLetter) || txtRegNo.Text[4] != '-' ||
txtRegNo.Text[5] != 'C' || txtRegNo.Text[6] != 'S' || txtRegNo.Text[7] != '-')
{
txtRegNo.Focus();
label8.Visible = true;
label8.Text = "i.e 2016-CS-306";
}
else if (txtContact.Text.Count() != 12 || txtContact.Text[4] != '-' || txtContact.Text.Any(char.IsLetter) == true)
{
label8.Text = "";
txtContact.Focus();
lbContact.Text = "i.e 0123-3456789";
lbContact.ForeColor = Color.Red;
}
else if (isEdit)
{
//if (asdas > 0)
//{
// label8.Visible = true;
// label8.Text = "Registration No already exist";
//}
//else
//{
string update = string.Format("update Person set FirstName='{0}', LastName='{1}', Contact='{2}',Email='{3}',DateOfBirth='{4}', Gender=(select Id from Lookup where Value='{5}') where Id='{6}'", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text, id);
DatabaseConnection.getInstance().executeQuery(update);
string updateStudent = string.Format("update Student set RegistrationNo='{0}' where Id='{1}'", txtRegNo.Text, id);
DatabaseConnection.getInstance().executeQuery(updateStudent);
MessageBox.Show("Data Updated Successfully...");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
//}
}
else if (asdas > 0)
{
label8.Visible = true;
label8.Text = "Registration No already exist";
con.Close();
}
else
{
try
{
string countMaxId = string.Format("select max(Id) from Person");
var re = DatabaseConnection.getInstance().readData(countMaxId);
int count = 0;
while (re.Read())
{
count = re.GetInt32(0);
}
string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
DatabaseConnection.getInstance().executeQuery(query);
string qwrt = "insert into Student(Id, RegistrationNo) values('" + (count + 1) + "','" + txtRegNo.Text + "')";
DatabaseConnection.getInstance().executeQuery(qwrt);
MessageBox.Show("Data Inserted Successfully!");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
}
catch
{
int count = 1;
string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
DatabaseConnection.getInstance().executeQuery(query);
string qwrt = "insert into Student(Id, RegistrationNo) values('" + count + "','" + txtRegNo.Text + "')";
DatabaseConnection.getInstance().executeQuery(qwrt);
MessageBox.Show("Data Inserted Successfully!");
txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
Manage_Student ms = new Manage_Student();
this.Hide();
ms.Show();
}
}
}
private void Person_FormClosed(object sender, FormClosedEventArgs e)
{
DatabaseConnection.getInstance().closeConnection();
}
public grp()
{
InitializeComponent();
DatabaseConnection.getInstance().ConnectionString = "Data Source=HIBA\\SQLSERVER;Initial Catalog=ProjectA;Integrated Security=False;User ID=sa;Password=05feb1999;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
}
public Person()
{
InitializeComponent();
DatabaseConnection.getInstance().ConnectionString = "Data Source=TAYYABA-RASHEED;Initial Catalog=ProjectA;User ID=sa;Password=alohamora";
}
private void button1_Click(object sender, EventArgs e)
{
int asdas = 0;
SqlConnection con = new SqlConnection(conStr);
try
{
SqlCommand checkExist = new SqlCommand("select count(*) from GroupEvaluation where GroupId=(select Id from Group1 where Id=@title) AND EvaluationId=(select Id from Evaluation where Name=@groupId)", con);
checkExist.Parameters.AddWithValue("@title", comGroupId.Text);
checkExist.CommandType = System.Data.CommandType.Text;
checkExist.Parameters.AddWithValue("@groupId", comEvaluationId.Text);
con.Open();
asdas = (int)checkExist.ExecuteScalar();
}
catch
{
label4.Text = "Already Exists";
}
string date = DateTime.Now.ToShortDateString();
string query1 = "select TotalMarks from Evaluation";
var totalMarks = DatabaseConnection.getInstance().getRowsCount(query1);
if (isEdit)
{
try
{
string query = string.Format("update GroupEvaluation set GroupId='{0}', EvaluationId=(select Id from Evaluation where Name='{1}'), ObtainedMarks='{2}', EvaluationDate='{3}' where GroupId='{4}'", int.Parse(comGroupId.Text), comEvaluationId.Text, int.Parse(textBox3.Text), date, int.Parse(grpId));
DatabaseConnection.getInstance().executeQuery(query);
MessageBox.Show("Data updated Successfully!");
dataGridView1 = null;
this.groupEvaluationTableAdapter.Fill(this.projectADataSet7.GroupEvaluation);
isEdit = false;
comGroupId.Text = ""; comEvaluationId.Text = ""; textBox3.Text = "";
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
else if (comGroupId.Text == "" || comEvaluationId.Text == "" || textBox3.Text == "")
{
label4.Text = "Please Fill Required Field!";
}
else if (textBox3.Text.Any(char.IsLetter) == true)
{
textBox3.Focus();
label4.Text = "Integer Value!";
}
else if (asdas > 0)
{
comGroupId.Focus();
label4.Text = "Group Already Exists";
con.Close();
}
else if (totalMarks < int.Parse(textBox3.Text))
{
textBox3.Focus();
label4.Text = "Obtained Marks should be Less than Total Marks";
}
else
{
try
{
string query = string.Format("insert into GroupEvaluation values('{0}',(select Id from Evaluation where Name='{1}'),'{2}','{3}')", int.Parse(comGroupId.Text), comEvaluationId.Text, int.Parse(textBox3.Text), date);
DatabaseConnection.getInstance().executeQuery(query);
MessageBox.Show("Data Inserted Successfully!");
dataGridView1 = null;
this.groupEvaluationTableAdapter.Fill(this.projectADataSet7.GroupEvaluation);
comGroupId.Text = ""; comEvaluationId.Text = ""; textBox3.Text = "";
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}