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);