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