public static AttendanceEntity GetLastPunchInTime(int UserId)
{
try
{
AttendanceEntity AttendanceObj = null;
using (HRMEntities db = new HRMEntities())
{
AttendanceObj = (from a in db.Attendances
join u in db.Users on a.UserId equals u.UserId
where ((u.UserId == UserId) && (a.PunchOut == null))
select new AttendanceEntity
{
AttendanceId = a.AttendanceId,
UserId = a.UserId,
UserName = u.UserName,
PunchIn = a.PunchIn,
PunchInMessage = a.PunchInMessage,
PunchOut = a.PunchOut,
PunchOutMessage = a.PunchOutMessage,
Duration = a.Duration
}).FirstOrDefault();
}
return(AttendanceObj);
}
catch
{
throw;
}
}
public ActionResult PunchInOut(AttendanceModel model)
{
if (ModelState.IsValid)
{
try
{
AttendanceEntity ObjAttendance = new AttendanceEntity();
ObjAttendance.AttendanceId = model.AttendanceId;
if (model.AttendanceId == 0)
{
ObjAttendance.PunchInMessage = model.Message;
ObjAttendance.PunchIn = DateTime.Now;
}
else
{
ObjAttendance.PunchOutMessage = model.Message;
ObjAttendance.PunchOut = DateTime.Now;
}
ObjAttendance.UserId = HRMHelper.CurrentUser.UserId;
ObjAttendance.AttendanceId = AttendanceServices.PunchInOut(ObjAttendance);
TempData[HRMWeb.Helpers.AlertStyles.Success] = "Successfully Saved";
}
catch
{
TempData[HRMWeb.Helpers.AlertStyles.Danger] = "Punch In Fails";
}
}
return(RedirectToAction("PunchInOut"));
}
private void Attendance_Search_Click(object sender, RoutedEventArgs e)
{
AttendanceEntity searchedAttendanceEntity = null;
try
{
int AttendanceID = int.Parse(txtAId.Text);
string x = "01 - 01 - 0001";
searchedAttendanceEntity = attendanceBLL.SearchAttendanceBLL(AttendanceID, LoginEntity.UserID);
if (searchedAttendanceEntity.AttendanceDate != Convert.ToDateTime(x))
{
MessageBox.Show("Attendance Found!!");
txtEmpId.Text = searchedAttendanceEntity.EmployeeID.ToString();
cmbAType.Text = searchedAttendanceEntity.AttendanceType;
txtDate.Text = Convert.ToDateTime(searchedAttendanceEntity.AttendanceDate).ToString();
txtInTime.Text = searchedAttendanceEntity.InTime;
txtOutTime.Text = searchedAttendanceEntity.OutTime;
}
else
{
MessageBox.Show("Attendance Not Found!!!");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void DeleteAttendanceEntity(AttendanceEntity attendanceEntityToDelete)
{
using (var db = new PlutoContext())
{
db.Entry(attendanceEntityToDelete).State = EntityState.Deleted;
db.SaveChanges();
}
}
/// <summary>Creates a new, empty AttendanceEntity object.</summary>
/// <returns>A new, empty AttendanceEntity object.</returns>
public override IEntity Create()
{
IEntity toReturn = new AttendanceEntity();
// __LLBLGENPRO_USER_CODE_REGION_START CreateNewAttendance
// __LLBLGENPRO_USER_CODE_REGION_END
return(toReturn);
}
public int AddAttendanceEntity(AttendanceEntity attendanceEntity)
{
using (var db = new PlutoContext())
{
db.Attendances.Add(attendanceEntity);
db.SaveChanges();
}
return(attendanceEntity.Id);
}
public AttendanceEntity SearchAttendanceBLL(int AttendanceID, int userId)
{
AttendanceEntity serchedAttendanceEntity = null;
try
{
serchedAttendanceEntity = attendanceDAL.SearchAttendaceDAL(AttendanceID, userId);
}
catch (Exception e) { throw e; }
return(serchedAttendanceEntity);
}
public ActionResult PunchInOut()
{
AttendanceModel model = new AttendanceModel();
AttendanceEntity ObjAttendance = AttendanceServices.GetLastPunchInTime(HRMHelper.CurrentUser.UserId);
if (ObjAttendance != null)
{
model.AttendanceId = ObjAttendance.AttendanceId;
model.PunchIn = ObjAttendance.PunchIn;
}
return(View(model));
}
public bool ValidateAttendance(AttendanceEntity attendanceEntity)
{
bool ValidAttendance = true;
Regex regex = new Regex("^[0-2][0-9]:[0-6][0-9]:[0-6][0-9]$");
if (!(regex.IsMatch(attendanceEntity.InTime)))
{
Console.WriteLine("Time can be in HH:MM:SS Format only.");
ValidAttendance = false;
}
return(ValidAttendance);
}
public AttendanceEntity SearchAttendaceDAL(int AttendanceID, int userId)
{
AttendanceEntity searchedAttendance = new AttendanceEntity();
try
{
connection.Open();
//Step3. Create the command
string command = "spSearchAttendance";
SqlCommand sqlCommand = new SqlCommand(command, connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@aId", AttendanceID);
sqlCommand.Parameters.AddWithValue("@eId", userId);
//Step4. Run the command
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
searchedAttendance.EmployeeID = int.Parse(reader["Employee_ID"].ToString());
//string str = reader["Employee_ID"].ToString();
//searchedAttendance.EmployeeID = Convert.ToInt32(str);
string aType = reader["Attedance_Type"].ToString();
searchedAttendance.AttendanceType = aType;
searchedAttendance.AttendanceDate = (DateTime)reader["Attedance_Date"];
searchedAttendance.InTime = reader["In_Time"].ToString();
searchedAttendance.OutTime = reader["Out_Time"].ToString();
}
}
else
{
Console.WriteLine("Record is not present in the DataBase");
}
}
catch (SqlException exception)
{
Console.WriteLine("Something Went Wrong." + exception.Message);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//Step5. Close the connection
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(searchedAttendance);
}
public bool ApproveRejectAttendanceBLL(AttendanceEntity attendanceEntity)
{
bool isUpdated = false;
try
{
isUpdated = attendanceDAL.ApproveRejectAttendanceDAL(attendanceEntity);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(isUpdated);
}
private Attendance ConvertToModel(AttendanceEntity attendanceEntity)
{
var attendance = new Attendance(attendanceEntity.Name)
{
AttendanceId = attendanceEntity.Id,
RegisteredSubjectId = attendanceEntity.RegisteredSubjectId,
Name = attendanceEntity.Name,
IsAttended = attendanceEntity.IsAttended,
Date = attendanceEntity.Date,
StartTime = attendanceEntity.StartTime,
EndTime = attendanceEntity.EndTime
};
return(attendance);
}
public bool UpdateAttendanceBLL(AttendanceEntity attendanceEntity)
{
bool isUpdated = false;
try
{
if (ValidateAttendance(attendanceEntity))
{
isUpdated = attendanceDAL.UpdateAttendanceDAL(attendanceEntity);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(isUpdated);
}
public bool ValidateAttendanceBLL(AttendanceEntity attendanceEntity)
{
bool isAdded = false;
try
{
if (ValidateAttendance(attendanceEntity))
{
isAdded = attendanceDAL.AddAttendanceDAL(attendanceEntity);
}
}
catch (Exception)
{
throw;
}
return(isAdded);
}
public static int PunchInOut(AttendanceEntity ob)
{
try
{
int AttendanceId = 0;
using (HRMEntities db = new HRMEntities())
{
System.Data.Entity.Core.Objects.ObjectParameter OutPut = new System.Data.Entity.Core.Objects.ObjectParameter("Output", typeof(int));
db.sp_InsertUpdateAttendance(ob.AttendanceId, ob.UserId, ob.PunchInMessage, ob.PunchOutMessage, OutPut);
AttendanceId = int.Parse(OutPut.Value.ToString());
}
return(AttendanceId);
}
catch
{
throw;
}
}
public bool UpdateAttendanceDAL(AttendanceEntity attendanceEntity)
{
bool isAttendanceUpdated = false;
try
{
connection.Open();
string command = "spModifyAttendance";
SqlCommand sqlCommand = new SqlCommand(command, connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Attedance_Type", attendanceEntity.AttendanceType);
sqlCommand.Parameters.AddWithValue("@Attedance_Date", attendanceEntity.AttendanceDate);
sqlCommand.Parameters.AddWithValue("@In_Time", attendanceEntity.InTime);
sqlCommand.Parameters.AddWithValue("@Out_Time", attendanceEntity.OutTime);
sqlCommand.Parameters.AddWithValue("@aId", attendanceEntity.AttendanceID);
sqlCommand.Parameters.AddWithValue("@Employee_ID", attendanceEntity.EmployeeID);
int RowsAffected = sqlCommand.ExecuteNonQuery();
if (RowsAffected == 1)
{
Console.WriteLine("Attendance Added Successfully.");
isAttendanceUpdated = true;
}
else
{
Console.WriteLine("Something went wrong.");
isAttendanceUpdated = false;
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(isAttendanceUpdated);
}
public bool ApproveRejectAttendanceDAL(AttendanceEntity attendanceEntity)
{
bool isAttendanceUpdated = false;
DateTime dateTime = DateTime.Now;
try
{
connection.Open();
string command = "spApproveRejectPendingAttendance";
SqlCommand sqlCommand = new SqlCommand(command, connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@aId", attendanceEntity.AttendanceID);
sqlCommand.Parameters.AddWithValue("@Status_Of_Attendance", attendanceEntity.StatusOfAttendance);
sqlCommand.Parameters.AddWithValue("@Status_Update_Date", dateTime.Date);
sqlCommand.Parameters.AddWithValue("@Status_Updated_By", LoginEntity.UserID);
int RowsAffected = sqlCommand.ExecuteNonQuery();
if (RowsAffected == 1)
{
Console.WriteLine("Pending Attendance Updated Successfully.");
isAttendanceUpdated = true;
}
else
{
Console.WriteLine("Pending Attendance Not Updated.");
isAttendanceUpdated = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(isAttendanceUpdated);
}
public bool AddAttendanceDAL(AttendanceEntity attendanceEntity)
{
bool isAttendanceAdded = false;
try
{
int y = 1;
int z = 1;
connection.Open();
string command = "spLeaveCheck";
SqlCommand sqlCommand = new SqlCommand(command, connection);
sqlCommand.CommandType = CommandType.StoredProcedure;
string x = attendanceEntity.AttendanceDate.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture);
sqlCommand.Parameters.AddWithValue("@ADate", x);
sqlCommand.Parameters.AddWithValue("@eId", attendanceEntity.EmployeeID);
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
y = 0;
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
connection.Open();
string command2 = "spAttendanceAlreadyAppliedCheck";
SqlCommand sqlCommand2 = new SqlCommand(command2, connection);
sqlCommand2.CommandType = CommandType.StoredProcedure;
string date = attendanceEntity.AttendanceDate.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture);
sqlCommand2.Parameters.AddWithValue("@ADate", date);
sqlCommand2.Parameters.AddWithValue("@eId", attendanceEntity.EmployeeID);
SqlDataReader reader1 = sqlCommand2.ExecuteReader();
if (reader1.Read())
{
z = 0;
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
if (y == 1 && z == 1)
{
if (LoginEntity.ProjectID == attendanceEntity.ProjectID)
{
connection.Open();
string command1 = "spAddAttendance";
SqlCommand sqlCommand1 = new SqlCommand(command1, connection);
sqlCommand1.CommandType = CommandType.StoredProcedure;
sqlCommand1.Parameters.AddWithValue("@Attedance_Type", attendanceEntity.AttendanceType);
sqlCommand1.Parameters.AddWithValue("@Attedance_Date", attendanceEntity.AttendanceDate);
sqlCommand1.Parameters.AddWithValue("@In_Time", attendanceEntity.InTime);
sqlCommand1.Parameters.AddWithValue("@Out_Time", attendanceEntity.OutTime);
sqlCommand1.Parameters.AddWithValue("@Status_Of_Attendance", "Approved");
sqlCommand1.Parameters.AddWithValue("@Status_Update_Date", attendanceEntity.AttendanceDate);
sqlCommand1.Parameters.AddWithValue("@Status_Updated_By", LoginEntity.ManagerID);
sqlCommand1.Parameters.AddWithValue("@Employee_ID", attendanceEntity.EmployeeID);
sqlCommand1.Parameters.AddWithValue("@Manager_ID", LoginEntity.ManagerID);
sqlCommand1.Parameters.AddWithValue("@Project_ID", LoginEntity.ProjectID);
int RowsAffected = sqlCommand1.ExecuteNonQuery();
if (RowsAffected == 1)
{
Console.WriteLine("Attendance Added Successfully.");
isAttendanceAdded = true;
}
else
{
isAttendanceAdded = false;
}
}
else
{
connection.Open();
string command1 = "spAddAttendance";
SqlCommand sqlCommand1 = new SqlCommand(command1, connection);
sqlCommand1.CommandType = CommandType.StoredProcedure;
sqlCommand1.Parameters.AddWithValue("@Attedance_Type", attendanceEntity.AttendanceType);
sqlCommand1.Parameters.AddWithValue("@Attedance_Date", attendanceEntity.AttendanceDate);
sqlCommand1.Parameters.AddWithValue("@In_Time", attendanceEntity.InTime);
sqlCommand1.Parameters.AddWithValue("@Out_Time", attendanceEntity.OutTime);
sqlCommand1.Parameters.AddWithValue("@Employee_ID", attendanceEntity.EmployeeID);
sqlCommand1.Parameters.AddWithValue("@Manager_ID", LoginEntity.ManagerID);
sqlCommand1.Parameters.AddWithValue("@Project_ID", attendanceEntity.ProjectID);
int RowsAffected = sqlCommand1.ExecuteNonQuery();
if (RowsAffected == 1)
{
Console.WriteLine("Attendance Added Successfully.");
isAttendanceAdded = true;
}
else
{
isAttendanceAdded = false;
}
}
}
else if (y == 1 && z == 0)
{
Console.WriteLine("Attendance is already applied");
}
else
{
Console.WriteLine("Leave is applied already");
isAttendanceAdded = false;
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(isAttendanceAdded);
}
public List <AttendanceEntity> GetAttendance2MAy19(DBSite site, int yearNo, int theMonth, int theDay, int clasId, bool onlyAbsentees)
{
List <AttendanceEntity> adList = new List <AttendanceEntity>();
AttendanceEntity da = null;
string qry = "";
qry = "SELECT AttendanceId, YearNo, MonthNo, DayNo, HolidayID "
+ ", a.StudentMasterID, StudentName, s.classID, MobileF , ClassName, s.SectionId, sc.SectionName, s.IdCardNo "
+ " , (SELECT MIN(InTime) FROM tblAttendance "
+ Util_BLL.GetUserWhereCondition("a")
+ " AND YearNo = " + yearNo
+ " AND MonthNo = " + theMonth
+ " AND DayNo = " + theDay
+ " AND studentmasterid=s.studentMasterID "
+ " GROUP BY StudentMasterID, YearNo, monthno, dayno, userId, FYear )InTime "
+ " , OutTime, Status "
+ ", IsPosted "
+ " , (select MAX(IsSMSSent) FROM tblAttendance where dayNo=" + theDay + " AND STUDENTMASTERID = s.studentMasterID GROUP BY StudentMasterID) IsSmsSent "
+ " FROM tblAttendance a "
+ " LEFT OUTER JOIN tblStudentMaster s ON s.StudentMasterID = a.StudentMasterID "
+ " LEFT OUTER JOIN tblClassMaster C ON c.classMasterID = s.classID "
+ " LEFT OUTER JOIN tblSectionMaster sc ON sc.SectionMasterID = s.SectionId "
+ Util_BLL.GetUserWhereCondition("a")
+ " AND YearNo = " + yearNo
+ " AND MonthNo = " + theMonth
+ " AND DayNo = " + theDay;
if (onlyAbsentees)
{
qry += " AND status = 0 ";
}
if (clasId != -1)
{
qry += " AND c.classMasterID = " + clasId;
}
qry += " AND AttendanceID In (select MAx(AttendanceID) "
+ " FROM tblAttendance b"
+ Util_BLL.GetUserWhereCondition("b")
+ " GROUP BY StudentMasterID, YearNo, monthno, dayno, userId, FYear ) "
+ " ORDER BY ClassOrder,sectionName, StudentName ";
SendSMSToParents.WriteErrorLog("GetAttendance qry " + qry);
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow dr in dt.Rows)
{
da = new AttendanceEntity();
da.AttendanceId = util.CheckNullInt(dr["AttendanceId"]);
da.YearNo = util.CheckNullInt(dr["YearNo"]);
da.MonthNo = util.CheckNullInt(dr["MonthNo"]);
da.DayNo = util.CheckNullInt(dr["DayNo"]);
da.HolidayId = util.CheckNullInt(dr["HolidayID"]);
da.StudentId = util.CheckNullInt(dr["StudentMasterID"]);
da.StudentName = util.CheckNull(dr["StudentName"]);
da.MobileNo = util.CheckNull(dr["MobileF"]);
da.ClassId = util.CheckNullInt(dr["ClassID"]);
da.ClassName = util.CheckNull(dr["ClassName"]);
da.SectionId = util.CheckNullInt(dr["SectionID"]);
da.SectionName = util.CheckNull(dr["SectionName"]);
da.IdcardNo = util.CheckNull(dr["IdCardNo"]);
da.InTime = util.CheckNull(dr["InTime"]);
da.OutTime = util.CheckNull(dr["OutTime"]);
da.IsPosted = util.CheckNullInt(dr["IsPosted"]);
da.IsSMSSent = util.CheckNullInt(dr["IsSMSSent"]);
da.Status = util.CheckNullInt(dr["status"]);
//if (da.IsPosted==0)
// da.Status = 1;
adList.Add(da);
}
return(adList);
}
//public void SaveAttendance(DBSite site, List<AttendanceEntity> attdList)
//{
// string qry = "";
// foreach (AttendanceEntity atd in attdList)
// {
// qry = " INSERT INTO tblAttendance ("
// + " YearNo, MonthNo, DayNo, HolydayID, StudentMasterID, InTime, OutTime, Status, IsPosted, IsSMSSent, UserId, SubUserId, FYear )"
// + " VALUES ( "
// + atd.YearNo
// + ", " + atd.MonthNo
// + "," + atd.DayNo
// + "," + atd.StudentId
// + ", '" + atd.InTime + "'"
// + ", '" + atd.OutTime + "'"
// + ", " + atd.Status
// + ", " + atd.IsPosted
// + ", " + atd.IsSMSSent ;
// qry +=", "+ util.GetUserInsertQry(Util_BLL.User);
// qry += " ) ";
// site.Execute(qry);
// }
// }
//public List<AttendanceByMonthEntity> GetAttendanceByMonth(int yearNo, int monthNo, int SchoolClassId)
//{
// List<AttendanceByMonthEntity> attendance_list = new List<AttendanceByMonthEntity>();
// AttendanceByMonthEntity abm;
// string qry = "SELECT * FROM vwAttendanceByMonth "
// + Util_BLL.GetUserWhereCondition(Util_BLL.User)
// + " AND YearNo = " + yearNo
// + " AND MonthNo = " + monthNo;
// if (SchoolClassId != -1)
// qry += " AND ClassMasterId = " + SchoolClassId;
// DBSite site2 = new DBSite();
// DataTable dt = site2.ExecuteSelect(qry);
// foreach (DataRow dr in dt.Rows)
// {
// abm = new AttendanceByMonthEntity();
// abm.StudentId = util.CheckNullInt(dr["StudentMasterID"]);
// abm.StudentName = util.CheckNull(dr["StudentName"]);
// abm.ClassId = util.CheckNullInt(dr["ClassMasterId"]);
// abm.ClassName = util.CheckNull(dr["ClassName"]);
// abm.YearNo = util.CheckNullInt(dr["YearNo"]);
// abm.MonthNo = util.CheckNullInt(dr["MonthNo"]);
// abm.Day1 = util.CheckNull(dr["Day1"]);
// abm.Day2 = util.CheckNull(dr["Day2"]);
// abm.Day3 = util.CheckNull(dr["Day3"]);
// abm.Day4 = util.CheckNull(dr["Day4"]);
// abm.Day5 = util.CheckNull(dr["Day5"]);
// abm.Day6 = util.CheckNull(dr["Day6"]);
// abm.Day7 = util.CheckNull(dr["Day7"]);
// abm.Day8 = util.CheckNull(dr["Day8"]);
// abm.Day9 = util.CheckNull(dr["Day9"]);
// abm.Day10 = util.CheckNull(dr["Day10"]);
// abm.Day11 = util.CheckNull(dr["Day11"]);
// abm.Day12 = util.CheckNull(dr["Day12"]);
// abm.Day13 = util.CheckNull(dr["Day13"]);
// abm.Day14 = util.CheckNull(dr["Day14"]);
// abm.Day15 = util.CheckNull(dr["Day15"]);
// abm.Day16 = util.CheckNull(dr["Day16"]);
// abm.Day17 = util.CheckNull(dr["Day17"]);
// abm.Day18 = util.CheckNull(dr["Day18"]);
// abm.Day19 = util.CheckNull(dr["Day19"]);
// abm.Day20 = util.CheckNull(dr["Day20"]);
// abm.Day21 = util.CheckNull(dr["Day21"]);
// abm.Day22 = util.CheckNull(dr["Day22"]);
// abm.Day23 = util.CheckNull(dr["Day23"]);
// abm.Day2 = util.CheckNull(dr["Day24"]);
// abm.Day25 = util.CheckNull(dr["Day25"]);
// abm.Day26 = util.CheckNull(dr["Day26"]);
// abm.Day27 = util.CheckNull(dr["Day27"]);
// abm.Day28 = util.CheckNull(dr["Day28"]);
// abm.Day29 = util.CheckNull(dr["Day29"]);
// abm.Day30 = util.CheckNull(dr["Day30"]);
// abm.Day31 = util.CheckNull(dr["Day31"]);
// attendance_list.Add(abm);
// }
// return attendance_list;
//}
//public List<AttendanceEntity> GetAttendanceByDate(string fromDate, int SchoolClassId)
//{
// DateTime enteredDate = DateTime.Today;
// int year_no = 2014;
// int month_no = 5;
// int day_no = 5;
// if (fromDate != null)
// enteredDate = DateTime.Parse(fromDate);
// year_no = enteredDate.Year;
// month_no = enteredDate.Month;
// day_no = enteredDate.Day;
// DBSite site2 = new DBSite();
// return GetAttendance(site2, year_no, month_no, day_no, SchoolClassId, false);
//}
public List <AttendanceEntity> GetAttendance(DBSite site, int yearNo, int theMonth, int theDay, int clasId, bool onlyAbsentees)
{
List <AttendanceEntity> adList = new List <AttendanceEntity>();
AttendanceEntity da = null;
string qry = "";
qry = "SELECT AttendanceId, YearNo, MonthNo, DayNo, HolidayID "
+ ", a.StudentMasterID, StudentName, s.classID, MobileF , ClassName, s.SectionId, sc.SectionName, s.IdCardNo "
+ " , InTime "
+ " , OutTime, Status "
+ ", IsPosted "
+ " , IsSmsSent "
+ " FROM tblAttendance a "
+ " LEFT OUTER JOIN tblStudentMaster s ON s.StudentMasterID = a.StudentMasterID "
+ " LEFT OUTER JOIN tblClassMaster C ON c.classMasterID = s.classID "
+ " LEFT OUTER JOIN tblSectionMaster sc ON sc.SectionMasterID = s.SectionId "
+ Util_BLL.GetUserWhereCondition("a")
+ " AND YearNo = " + yearNo
+ " AND MonthNo = " + theMonth
+ " AND DayNo = " + theDay;
if (onlyAbsentees)
{
qry += " AND status = 0 ";
}
if (clasId != -1)
{
qry += " AND c.classMasterID = " + clasId;
}
DataTable dt = site.ExecuteSelect(qry);
foreach (DataRow dr in dt.Rows)
{
da = new AttendanceEntity();
da.AttendanceId = util.CheckNullInt(dr["AttendanceId"]);
da.YearNo = util.CheckNullInt(dr["YearNo"]);
da.MonthNo = util.CheckNullInt(dr["MonthNo"]);
da.DayNo = util.CheckNullInt(dr["DayNo"]);
da.HolidayId = util.CheckNullInt(dr["HolidayID"]);
da.StudentId = util.CheckNullInt(dr["StudentMasterID"]);
da.StudentName = util.CheckNull(dr["StudentName"]);
da.MobileNo = util.CheckNull(dr["MobileF"]);
da.ClassId = util.CheckNullInt(dr["ClassID"]);
da.ClassName = util.CheckNull(dr["ClassName"]);
da.SectionId = util.CheckNullInt(dr["SectionID"]);
da.SectionName = util.CheckNull(dr["SectionName"]);
da.IdcardNo = util.CheckNull(dr["IdCardNo"]);
da.InTime = util.CheckNull(dr["InTime"]);
da.OutTime = util.CheckNull(dr["OutTime"]);
da.IsPosted = util.CheckNullInt(dr["IsPosted"]);
da.IsSMSSent = util.CheckNullInt(dr["IsSMSSent"]);
da.Status = util.CheckNullInt(dr["status"]);
//if (da.IsPosted==0)
// da.Status = 1;
adList.Add(da);
}
//SendSMSToParents.WriteErrorLog("GetAttendance : " + qry);
return(adList);
}
public Attendance GetAttendance(AttendanceEntity attendanceEntity)
{
var attendance = ConvertToModel(attendanceEntity);
return(attendance);
}
public static int PunchInOut(AttendanceEntity ob)
{
return(AttendanceProvider.PunchInOut(ob));
}