public static int Attendance_Save(Entity.HR.Attendance attendance)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_HR_Attendance_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AttendanceId", attendance.AttendanceId);
cmd.Parameters.AddWithValue("@EmployeeId", attendance.EmployeeId);
cmd.Parameters.AddWithValue("@AttendanceDate", attendance.AttendanceDate);
cmd.Parameters.AddWithValue("@InDateTime", attendance.InDateTime);
cmd.Parameters.AddWithValue("@OutDateTime", attendance.OutDateTime);
cmd.Parameters.AddWithValue("@TotalHours", attendance.TotalHours);
cmd.Parameters.AddWithValue("@CreatedBy", attendance.CreatedBy);
cmd.Parameters.AddWithValue("@Latitude", attendance.Latitude);
cmd.Parameters.AddWithValue("@Longitude", attendance.Longitude);
cmd.Parameters.AddWithValue("@Source", attendance.Source);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
public static DataSet Attendance_GetAll(Entity.HR.Attendance attendance)
{
using (DataSet ds = new DataSet())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_Attendance_GetAll";
if (string.IsNullOrEmpty(attendance.EmployeeName))
{
cmd.Parameters.AddWithValue("@EmployeeName", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@EmployeeName", attendance.EmployeeName);
}
if (attendance.AttendanceFromDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@AttendanceFromDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@AttendanceFromDate", attendance.AttendanceFromDate);
}
if (attendance.AttendanceToDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@AttendanceToDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@AttendanceToDate", attendance.AttendanceToDate);
}
cmd.InsertPaging(attendance, attendance.AttendanceId);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
con.Close();
}
}
return(ds);
}
}
private AttendanceModel SaveAttendance(AttendanceModel model)
{
model.ResponseCode = 99;
try
{
if (!CheckAttendanceBlocked(model))
{
if (model.AttendanceMode.ToLower().Equals("out"))
{
Business.HR.Attendance objAttendance = new Business.HR.Attendance();
Entity.HR.Attendance attendance = new Entity.HR.Attendance()
{
AttendanceDate = DateTime.UtcNow.AddHours(5).AddMinutes(33),
InDateTime = DateTime.UtcNow.AddHours(5).AddMinutes(33),
OutDateTime = DateTime.UtcNow.AddHours(5).AddMinutes(33),
EmployeeId = Convert.ToInt32(model.UserId),
CreatedBy = Convert.ToInt32(model.UserId),
TotalHours = 0,
Latitude = model.Latitude,
Longitude = model.Longitude,
Source = "Android"
};
objAttendance.Attendance_Save(attendance);
model.Message = "You are successfully IN.";
model.ResponseCode = 200;
}
else if (model.AttendanceMode.ToLower().Equals("in"))
{
Business.HR.Attendance objAttendance = new Business.HR.Attendance();
DataTable dt = objAttendance.Attendance_GetByEmployeeId(Convert.ToInt32(model.UserId), DateTime.UtcNow.AddHours(5).AddMinutes(33));
if (dt != null && dt.AsEnumerable().Any())
{
Entity.HR.Attendance attendance = new Entity.HR.Attendance()
{
AttendanceId = Convert.ToInt64(dt.Rows[0]["AttendanceId"].ToString()),
AttendanceDate = Convert.ToDateTime(dt.Rows[0]["AttendanceDate"].ToString()),
InDateTime = Convert.ToDateTime(dt.Rows[0]["InDateTime"].ToString()),
OutDateTime = DateTime.UtcNow.AddHours(5).AddMinutes(33),
CreatedBy = Convert.ToInt32(model.UserId),
TotalHours = (DateTime.UtcNow.AddHours(5).AddMinutes(33) - Convert.ToDateTime(dt.Rows[0]["InDateTimeRaw"].ToString())).TotalMinutes,
Latitude = model.Latitude,
Longitude = model.Longitude,
Source = "Android"
};
objAttendance.Attendance_Save(attendance);
model.Message = "You are successfully OUT.";
model.ResponseCode = 200;
}
else
{
model.Message = "Invalid employee id.";
model.ResponseCode = 200;
}
}
}
else
{
model.Message = "Your attendance is blocked for today. Please contact HR.";
model.ResponseCode = 200;
}
}
catch (Exception ex)
{
new Logger().LogException(ex, "SaveAttendance");
model.ResponseCode = 99;
model.Message = ex.Message;
}
return(model);
}
public int Attendance_Save(Entity.HR.Attendance attendance)
{
return(DataAccess.HR.Attendance.Attendance_Save(attendance));
}
public DataSet Attendance_GetAll(Entity.HR.Attendance attendance)
{
return(DataAccess.HR.Attendance.Attendance_GetAll(attendance));
}
