public static void InsertAttendance(attendance attendId)
{
using (ASMDataContext context = new ASMDataContext())
{
context.attendances.InsertOnSubmit(attendId);
context.SubmitChanges();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int attendId = 0;
int.TryParse(AttendIdHiddenField.Value, out attendId);
DA.attendance obj = new DataAccess.attendance();
string status, remarks;
obj.adate = Convert.ToDateTime(lblToday.Text);
obj.weekno = Int32.Parse(lblWeekno.Text);
obj.period = Int32.Parse(lblPeriod.Text);
obj.fcode = Session["fcode"].ToString();
RadioButton rb;
foreach (GridViewRow r in GridView1.Rows)
{
remarks = "";
status = "l";
rb = (RadioButton)r.FindControl("rbPresent");
if (rb.Checked)
{
status = "p";
}
else
{
rb = (RadioButton)r.FindControl("rbAbsent");
if (rb.Checked)
{
status = "a";
}
else
{
TextBox t = (TextBox)r.FindControl("txtRemarks");
remarks = t.Text;
}
}
obj.admno = Int32.Parse(r.Cells[0].Text);
obj.status = Convert.ToChar(status);
obj.remarks = remarks;
DA.Manager.InsertAttendance(obj);
}
Response.Redirect(String.Format("attendance.aspx?AttendId={0}&weekno={1}&semister={2}", obj.admno, obj.weekno, obj.Id));
}
public static void UpdateAttendance(attendance attendId)
{
using (ASMDataContext context = new ASMDataContext())
{
var dbStudent = context.attendances.SingleOrDefault(x => x.admno == attendId.admno);
if (dbStudent != null)
{
dbStudent.admno = attendId.admno;
dbStudent.period = attendId.period;
dbStudent.weekno = attendId.weekno;
context.SubmitChanges();
}
}
}
partial void Deleteattendance(attendance instance);
partial void Updateattendance(attendance instance);
partial void Insertattendance(attendance instance);
