private int AttendanceInSave(string startDateTime, int memberId) { int AttendanceId; Model.Attendance attendance = new Model.Attendance() { AttendanceTypeId = this.AttendanceTypeId, EventId = Convert.ToInt32(ddlBatch.SelectedValue), MemberId = memberId, InDateTime = Convert.ToDateTime(startDateTime), CreatedBy = 1, }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Attendance = scope.Resolve <IAttendance>(); AttendanceId = Attendance.Attendance_Save(attendance); } if (AttendanceId > 0) { Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Not saved."; } return(AttendanceId); }
private int AttendanceOutSave(DateTime endDateTime, int attendanceId) { int AttendanceId; Model.Attendance attendance = new Model.Attendance() { AttendanceId = attendanceId, OutDateTime = endDateTime, CreatedBy = 1, }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Attendance = scope.Resolve <IAttendance>(); AttendanceId = Attendance.Attendance_Out_Save(attendance); } if (AttendanceId > 0) { Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Not saved."; } return(AttendanceId); }
public int Attendance_Out_Save(Model.Attendance attendance) { int AttendanceId = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Attendance_Out_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId).Direction = ParameterDirection.InputOutput; cmd.Parameters.AddWithValue("@OutDateTime", attendance.OutDateTime); cmd.Parameters.AddWithValue("@CreatedBy", attendance.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); AttendanceId = Convert.ToInt32(cmd.Parameters["@AttendanceId"].Value); con.Close(); } } return(AttendanceId); }
private void LoadAttendanceList() { DataTable dtAttendance; Model.Attendance attendance = new Model.Attendance() { AttendanceTypeId = this.AttendanceTypeId, EnrolmentNo = txtEnrolmentNo.Text.Trim(), CreatedBy = 1, EventId = Convert.ToInt32(ddlBatch.SelectedValue), MemberId = (string.IsNullOrEmpty(hfStudentId.Value) ? 0 : Convert.ToInt32(hfStudentId.Value)), AttendanceDate = Convert.ToDateTime(txtAttendanceDate.Text) }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Attendance = scope.Resolve <IAttendance>(); dtAttendance = Attendance.Attendance_GetAll(attendance); } if (dtAttendance != null) { dgvStudentAttendance.DataSource = dtAttendance; dgvStudentAttendance.DataBind(); } }
public DataTable Attendance_GetAll(Model.Attendance attendance) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Attendance_GetAll"; if (attendance.AttendanceId == 0) { cmd.Parameters.AddWithValue("@AttendanceId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId); } if (attendance.AttendanceTypeId == 0) { cmd.Parameters.AddWithValue("@AttendanceTypeId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@AttendanceTypeId", attendance.AttendanceTypeId); } if (attendance.EventId == 0) { cmd.Parameters.AddWithValue("@EventId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@EventId", attendance.EventId); } if (attendance.MemberId == 0) { cmd.Parameters.AddWithValue("@MemberId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@MemberId", attendance.MemberId); } if (attendance.FromDateTime == DateTime.MinValue) { cmd.Parameters.AddWithValue("@FromDateTime", DBNull.Value); } else { cmd.Parameters.AddWithValue("@FromDateTime", attendance.FromDateTime); } if (attendance.ToDateTime == DateTime.MinValue) { cmd.Parameters.AddWithValue("@ToDateTime", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ToDateTime", attendance.ToDateTime); } if (string.IsNullOrEmpty(attendance.EnrolmentNo)) { cmd.Parameters.AddWithValue("@EnrolmentNo", DBNull.Value); } else { cmd.Parameters.AddWithValue("@EnrolmentNo", attendance.EnrolmentNo); } if (attendance.AttendanceDate == DateTime.MinValue) { cmd.Parameters.AddWithValue("@AttendanceDate", DBNull.Value); } else { cmd.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
public int Attendance_Out_Save(Model.Attendance Attendance) { return(_Attendance.Attendance_Out_Save(Attendance)); }
public DataTable Attendance_GetAll(Model.Attendance Attendance) { return(_Attendance.Attendance_GetAll(Attendance)); }