protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE") || e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN"))
{
AttendanceLogic al = new AttendanceLogic();
DataTable dt = al.Select();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label3.Visible = true;
}
else
{
Table1.Visible = true;
Label3.Visible = false;
}
}
else
{
Response.Redirect("Access.aspx");
}
}
public ActionResult ViewAttendance(string eventId)
{
_viewModel = new EventViewModel();
try
{
if (!string.IsNullOrEmpty(eventId))
{
long myEventId = Convert.ToInt64(Utility.Decrypt(eventId));
AttendanceLogic attendanceLogic = new AttendanceLogic();
AbsentLogLogic absentLogLogic = new AbsentLogLogic();
_viewModel.AttendanceList = attendanceLogic.GetEntitiesBy(s => s.Event_Id == myEventId);
_viewModel.AttendanceList.ForEach(e =>
{
if (e.Attendance_Status_Id == (int)AttendanceStatuses.Excused)
{
e.ATTENDANCE_STATUS.Name = absentLogLogic.GetAbsenceRequestStatus(e);
}
});
_viewModel.EventId = myEventId;
}
}
catch (Exception ex)
{
SetMessage("Error! " + ex.Message, Message.Category.Error);
}
return(View(_viewModel));
}
protected void Button2_Click(object sender, EventArgs e)
{
if (TextBox1.Text.Equals(""))
{
Label2.Visible = true;
}
else
{
AttendanceLogic al = new AttendanceLogic();
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
DataTable dt = al.Search(d1);
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label3.Visible = true;
}
else
{
Table1.Visible = true;
Label3.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
EmployeeLogic el = new EmployeeLogic();
Employee e2 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
if (e2.Designation.Equals("HR MANAGER") || e2.Designation.Equals("HR EMPLOYEE") || e2.Designation.Equals("MANAGING DIRECTOR") || e2.Designation.Equals("CHAIRMAN"))
{
AttendanceLogic al = new AttendanceLogic();
DataTable dt = al.Select();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label3.Visible = true;
}
else
{
Table1.Visible = true;
Label3.Visible = false;
}
}
else
{
Response.Redirect("Access.aspx");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (TextBox1.Text.Equals(""))
{
Label2.Visible = true;
}
else
{
AttendanceLogic al = new AttendanceLogic();
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(TextBox1.Text, "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
DataTable dt = al.Search(d1);
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (dt.Rows.Count == 0)
{
Table1.Visible = false;
Label3.Visible = true;
}
else
{
Table1.Visible = true;
Label3.Visible = false;
}
}
}
public AttendanceController()
{
_studentLogic = new StudentLogic();
_eventLogic = new EventLogic();
_absentTypeLogic = new AbsentTypeLogic();
_attendanceLogic = new AttendanceLogic();
_absentLogLogic = new AbsentLogLogic();
_courseLogic = new CourseLogic();
}
public AttendanceController()
{
var config = new MapperConfiguration(cfg => {
cfg.AddProfile <ModelMapper>();
});
_mapper = config.CreateMapper();
_attendanceLogic = new AttendanceLogic();
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
Label1.Visible = false;
DataSet ds = new DataSet();
String path = "";
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
path = Server.MapPath("Images/" + ticks + FileUpload1.FileName);
OpenExcelFile(path, ref ds);
}
AttendanceLogic al = new AttendanceLogic();
Attendance a = new Attendance();
DateTime d1 = new DateTime();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
a.EmployeeID = Convert.ToInt32(ds.Tables[0].Rows[i]["EmployeeID"]);
if (!DateTime.TryParseExact(ds.Tables[0].Rows[i]["ADate"].ToString(), "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
a.Adate = d1;
if (ds.Tables[0].Rows[i]["Mark"].ToString().Equals("P"))
{
a.Mark = true;
}
else if (ds.Tables[0].Rows[i]["Mark"].ToString().Equals("A"))
{
a.Mark = false;
}
al.Insert(a);
}
ds.Tables[0].Columns.Add(new DataColumn("EmployeeName"));
EmployeeLogic el = new EmployeeLogic();
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i]["EmployeeName"] = (el.SelectByID(Convert.ToInt32(ds.Tables[0].Rows[i]["EmployeeID"]))).Name;
}
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
else {
Label1.Visible = true;
}
}
public ActionResult LoadAttendanceInfo(Guid?userId, DateTime beginTime, DateTime endTime)
{
AttendanceLogic al = new AttendanceLogic();
if (userId == null)
{
userId = UserContext.CurrentUser.UserId;
}
var data = al.QueryAttendance(userId.Value, beginTime, endTime);
return(Json(data));
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
Label1.Visible = false;
DataSet ds = new DataSet();
String path = "";
string ticks = DateTime.Now.Ticks.ToString();
if (FileUpload1.HasFile)
{
FileUpload1.SaveAs(Server.MapPath("Images/" + ticks + FileUpload1.FileName));
path = Server.MapPath("Images/" + ticks + FileUpload1.FileName);
OpenExcelFile(path, ref ds);
}
AttendanceLogic al = new AttendanceLogic();
Attendance a = new Attendance();
DateTime d1 = new DateTime();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
a.EmployeeID = Convert.ToInt32(ds.Tables[0].Rows[i]["EmployeeID"]);
if (!DateTime.TryParseExact(ds.Tables[0].Rows[i]["ADate"].ToString(), "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
a.Adate = d1;
if (ds.Tables[0].Rows[i]["Mark"].ToString().Equals("P"))
{
a.Mark = true;
}
else if (ds.Tables[0].Rows[i]["Mark"].ToString().Equals("A"))
{
a.Mark = false;
}
al.Insert(a);
}
ds.Tables[0].Columns.Add(new DataColumn("EmployeeName"));
EmployeeLogic el = new EmployeeLogic();
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i]["EmployeeName"] = (el.SelectByID(Convert.ToInt32(ds.Tables[0].Rows[i]["EmployeeID"]))).Name;
}
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
else
{
Label1.Visible = true;
}
}
protected void LinkButton1_Command(object sender, CommandEventArgs e)
{
repdiv.Visible = false;
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32(e.CommandArgument));
Label1.Text = "Attendance Report for "+e1.Name;
empreport.Visible = true;
AttendanceLogic al = new AttendanceLogic();
DataTable dt = al.SelectForEmp(Convert.ToInt32(e.CommandArgument));
Repeater2.DataSource = dt;
Repeater2.DataBind();
}
protected void LinkButton1_Command(object sender, CommandEventArgs e)
{
repdiv.Visible = false;
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32(e.CommandArgument));
Label1.Text = "Attendance Report for " + e1.Name;
empreport.Visible = true;
AttendanceLogic al = new AttendanceLogic();
DataTable dt = al.SelectForEmp(Convert.ToInt32(e.CommandArgument));
Repeater2.DataSource = dt;
Repeater2.DataBind();
}
private ATTENDANCE ProcessHallAttendance(HALL hall, STUDENT student)
{
ATTENDANCE attendance = null;
try
{
AttendanceLogic attendanceLogic = new AttendanceLogic();
EventLogic eventLogic = new EventLogic();
int numberOfTimesPresent = attendanceLogic.GetEntitiesBy(s => s.EVENT.Hall_Id == hall.Id && s.Student_Id == student.Person_Id &&
s.Attendance_Status_Id == (int)AttendanceStatuses.Present).Count();
int numberOfLectures = eventLogic.GetEntitiesBy(s => s.Hall_Id == hall.Id && (s.Active == true || s.Active == null)).Count();
int numberOfAbsence = attendanceLogic.GetEntitiesBy(s => s.EVENT.Hall_Id == hall.Id && s.Student_Id == student.Person_Id &&
s.Attendance_Status_Id == (int)AttendanceStatuses.Excused).Count();
int numberOfLecturesHeld = numberOfLectures - numberOfAbsence;
double eligibilityPercentage = (Convert.ToDouble(numberOfTimesPresent) / Convert.ToDouble(numberOfLecturesHeld)) * 100.0;
attendance = new ATTENDANCE();
attendance.Percentage = eligibilityPercentage;
//result.ApproximateNumberOfLectures = numberOfLecturesHeld;
//result.EligibilityPercentage = eligibilityPercentage;
//result.NumberOfAbsent = numberOfAbsence;
//result.NumberOfPresent = numberOfTimesPresent;
//result.TotalNumberOfLectures = numberOfLectures;
if (eligibilityPercentage > 75)
{
attendance.IsEligible = true;
}
else
{
attendance.IsEligible = false;
}
}
catch (Exception)
{
throw;
}
return(attendance);
}
public JsonResult DeleteEvent(long eventId)
{
JsonResponseModel result = new JsonResponseModel();
try
{
if (eventId > 0)
{
AbsentLogLogic logLogic = new AbsentLogLogic();
EventLogic eventLogic = new EventLogic();
AttendanceLogic attendanceLogic = new AttendanceLogic();
ABSENT_LOG eventLog = logLogic.GetEntitiesBy(e => e.Event_Id == eventId).LastOrDefault();
ATTENDANCE eventAttendance = attendanceLogic.GetEntitiesBy(e => e.Event_Id == eventId).LastOrDefault();
if (eventLog == null && eventAttendance == null)
{
eventLogic.Delete(c => c.Id == eventId);
result.IsError = false;
result.Message = "Operation Successful!";
}
else
{
result.IsError = true;
result.Message = "Event is already attached to an attendance / absent log";
}
}
else
{
result.IsError = true;
result.Message = "Invalid parameter";
}
}
catch (Exception ex)
{
result.IsError = true;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["Date"] != null)
{
Label1.Text = "Attendance for " + Request.QueryString["Date"];
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(Request.QueryString["Date"], "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
AttendanceLogic al = new AttendanceLogic();
Repeater2.DataSource = al.SelectForAttendanceReport(d1);
Repeater2.DataBind();
}
else
{
Label1.Text = "Today's Attendance";
AttendanceLogic al = new AttendanceLogic();
Repeater2.DataSource = al.SelectForAttendanceReport(DateTime.Today);
Repeater2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["Date"] != null)
{
Label1.Text = "Attendance for " + Request.QueryString["Date"];
DateTime d1 = new DateTime();
if (!DateTime.TryParseExact(Request.QueryString["Date"], "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out d1))
{
}
AttendanceLogic al = new AttendanceLogic();
Repeater2.DataSource = al.SelectForAttendanceReport(d1);
Repeater2.DataBind();
}
else
{
Label1.Text = "Today's Attendance";
AttendanceLogic al = new AttendanceLogic();
Repeater2.DataSource = al.SelectForAttendanceReport(DateTime.Today);
Repeater2.DataBind();
}
}
public ActionResult DownloadAttendance(string eventId)
{
_viewModel = new EventViewModel();
try
{
if (!string.IsNullOrEmpty(eventId))
{
long myEventId = Convert.ToInt64(Utility.Decrypt(eventId));
AttendanceLogic attendanceLogic = new AttendanceLogic();
AbsentLogLogic absentLogLogic = new AbsentLogLogic();
_viewModel.AttendanceList = attendanceLogic.GetEntitiesBy(s => s.Event_Id == myEventId);
_viewModel.AttendanceList.ForEach(e =>
{
if (e.Attendance_Status_Id == (int)AttendanceStatuses.Excused)
{
e.ATTENDANCE_STATUS.Name = absentLogLogic.GetAbsenceRequestStatus(e);
}
});
GridView gv = new GridView();
DataTable ds = new DataTable();
if (_viewModel.AttendanceList.Count > 0)
{
List <ATTENDANCE> list = _viewModel.AttendanceList.OrderBy(p => p.STUDENT.Matric_Number).ToList();
List <AttendanceModel> sort = new List <AttendanceModel>();
for (int i = 0; i < list.Count; i++)
{
AttendanceModel attendance = new AttendanceModel();
attendance.SN = (i + 1);
attendance.Name = list[i].STUDENT.PERSON.Last_Name + " " + list[i].STUDENT.PERSON.First_Name + " " + list[i].STUDENT.PERSON.Other_Name;
attendance.Registration_Number = list[i].STUDENT.Matric_Number;
attendance.Event_Type = list[i].EVENT.EVENT_TYPE.Name;
if (list[i].EVENT.COURSE != null)
{
attendance.Course_Hall = list[i].EVENT.COURSE.Name;
}
else if (list[i].EVENT.HALL != null)
{
attendance.Course_Hall = list[i].EVENT.HALL.Name;
}
else
{
attendance.Course_Hall = "";
}
attendance.Location = list[i].EVENT.LOCATION.Name;
attendance.Date = list[i].EVENT.Date.ToLongDateString();
attendance.Time_Taken = list[i].Time_Taken.ToLongTimeString();
attendance.Status = list[i].ATTENDANCE_STATUS.Name;
sort.Add(attendance);
}
gv.DataSource = sort;
string caption = "Attendnace Report";
if (list != null && list.Count > 0)
{
caption = "Attendnace Report for " + list.FirstOrDefault().EVENT.DEPARTMENT.Name + ". " + list.FirstOrDefault().EVENT.LEVEL.Name + ". Session: " +
list.FirstOrDefault().EVENT.SESSION.Name;
}
gv.Caption = caption.ToUpper();
gv.DataBind();
string filename = caption.Replace("\\", "") + ".xls";
return(new DownloadFileActionResult(gv, filename));
}
else
{
Response.Write("No data available for download");
Response.End();
return(new JavaScriptResult());
}
}
}
catch (Exception ex)
{
SetMessage("Error! " + ex.Message, Message.Category.Error);
}
return(RedirectToAction("ViewAttendance", "Event", new { Area = "Admin", eventId = eventId }));
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new AttendanceLogic().SelectForAttendanceReport(DateTime.Today);
int present = Convert.ToInt32(dt.Rows[0][1]);
int absent = Convert.ToInt32(dt.Rows[1][1]);
lblPResentPerc.Text = ((float)present * 100) / ((float)present + absent) + "";
lblPResentPerc.Attributes.Add("Present", present.ToString());
lblPResentPerc.Attributes.Add("Absent", absent.ToString());
DataTable dt1 = new InvoiceLogic().SelectForBestOrder();
bestOrd.Text = dt1.Rows[0]["ProductName"].ToString();
totalAmt.Text = dt1.Rows[0]["GrandTotal"].ToString();
txtCustomer.Text = dt1.Rows[0]["CustomerName"].ToString();
string dp = dt1.Rows[0]["ProductImage"].ToString();
String[] arr = dp.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries);
proimg.Src = arr[arr.Length - 1];
DataTable dt2 = new InvoiceLogic().SelectForRevenue();
txtTotIncome.Text = dt2.Rows[0]["TotalIncome"].ToString();
DataTable dt4 = new InvoiceLogic().SelectIndividualInvoiceAmount();
string s = "";
for (int i = 0; i < dt4.Rows.Count; i++)
{
s += dt4.Rows[i]["GrandTotal"] + ",";
}
s = "[" + s.TrimEnd(',') + "]";
individualInvoiceAmount.Attributes.Add("data-data", s);
DataTable dt3 = new ProductLogic().SelectBestProduct();
OrderNumber.Text = dt3.Rows[0]["Total"].ToString() + " Orders";
string dp1 = dt3.Rows[0]["DesignFiles"].ToString();
String[] arr1 = dp1.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries);
topProimg.Src = arr1[arr1.Length - 1];
ProName.Text = dt3.Rows[0]["Name"].ToString();
DataTable dt5 = new InvoiceLogic().SelectTotalSale2();
Repeater2.DataSource = dt5;
Repeater2.DataBind();
DataTable dt6 = new InventoryLogic().SelectRawStock();
Repeater1.DataSource = dt6;
Repeater1.DataBind();
CustomerLogic CL = new CustomerLogic();
Repeater3.DataSource = CL.SelectForReport1();
Repeater3.DataBind();
TransitionLogic ol = new TransitionLogic();
Repeater9.DataSource = ol.SelectProductStatus1(DateTime.Today);
Repeater9.DataBind();
TransitionLogic ol2 = new TransitionLogic();
Repeater4.DataSource = ol2.SelectOrderStatus1(DateTime.Today);
Repeater4.DataBind();
}
public AttendanceController()
{
_attendanceLogic = new AttendanceLogic();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["EmployeeID"] == null)
{
Response.Redirect("login.aspx");
}
if (!IsPostBack)
{
Session["LastLink"] = Request.Url.PathAndQuery;
}
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
Label1.Text = e1.Name;
Image1.ImageUrl = e1.Photo;
if (e1.Designation.Equals("MANAGING DIRECTOR"))
{
MDDiv.Visible = true;
}
else if (e1.Designation.Equals("MARKETING MANAGER"))
{
MarketingDiv.Visible = true;
}
else if (e1.Designation.Equals("MARKETING EMPLOYEE"))
{
MarketingDiv.Visible = true;
}
else if (e1.Designation.Equals("DESIGNER"))
{
DesignerDiv.Visible = true;
}
else if (e1.Designation.Equals("COMERCIAL MANAGER"))
{
ComercialDiv.Visible = true;
}
else if (e1.Designation.Equals("COMERCIAL EMPLOYEE"))
{
ComercialDiv.Visible = true;
}
else if (e1.Designation.Equals("STOCK MANAGER"))
{
StockDiv.Visible = true;
}
else if (e1.Designation.Equals("STOCK EMPLOYEE"))
{
StockDiv.Visible = true;
}
else if (e1.Designation.Equals("PRODUCTION MANAGER"))
{
ProDiv.Visible = true;
}
else if (e1.Designation.Equals("PRODUCTION EMPLOYEE"))
{
ProDiv.Visible = true;
}
else if (e1.Designation.Equals("HR MANAGER"))
{
HRDiv.Visible = true;
}
else if (e1.Designation.Equals("HR EMPLOYEE"))
{
HRDiv.Visible = true;
}
else if (e1.Designation.Equals("EMPLOYEE"))
{
EmpDiv.Visible = true;
}
else if (e1.Designation.Equals("CHAIRMAN"))
{
MDDiv.Visible = true;
}
else if (e1.Designation.Equals("ACCOUNTATANT"))
{
AccDiv.Visible = true;
}
DataTable dt = new AttendanceLogic().SelectForAttendanceReport(DateTime.Today);
float present = Convert.ToSingle(dt.Rows[0][1]);
float absent = Convert.ToSingle(dt.Rows[1][1]);
lblPResentPerc.Text = (present * 100) / (present + absent) + "";
attendanceperc.Attributes["aria-valuenow"] = (present * 100) / (present + absent) + "";
attendanceperc.Attributes["style"] = "width: " + ((present * 100) / (present + absent)) + "%";
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["EmployeeID"] == null)
{
Response.Redirect("login.aspx");
}
if (!IsPostBack)
{
Session["LastLink"] = Request.Url.PathAndQuery;
}
EmployeeLogic el = new EmployeeLogic();
Employee e1 = el.SelectByID(Convert.ToInt32(Session["EmployeeID"]));
Label1.Text = e1.Name;
Image1.ImageUrl = e1.Photo;
if (e1.Designation.Equals("MANAGING DIRECTOR"))
{
MDDiv.Visible = true;
}
else if (e1.Designation.Equals("MARKETING MANAGER"))
{
MarketingDiv.Visible = true;
}
else if (e1.Designation.Equals("MARKETING EMPLOYEE"))
{
MarketingDiv.Visible = true;
}
else if (e1.Designation.Equals("DESIGNER"))
{
DesignerDiv.Visible = true;
}
else if (e1.Designation.Equals("COMERCIAL MANAGER"))
{
ComercialDiv.Visible = true;
}
else if (e1.Designation.Equals("COMERCIAL EMPLOYEE"))
{
ComercialDiv.Visible = true;
}
else if (e1.Designation.Equals("STOCK MANAGER"))
{
StockDiv.Visible = true;
}
else if (e1.Designation.Equals("STOCK EMPLOYEE"))
{
StockDiv.Visible = true;
}
else if (e1.Designation.Equals("PRODUCTION MANAGER"))
{
ProDiv.Visible = true;
}
else if (e1.Designation.Equals("PRODUCTION EMPLOYEE"))
{
ProDiv.Visible = true;
}
else if (e1.Designation.Equals("HR MANAGER"))
{
HRDiv.Visible = true;
}
else if (e1.Designation.Equals("HR EMPLOYEE"))
{
HRDiv.Visible = true;
}
else if (e1.Designation.Equals("EMPLOYEE"))
{
EmpDiv.Visible = true;
}
else if (e1.Designation.Equals("CHAIRMAN"))
{
MDDiv.Visible = true;
}
else if (e1.Designation.Equals("ACCOUNTATANT"))
{
AccDiv.Visible = true;
}
DataTable dt = new AttendanceLogic().SelectForAttendanceReport(DateTime.Today);
float present = Convert.ToSingle(dt.Rows[0][1]);
float absent = Convert.ToSingle(dt.Rows[1][1]);
lblPResentPerc.Text = (present * 100) / (present + absent)+"";
attendanceperc.Attributes["aria-valuenow"] = (present * 100) / (present + absent) + "";
attendanceperc.Attributes["style"] = "width: "+((present * 100) / (present + absent)) + "%";
}
public ActionResult DownloadSemesterAttendance(string attendanceId)
{
EventViewModel viewModel = (EventViewModel)TempData["ViewModel"];
if (viewModel == null)
{
return(null);
}
try
{
if (!string.IsNullOrEmpty(attendanceId))
{
long myAttendnaceId = Convert.ToInt64(Utility.Decrypt(attendanceId));
EventLogic eventLogic = new EventLogic();
StudentLevelLogic studentLevelLogic = new StudentLevelLogic();
AttendanceLogic attendanceLogic = new AttendanceLogic();
//ATTENDANCE myAttendnace = attendanceLogic.GetEntitiesBy(s => s.Event_Id == myAttendnaceId).LastOrDefault();
//if (myAttendnace == null)
//{
// return null;
//}
List <STUDENT_LEVEL> studentLevels = new List <STUDENT_LEVEL>();
studentLevels = studentLevelLogic.GetEntitiesBy(s => s.Department_Id == viewModel.Department.Id && s.Level_Id == viewModel.Level.Id && s.Programme_Id == viewModel.Programme.Id &&
s.Session_Id == viewModel.Session.Id);
List <ATTENDANCE> masterAttendance = new List <ATTENDANCE>();
for (int i = 0; i < studentLevels.Count; i++)
{
if (viewModel.EventType.Id == (int)EventTypes.Lecture && viewModel.Course != null && viewModel.Course.Id > 0)
{
ATTENDANCE attendance = ProcessCourseAttendance(viewModel.Course, studentLevels[i].STUDENT);
if (attendance != null)
{
attendance.STUDENT = studentLevels[i].STUDENT;
attendance.EVENT = eventLogic.GetEntitiesBy(e => e.Course_Id == viewModel.Course.Id).LastOrDefault();
masterAttendance.Add(attendance);
}
}
else if (viewModel.EventType.Id == (int)EventTypes.HallAttendance && viewModel.Hall != null && viewModel.Hall.Id > 0)
{
ATTENDANCE attendance = ProcessHallAttendance(viewModel.Hall, studentLevels[i].STUDENT);
if (attendance != null)
{
attendance.STUDENT = studentLevels[i].STUDENT;
attendance.EVENT = eventLogic.GetEntitiesBy(e => e.Hall_Id == viewModel.Hall.Id).LastOrDefault();
masterAttendance.Add(attendance);
}
}
else
{
ATTENDANCE attendance = ProcessOtherAttendance(viewModel.EventType, studentLevels[i].STUDENT);
if (attendance != null)
{
attendance.STUDENT = studentLevels[i].STUDENT;
attendance.EVENT = eventLogic.GetEntitiesBy(e => e.Event_Type_Id == viewModel.EventType.Id).LastOrDefault();
masterAttendance.Add(attendance);
}
}
}
GridView gv = new GridView();
DataTable ds = new DataTable();
if (masterAttendance.Count > 0)
{
List <ATTENDANCE> list = masterAttendance.OrderBy(p => p.STUDENT.Matric_Number).ToList();
List <SemesterAttendanceModel> sort = new List <SemesterAttendanceModel>();
for (int i = 0; i < list.Count; i++)
{
SemesterAttendanceModel attendance = new SemesterAttendanceModel();
attendance.SN = (i + 1);
attendance.Name = list[i].STUDENT.PERSON.Last_Name + " " + list[i].STUDENT.PERSON.First_Name + " " + list[i].STUDENT.PERSON.Other_Name;
attendance.Registration_Number = list[i].STUDENT.Matric_Number;
attendance.Event_Type = list[i].EVENT.EVENT_TYPE.Name;
if (list[i].EVENT.COURSE != null)
{
attendance.Course_Hall = list[i].EVENT.COURSE.Name;
}
else if (list[i].EVENT.HALL != null)
{
attendance.Course_Hall = list[i].EVENT.HALL.Name;
}
else
{
attendance.Course_Hall = "";
}
attendance.Percentage = list[i].Percentage.ToString() + "%";
attendance.Status = list[i].IsEligible ? "Eligible" : "Not Eligible";
sort.Add(attendance);
}
gv.DataSource = sort;
string caption = "Attendnace Report";
if (list != null && list.Count > 0)
{
caption = "Attendnace Report for " + list.FirstOrDefault().EVENT.DEPARTMENT.Name + ". " + list.FirstOrDefault().EVENT.LEVEL.Name + ". Session: " +
list.FirstOrDefault().EVENT.SESSION.Name;
}
gv.Caption = caption.ToUpper();
gv.DataBind();
string filename = caption.Replace("\\", "") + ".xls";
return(new DownloadFileActionResult(gv, filename));
}
else
{
Response.Write("No data available for download");
Response.End();
return(new JavaScriptResult());
}
}
}
catch (Exception ex)
{
SetMessage("Error! " + ex.Message, Message.Category.Error);
}
return(RedirectToAction("SemesterAttendance", "Event", new { Area = "Admin" }));
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new AttendanceLogic().SelectForAttendanceReport(DateTime.Today);
int present = Convert.ToInt32(dt.Rows[0][1]);
int absent = Convert.ToInt32(dt.Rows[1][1]);
lblPResentPerc.Text = ((float)present * 100) / ((float)present + absent) + "";
lblPResentPerc.Attributes.Add("Present", present.ToString());
lblPResentPerc.Attributes.Add("Absent", absent.ToString());
DataTable dt1 = new InvoiceLogic().SelectForBestOrder();
bestOrd.Text = dt1.Rows[0]["ProductName"].ToString();
totalAmt.Text = dt1.Rows[0]["GrandTotal"].ToString();
txtCustomer.Text = dt1.Rows[0]["CustomerName"].ToString();
string dp = dt1.Rows[0]["ProductImage"].ToString();
String[] arr = dp.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries);
proimg.Src = arr[arr.Length - 1];
DataTable dt2 = new InvoiceLogic().SelectForRevenue();
txtTotIncome.Text = dt2.Rows[0]["TotalIncome"].ToString();
DataTable dt4 = new InvoiceLogic().SelectIndividualInvoiceAmount();
string s = "";
for (int i = 0; i < dt4.Rows.Count; i++)
{
s += dt4.Rows[i]["GrandTotal"] + ",";
}
s = "[" + s.TrimEnd(',') + "]";
individualInvoiceAmount.Attributes.Add("data-data", s);
DataTable dt3 = new ProductLogic().SelectBestProduct();
OrderNumber.Text = dt3.Rows[0]["Total"].ToString() + " Orders";
string dp1 = dt3.Rows[0]["DesignFiles"].ToString();
String[] arr1 = dp1.Split(new String[] { "#,#" }, StringSplitOptions.RemoveEmptyEntries);
topProimg.Src = arr1[arr1.Length - 1];
ProName.Text = dt3.Rows[0]["Name"].ToString();
DataTable dt5 = new InvoiceLogic().SelectTotalSale2();
Repeater2.DataSource = dt5;
Repeater2.DataBind();
DataTable dt6 = new InventoryLogic().SelectRawStock();
Repeater1.DataSource = dt6;
Repeater1.DataBind();
CustomerLogic CL = new CustomerLogic();
Repeater3.DataSource = CL.SelectForReport1();
Repeater3.DataBind();
TransitionLogic ol = new TransitionLogic();
Repeater9.DataSource = ol.SelectProductStatus1(DateTime.Today);
Repeater9.DataBind();
TransitionLogic ol2 = new TransitionLogic();
Repeater4.DataSource = ol2.SelectOrderStatus1(DateTime.Today);
Repeater4.DataBind();
}
