private void btnDiscard_Click(object sender, EventArgs e)
{
frmAttendenceDetail attendDetail = new frmAttendenceDetail();
attendDetail.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
frmAttendenceDetail ad = new frmAttendenceDetail();
ad.Show();
this.Hide();
}
/// <summary>
/// Save Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
SaveData();
MessageBox.Show("Data has been updated");
frmAttendenceDetail ad = new frmAttendenceDetail();
ad.Show();
this.Hide();
}
private void btnSave_Click(object sender, EventArgs e)
{
String conURL1 = "Data Source = DESKTOP-RPO4Q5R\\PARVEEN; Initial Catalog = ProjectB ; User ID = mohsin; Password = mohsin123; MultipleActiveResultSets = True";
SqlConnection conn1 = new SqlConnection(conURL1);
conn1.Open();
for (int i = 0; i < (dgvAttendence.Rows.Count - 1); i++)
{
string att = (string)dgvAttendence.Rows[i].Cells[2].Value;
MyClass.regno = (int)dgvAttendence.Rows[i].Cells[0].Value;
int j = 0;
if (att == "Present")
{
j = 1;
}
else if (att == "Absent")
{
j = 2;
}
else if (att == "Leave")
{
j = 3;
}
else
{
j = 4;
}
/// Attendence Id
String cmd1 = "SELECT TOP 1 Id FROM ClassAttendance ORDER BY Id DESC";
//SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn);
SqlCommand cmd = new SqlCommand(cmd1, conn1);
SqlDataReader myReader;
myReader = cmd.ExecuteReader();
if (!myReader.Read())
{
MessageBox.Show("NewValue is not found");
return;
}
try
{
MyClass.attd = myReader.GetValue(0).ToString();
cmd.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
/// Student Id
String cmd2 = "Select Student.Id as StudentId From Student Where Student.Id =" + MyClass.regno;
//SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", conn);
SqlCommand cmd02 = new SqlCommand(cmd2, conn1);
SqlDataReader myReader1;
myReader1 = cmd02.ExecuteReader();
if (!myReader1.Read())
{
MessageBox.Show("NewValue is not found");
return;
}
try
{
MyClass.std = myReader1.GetValue(0).ToString();
cmd02.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
String cmd3 = "SET IDENTITY_INSERT StudentAttendance ON insert into StudentAttendance( AttendanceId , StudentId , AttendanceStatus) Values ('" + Convert.ToInt32(MyClass.attd) + "' , '" + Convert.ToInt32(MyClass.std) + "' ,'" + j + "' ) SET IDENTITY_INSERT StudentAttendance OFF";
SqlCommand cmd03 = new SqlCommand(cmd3, conn1);
int n = cmd03.ExecuteNonQuery();
/* String cmd2 = "insert into StudentAttendance StudentId Select Student ('" + Convert.ToDateTime(dateTimePicker1.Text) + "')";
* SqlCommand cmd02 = new SqlCommand(cmd2, conn1);
* cmd02.ExecuteNonQuery();*/
}
MessageBox.Show("Data has been Saved");
conn1.Close();
frmAttendenceDetail attenDetail = new frmAttendenceDetail();
attenDetail.Show();
this.Hide();
}