public ActionResult Create(AttendenceViewModel viewModel)
{
if (ModelState.IsValid)
{
try
{
Attendence attendence = Mapper.Map <Attendence>(viewModel);
attendence.Id = Guid.NewGuid();
attendence.CompanyId = CompanyCookie.CompId;
_dbContext.Attendences.Add(attendence);
_dbContext.SaveChanges();
Salary salary = new Salary();
salary.CompanyId = CompanyCookie.CompId;
salary.Date = viewModel.Date;
_dbContext.Salary.Add(salary);
_dbContext.SaveChanges();
TempData["MessageToClientSuccess"] = "Attendence Date SuccessFully Created";
}
catch (Exception ex)
{
// Log4NetHelper.Log(String.Format("Cannot Create Deparment {0} ", viewModel.Id), LogLevel.ERROR, "Department", viewModel.Id, User.Identity.Name, ex);
var msg = new ModelStateException(ex);
TempData["MessageToClientError"] = msg;
}
return(RedirectToAction("Index"));
}
ViewBag.CompanyId = new SelectList(_dbContext.Companyies, "Id", "CompanyName");
return(View(viewModel));
}
public void Index_CalledWithLogInUser_ReturnGigsAndAttendances()
{
var gig1 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), _genre.Id);
var gig2 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), _genre.Id);
var gigs = new List <Gig>();
gigs.Add(gig1);
gigs.Add(gig2);
_context.Gigs.AddRange(gigs);
_context.SaveChanges();
_context.Entry(gig1).Reload();
var attendance = new Attendence()
{
AttendeeId = _user.Id,
GigId = gig1.Id
};
_context.Attendences.Add(attendance);
_context.SaveChanges();
var result = _controller.Index();
(result.ViewData.Model as GigsViewModel).Attendences.Should().HaveCount(1);
(result.ViewData.Model as GigsViewModel).upcomingGigs.Should().HaveCount(2);
}
public DataTable GetDatatableAttendence(DO_Attendence objAttendence, Attendence flag)
{
//For Retriving Record For Attendence
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("Scrl_AddEditDelAttendence", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
da.SelectCommand.Parameters.Add("@RegistrationId", SqlDbType.BigInt).Value = objAttendence.RegistrationId;
da.SelectCommand.Parameters.Add("@CourseId", SqlDbType.BigInt).Value = objAttendence.CourseId;
da.SelectCommand.Parameters.Add("@ClassId", SqlDbType.BigInt).Value = objAttendence.ClassId;
da.SelectCommand.Parameters.Add("@SubjectId", SqlDbType.BigInt).Value = objAttendence.Subjectid;
da.SelectCommand.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objAttendence.AddedBy;
da.SelectCommand.Parameters.Add("@UserTypeId", SqlDbType.BigInt).Value = objAttendence.UserTypeID;
da.SelectCommand.Parameters.Add("@AttendenceDate", SqlDbType.DateTime).Value = objAttendence.AttendenceDate;
da.SelectCommand.Parameters.Add("@yearPaseed", SqlDbType.BigInt).Value = objAttendence.YearPassed;
da.SelectCommand.Parameters.Add("@MonthPassed", SqlDbType.BigInt).Value = objAttendence.MonthPassed;
da.Fill(dt);
co.CloseConnection(conn);
return(dt);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,date,attendenceState,Notes,NewRegisteredStudentId")] Attendence attendence)
{
if (id != attendence.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(attendence);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AttendenceExists(attendence.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["NewRegisteredStudentId"] = new SelectList(_context.NewRegisteredStudent, "Id", "CallingProgram", attendence.NewRegisteredStudentId);
return(View(attendence));
}
public JsonResult SubmitAttendence(MyModelWithList details)
{
try
{
foreach (var s in details.MyList)
{
var csid = db.ClassSections.Include("Class").Include("Section").Single(i => i.Class.ClassId == s.ClassId && i.Section.SectionId == s.SectionId);
Attendence at = new Attendence();
at.AttendenceId = 0;
at.ClassSectionId = csid.ClassSectionId;
at.StudentId = s.StudentId;
at.Status = s.Status.ToString();
at.Date = s.Date;
db.Attendence.Add(at);
db.SaveChanges();
}
return(Json("Successfully Submit", JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
ViewBag.ERROR = e.Message.ToString();
return(Json(e.Message.ToString()));
}
}
public JsonResult studentPay(string sId, string groupId, string amount)
{
int sid = int.Parse(sId);
int grpID = int.Parse(groupId);
double sum = float.Parse(amount);
using (FastAndEasyEntities db = new FastAndEasyEntities())
{
int? levelId = db.Groups.Where(g => g.Id == grpID).FirstOrDefault().Level;
double?cost = db.Levels.Where(l => l.Id == levelId).FirstOrDefault().Price;
var x = sum / cost;
for (int i = 1; i <= x; i++)
{
Attendence a = new Attendence();
a.Student = sid;
db.Attendences.Add(a);
db.SaveChanges();
ModelState.Clear();
}
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
public IHttpActionResult PutAttendence(int id, Attendence attendence)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != attendence.Id)
{
return(BadRequest());
}
db.Entry(attendence).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AttendenceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: /Attendence/Details/5
public ActionResult Details(int?id)
{
try
{
if (Session["Email"] == null)
{
return(View("Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Attendence attendenceregister = db.Attendence.Find(id);
if (attendenceregister == null)
{
return(HttpNotFound());
}
return(View(attendenceregister));
}
catch (Exception e)
{
ViewBag.ERROR = e.Message.ToString();
return(View("ErrorPage"));
}
}
public static Attendence GetAttendenceByID(int id)
{
Attendence attendence = new Attendence();
SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider();
attendence = sqlAttendenceProvider.GetAttendenceByID(id);
return attendence;
}
public ActionResult createajax(string[] number1, string[] leave1, string[] reason1, string[] arrid1)
{
//return Content(number+" "+leave);
bool[] checkbool = new bool[reason1.Length];
for (int i = 0; i < arrid1.Length; i++)
{
if (arrid1[i] == "1")
{
checkbool[i] = true;
}
else
{
checkbool[i] = false;
}
}
Attendence at = new Attendence();
for (int i = 0; i < number1.Length; i++)
{
at.atten_leave_type_id = Convert.ToInt32(leave1[i]);
at.atten_emp_id = Convert.ToInt32(number1[i]);
at.atten_status = checkbool[i];
at.atten_reason = reason1[i];
at.atten_date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.Attendences.Add(at);
db.SaveChanges();
}
return(Content(number1.Length.ToString()));
}
public ActionResult GiveAttend(int id)
{
Attendence at = Atservice.Get(id);
;
if (at.Date.ToString("dd.MM.yyy") == DateTime.Now.ToString("dd.MM.yyy"))
{
at.Attend = 0;
Atservice.Update(at);
}
else
{
if (at.Attend == 0)
{
at.Attend = 1;
at.AttendCounter++;
at.Date = DateTime.Now;
}
else if (at.Attend == 1)
{
at.Attend = 0;
at.AttendCounter--;
}
Atservice.Update(at);
}
return(RedirectToAction("Attendence", new { id = Convert.ToInt32(Session["AtID"]) }));
}
public static void PostListOfAttendenceState(List <AttendenceViewModel> attendenceViewModel)
{
using (var context = new FinalSchool())
{
var CN = attendenceViewModel[0].CourseName;
var courseAtt = context.Courses.FirstOrDefault(x => x.Name == CN);
var te = attendenceViewModel[0].TeacherSNN;
Teacher teacher = context.Teachers.FirstOrDefault(x => x.TeacherId == te);
var session = new Session
{
CourseId = courseAtt.CourseId,
StartDate = DateTime.Now,
TeacherId = teacher.TeacherId,
};
context.Sessions.Add(session);
context.SaveChanges();
foreach (var item in attendenceViewModel)
{
var attendence = new Attendence()
{
StudentId = item.StudentSNN,
IsAttended = item.IsAttended,
SessionId = session.SessionId,
};
context.Attendences.Add(attendence);
}
context.SaveChanges();
}
}
public static void ChangeAttendenceState(AttendenceViewModel attendenceViewModel)
{
using (var context = new FinalSchool())
{
var studentAtt = context.Students.FirstOrDefault(x => x.StudentId == attendenceViewModel.StudentSNN);
var courseAtt = context.Courses.FirstOrDefault(x => x.Name == attendenceViewModel.CourseName);
var teacher = context.Teachers.FirstOrDefault(x => x.FName == attendenceViewModel.TeacherName);
var session = new Session
{
Course = courseAtt,
CourseId = courseAtt.CourseId,
StartDate = DateTime.Now,
Teacher = teacher,
TeacherId = teacher.TeacherId,
};
context.Sessions.Add(session);
context.SaveChanges();
var attendence = new Attendence()
{
Student = studentAtt,
StudentId = studentAtt.StudentId,
IsAttended = attendenceViewModel.IsAttended,
Session = session,
SessionId = session.SessionId,
};
context.Attendences.Add(attendence);
context.SaveChanges();
}
}
public bool updateAttendence(FormCollection collection, int id, Attendence atd)
{
try
{
string attendence = collection["present"];
atd.time_in_ = TimeSpan.Parse(collection["timeIn"]);
atd.time_out = TimeSpan.Parse(collection["timeOut"]);
if (attendence == "present")
{
atd.present = 1;
atd.absent = 0;
}
else
{
atd.absent = 1;
atd.present = 0;
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
// GET: Attendences/Edit/5
public ActionResult Edit(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Attendence attendence = db.GetAttendence(id);
if (attendence == null)
{
return(HttpNotFound());
}
ViewBag.StudentID = new SelectList((from student in db.GetStudent()
select new
{
StudentID = student.StudentID,
StudentName = student.FirstName + " " + student.LastName
}), "StudentID", "StudentName", attendence.StudentID);
ViewBag.TimetableID = new SelectList((from timetable in db.GetModuleTimetable()
select new
{
TimetableID = timetable.TimeTableId,
TimetableValue = timetable.ModuleName + " " + timetable.Day + " " + timetable.ClassStartTime + " " + timetable.ClassEndTime
}), "TimetableID", "TimetableValue", attendence.TimetableID);
return(View(attendence));
}
public IHttpActionResult PostParticipant(Attendence item /*, HttpPostedFileBase file*/)
{
//Dictionary<string, object> dict = new Dictionary<string, object>();
// string str = files(file);
// item.Img = str;
try
{
var httpRequest = HttpContext.Current.Request;
item = repository.Add(item);
repository.Save();
//var response = Request.CreateResponse<Attendence>(HttpStatusCode.Created, item);
//string uri = Url.Link("DefaultApi", new { id = item.Id });
//response.Headers.Location = new Uri(uri);
//return Ok();
var data = repository.GetAll();
if (data == null)
{
return(NotFound());
}
return(Ok(data));
}
catch
{
return(InternalServerError());
}
}
public void MyCalendar_CalledCorrectly_ReturnListOfGigs()
{
var genre = _context.Genres.First();
var gig1 = new Gig(_user.Id, "-", DateTime.Now.AddDays(1), genre.Id);
_context.Gigs.Add(gig1);
var attendence1 = new Attendence
{
GigId = gig1.Id,
AttendeeId = _user.Id
};
_context.Attendences.Add(attendence1);
_context.SaveChanges();
var gig2 = new Gig(_user.Id, "-", DateTime.Now.AddDays(2), genre.Id);
_context.Gigs.Add(gig2);
var attendence2 = new Attendence
{
GigId = gig2.Id,
AttendeeId = _user.Id
};
_context.Attendences.Add(attendence2);
_context.SaveChanges();
var result = _controller.MyCalendar() as ViewResult;
var viewModel = result.ViewData.Model as GigsViewModel;
var list = viewModel.upcomingGigs;
list.Should().HaveCount(2);
}
public IHttpActionResult Attend(AttedenceDto dto)
{
#region Avoid Duplicate Attendence
var attenderId = User.Identity.GetUserId();
var passedparam2 = dto.passedParam2; // just playing with passed param
var passedparam3 = dto.passedParam3; // just playing with passed param
//var attenderId = "50cbfce6-8cf3-4e17-a885-81375da81a43"; //for testing
var isDuplicate = dbContext.Attendences.Any(a => a.AttenderId == attenderId && a.GigId == dto.GigId);
if (isDuplicate)
{
return(BadRequest("You have already Attended This Gig"));
}
#endregion
var attendence = new Attendence()
{
GigId = dto.GigId,
AttenderId = User.Identity.GetUserId()
//AttenderId = "52f143fb-381c-484c-af5e-ffcb562a51b7"
//"50cbfce6-8cf3-4e17-a885-81375da81a43"
};
dbContext.Attendences.Add(attendence);
dbContext.SaveChanges();
return(Ok());
}
public async Task UpdateAttendance(string id, string name, System.DateTime date)
{
System.Console.WriteLine("Update Attedence: id:{0} date:{1}", id, date);
var client = new HttpClient();
var attendence = new Attendence
{
Date = date.ToString("MMddyy"),
Id = id,
Name = name
};
var url = CreateAttendenceApiUrl + id;
var settings = new JsonSerializerSettings();
settings.ContractResolver = new LowercaseContractResolver();
var json = JsonConvert.SerializeObject(attendence, Formatting.Indented, settings);
System.Console.WriteLine("updating :" + json);
var result = await client.PostAsync(url, new StringContent(json, System.Text.Encoding.UTF8, "application/json"));
System.Console.WriteLine(result.StatusCode);
if (result.StatusCode != HttpStatusCode.OK)
{
throw new System.Exception("Error:" + result.RequestMessage);
}
await Task.FromResult(0);
}
public ActionResult CheckAttend(Attendence att)
{
var user = db.user.SingleOrDefault(c => c.id == att.user_id);
Appointments_ app = db.Appointments_.SingleOrDefault(c => c.id == att.app_id);
if (user.count >= 3)
{
user.block = true;
app.state = "blocked";
}
else
{
if (att.check.Equals("0"))
{
app.state = "unatt";
user.count = user.count + 1;
}
else if (att.check.Equals("1"))
{
app.state = "att";
}
}
db.SaveChanges();
return(RedirectToAction("CheckAttend"));
}
public ActionResult AddStudentToSection(StudentSection sec)
{
if (ModelState.IsValid)
{
STCservice.Insert(sec);
Student ats = Stservice.Get(sec.StuId);
Section sc = Sservice.Get(sec.SecId);
Attendence ast = new Attendence();
ast.StudentId = ats.StuId;
ast.SecId = sc.SecId;
ast.Attend = 0;
ast.AttendCounter = 0;
int val = Convert.ToInt32(sc.CourseId);
ast.CourseId = val;
ast.Date = DateTime.Now;
Atservice.Insert(ast);
Grade gr = new Grade();
gr.SecId = sc.SecId;
gr.StuId = ats.StuId;
gr.grade = 0;
grservice.Insert(gr);
return(RedirectToAction("Index"));
}
else
{
return(View(sec));
}
}
//Actions performed on log out
public async Task <ActionResult> LogOut()
{
using (HttpClient httpclient = new HttpClient())
{
Attendence attendence = new Attendence {
Date = DateTime.Now.Date, Emp_Id = Session["id"].ToString(), LogOutTime = DateTime.Now.ToShortTimeString(), LogInTime = Session["LoginTime"].ToString()
};
UriBuilder builder2 = new UriBuilder(ConfigurationManager.AppSettings["baseUrl"]);
var json2 = JsonConvert.SerializeObject(attendence);
var content2 = new StringContent(json2, Encoding.UTF8, "application/json");
var resultpost2 = await httpclient.PostAsync(builder2.Uri + "/UpdateAttendence", content2);
if (resultpost2.IsSuccessStatusCode)
{
Session["username"] = null;
Session["token"] = null;
Session["role"] = null;
Session["firstname"] = null;
Session["dept"] = null;
Session["id"] = null;
Session["LoginTime"] = null;
return(RedirectToAction("Index", "Home"));
}
else
{
return(RedirectToAction("Index", "LoggedIn"));
}
}
}
public async Task <List <AttendenceInfoDto> > GetAttendenceInfoForInstructor(string lectureCode)
{
List <int> completedWeeks = await _attendenceRepository.GetCompletedAttendenceWeekInfo(lectureCode);
List <AttendenceInfoDto> attendenceInfos = new List <AttendenceInfoDto>();
AttendenceImage attendenceImage;
string image_url;
for (int i = 1; i <= 14; i++)
{
Attendence attendence = new Attendence();
attendence.week = i;
attendence.status = completedWeeks.Contains(i) ?
AttendenceConstants.COMPLETED :
AttendenceConstants.NOT_COMPLETED;
attendenceImage = await _attendenceImageRepository.GetAttendenceImage(lectureCode, attendence.week);
image_url = attendenceImage != null ? attendenceImage.image_url : null;
attendenceInfos.Add(new AttendenceInfoDto(attendence, image_url));
}
return(attendenceInfos);
}
public JsonResult editAttendance(string id, string aDate, string presence)
{
int x = int.Parse(id);
if (Request.IsAjaxRequest())
{
FastAndEasyEntities db = new FastAndEasyEntities();
Attendence a = new Attendence();
a = db.Attendences.Find(x);
a.Date = DateTime.Parse(aDate);
if (presence == "-")
{
a.Reasonable = "No";
db.Entry(a).Property(at => at.Reasonable).IsModified = true;
}
a.Present = presence;
db.Entry(a).Property(at => at.Date).IsModified = true;
db.Entry(a).Property(at => at.Present).IsModified = true;
db.SaveChanges();
ModelState.Clear();
return(new JsonResult {
Data = " ", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "error", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
// By Default int is expected in url not in body
// so decorate it with [FromBody]
// To avoid this, use DTOs
public IHttpActionResult Attend(AttendeceDto dto)
{
var userId = User.Identity.GetUserId();
// Now we can use GetAttendence here & Delete method
//if (_context.Attendences.Any(
// a => a.AttendeeId == userId
// && a.GigId == dto.GigId)
// )
// return BadRequest("The attendence already exists");
if (_unitOfWork.Attendences.GetAttendence(userId, dto.GigId) != null)
{
return(BadRequest("The attendence already exists"));
}
Attendence attendence = new Attendence
{
GigId = dto.GigId,
AttendeeId = userId
};
_unitOfWork.Attendences.Add(attendence);
_unitOfWork.Complete();
return(Ok());
}
public int Delete(int id)
{
Attendence f = this.context.Attendence.SingleOrDefault(x => x.AttId == id);
this.context.Attendence.Remove(f);
return(this.context.SaveChanges());
}
public ActionResult DeleteConfirmed(int id)
{
Attendence attendence = _dbContext.Attendences.Find(id);
_dbContext.Attendences.Remove(attendence);
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Attendence/Delete/5
public ActionResult Delete(Attendence staffId)
{
var del = payroll.Attendences.Where(x => x.id == staffId.id).FirstOrDefault();
payroll.Attendences.Remove(del);
payroll.SaveChanges();
return(RedirectToAction("Attendence"));
}
public ActionResult Index()
{
int ab = Convert.ToInt32(Session["id"]);
int bc = Convert.ToInt32(Session["Designation"]);
if (ab != 0 && bc == 1)
{
//return View(db.Attendences.ToList());
System.DateTime todaydate = new System.DateTime(System.DateTime.Today.Ticks);
DateTime date = Convert.ToDateTime(todaydate.ToString("dd/MM/yyyy"));
//var Atteendancedate = db.Attendences.Where(y => y.AttendenceDate == date).FirstOrDefault();
List <Attendence> list = new List <Attendence>();
var attendanceinfo = db.Attendences.ToList();
foreach (var row in attendanceinfo)
{
DateTime att = Convert.ToDateTime(row.AttendenceDate);
//var Atteendancedate = db.Attendences.Where(y => y.AttendenceDate == date).FirstOrDefault();
// sample s = new sample();
if (att == date)
{
Attendence a = new Attendence();
a.ClientId = Convert.ToInt32(row.ClientId);
// a.Client.ClietName = db.Clients.FirstOrDefault(x => x.ClientId == a.ClientId).ClietName;
a.EmployeeId = Convert.ToInt32(row.EmployeeId);
a.FromTime = Convert.ToDateTime(row.FromTime);
a.AttendenceStatus = Convert.ToBoolean(row.AttendenceStatus);
a.AttendenceDate = Convert.ToDateTime(row.AttendenceDate);
//Attendence.Add(a);
//db.Attendences.Add(a);
// list.Add(a);
if (row.ClientId == null)
{
int empid = Convert.ToInt32(row.EmployeeId);
Employee v = db.Employees.FirstOrDefault(y => y.EmployeeId == empid);
a.Employee = v;
// a.Employee.EmployeeName = v.EmployeeName;
list.Add(a);
}
else
{
Client client = db.Clients.FirstOrDefault(x => x.ClientId == a.ClientId);
a.Client = client;
list.Add(a);
}
}
}
ViewBag.list = list;
return(View());
}
else
{
FormsAuthentication.SignOut();
return(RedirectToAction("Login", "Login"));
}
}
public IActionResult leave(int EventId)
{
int? _userId = HttpContext.Session.GetInt32("UserId");
Attendence leave = dbContext.Attendences.FirstOrDefault(a => a.EventId == EventId && a.UserId == (int)_userId);
dbContext.Attendences.Remove(leave);
dbContext.SaveChanges();
return(RedirectToAction("success"));
}
public ActionResult Edit([Bind(Include = "AttendenceID,StudentID,TimetableID,Date,Condition")] Attendence attendence)
{
if (ModelState.IsValid)
{
db.UpdateAttendence(attendence);
return(RedirectToAction("Index"));
}
return(View(attendence));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Attendence attendence = new Attendence();
attendence.UserID = ddlAccountingUser.SelectedValue;
attendence.InOutTime = DateTime.Parse(txtInOutTime.Text);
attendence.ExtraField1 = "";
attendence.ExtraFileld2 = "";
int resutl = AttendenceManager.InsertAttendence(attendence);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Attendence attendence = new Attendence();
attendence.UserID = ddlAccountingUser.SelectedValue;
attendence.InOutTime = DateTime.Parse(txtInOutTime.Text);
int resutl = AttendenceManager.InsertAttendence(attendence);
showAttendenceGrid();
btnViewReport_Click(this, new EventArgs());
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Attendence attendence = new Attendence();
attendence.UserID = Int32.Parse(ddlUser.SelectedValue);
attendence.InOutTime = txtInOutTime.Text;
attendence.ExtraField1 = txtExtraField1.Text;
attendence.ExtraFileld2 = txtExtraFileld2.Text;
int resutl = AttendenceManager.InsertAttendence(attendence);
Response.Redirect("AdminAttendenceDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Attendence attendence = new Attendence();
attendence = AttendenceManager.GetAttendenceByID(Int32.Parse(Request.QueryString["attendenceID"]));
Attendence tempAttendence = new Attendence();
tempAttendence.AttendenceID = attendence.AttendenceID;
tempAttendence.UserID = Int32.Parse(ddlUser.SelectedValue);
tempAttendence.InOutTime = txtInOutTime.Text;
tempAttendence.ExtraField1 = txtExtraField1.Text;
tempAttendence.ExtraFileld2 = txtExtraFileld2.Text;
bool result = AttendenceManager.UpdateAttendence(tempAttendence);
Response.Redirect("AdminAttendenceDisplay.aspx");
}
private void showAttendenceData()
{
Attendence attendence = new Attendence();
attendence = AttendenceManager.GetAttendenceByID(Int32.Parse(Request.QueryString["attendenceID"]));
ddlUser.SelectedValue = attendence.UserID.ToString();
txtInOutTime.Text = attendence.InOutTime;
txtExtraField1.Text = attendence.ExtraField1;
txtExtraFileld2.Text = attendence.ExtraFileld2;
}
protected void btnViewReport_Click(object sender, EventArgs e)
{
List<Attendence> attendences = new List<Attendence>();
List<Attendence> attendencesTimeDuration = new List<Attendence>();
attendences = AttendenceManager.GetAllAttendencesByUserID(ddlEmployee.SelectedValue);
for (int i = 1; i < attendences.Count; i++)
{
if (((attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Days * 24 * 60) + (attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Hours * 60) + attendences[i].InOutTime.Subtract(attendences[i - 1].InOutTime).Minutes) < 1)
{
attendences.RemoveAt(i);
i--;
}
}
for (int i = 0; i < attendences.Count; i++)
{
Attendence newItem = new Attendence();
newItem = attendences[i];
newItem.InTime = attendences[i].InOutTime;
while (true)
{
if (attendences.Count > ++i)
{
if (((attendences[i].InOutTime.Subtract(newItem.InTime).Days * 24 * 60) + (attendences[i].InOutTime.Subtract(newItem.InTime).Hours * 60) + attendences[i].InOutTime.Subtract(newItem.InTime).Minutes) > 1)
{
if (newItem.InTime.Date == attendences[i].InOutTime.Date)
{
newItem.OutTime = attendences[i].InOutTime;
}
else
{
newItem.OutTime = DateTime.Parse(newItem.InTime.ToShortDateString() + " 06:00:00 PM");
i--;
}
break;
}
}
else
{
break;
}
}
if (newItem.OutTime < DateTime.Parse("21 Feb 2012")) newItem.OutTime = DateTime.Parse(newItem.InTime.ToShortDateString() + " 06:00:00 PM");
newItem.Duration = (newItem.OutTime.Subtract(newItem.InTime).Hours * 60 * 60) + (newItem.OutTime.Subtract(newItem.InTime).Minutes * 60) +newItem.OutTime.Subtract(newItem.InTime).Seconds;
//newItem.DurationDisplay = (newItem.OutTime - newItem.InTime).Hours.ToString() + " hour(s) : " + (newItem.OutTime - newItem.InTime).Minutes.ToString() + " Min(s)";
newItem.DurationDisplay = ((newItem.OutTime.Subtract(newItem.InTime).Days * 24 ) + (newItem.OutTime.Subtract(newItem.InTime).Hours)).ToString() +" hour(s) " + newItem.OutTime.Subtract(newItem.InTime).Minutes.ToString() + " Min";
attendencesTimeDuration.Add(newItem);
}
gvAttendencePerEmployee.DataSource = attendences;
gvAttendencePerEmployee.DataBind();
int lastLateDuration = attendencesTimeDuration[0].Duration;
int lastIndex = 0;
attendencesTimeDuration[0].DateDisplay = attendencesTimeDuration[0].InTime.ToString("dd MMM yyyy");
for (int i = 1; i < attendencesTimeDuration.Count; i++)
{
if (attendencesTimeDuration[i - 1].InTime.ToShortDateString() != attendencesTimeDuration[i].InTime.ToShortDateString())
{
lastIndex = i;
attendencesTimeDuration[i].DateDisplay = attendencesTimeDuration[i].InTime.ToString("dd MMM yyyy");
lastIndex = i;
}
else
{
attendencesTimeDuration[lastIndex].Duration += attendencesTimeDuration[i].Duration;
attendencesTimeDuration[i].DateDisplay = "";
}
}
for (int i = 0; i < attendencesTimeDuration.Count; i++)
{
if (attendencesTimeDuration[i].DateDisplay != "")
{
attendencesTimeDuration[i].DateDisplay += "-- [" + (attendencesTimeDuration[i].Duration / (60 * 60)).ToString() + " Hour(s) " + ((attendencesTimeDuration[i].Duration % (60 * 60)) / 60).ToString() + " Min(s)]";
}
}
gvAttendenceDuration.DataSource = attendencesTimeDuration;
gvAttendenceDuration.DataBind();
}
public static int InsertAttendence(Attendence attendence)
{
SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider();
return sqlAttendenceProvider.InsertAttendence(attendence);
}
public static bool UpdateAttendence(Attendence attendence)
{
SqlAttendenceProvider sqlAttendenceProvider = new SqlAttendenceProvider();
return sqlAttendenceProvider.UpdateAttendence(attendence);
}
public Attendence GetAttendenceFromReader(IDataReader reader)
{
try
{
Attendence attendence = new Attendence
(
(int)reader["AttendenceID"],
reader["UserID"].ToString(),
(DateTime)reader["InOutTime"]
);
try
{
attendence.UserName = reader["UserName"].ToString();
}
catch(Exception ex)
{
}
try
{
attendence.ID = reader["EmployeeID"].ToString();
}
catch (Exception ex)
{
}
return attendence;
}
catch(Exception ex)
{
return null;
}
}
public int InsertAttendence(Attendence attendence)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("COMN_InsertAttendence", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AttendenceID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@UserID", attendence.UserID );
cmd.Parameters.Add("@InOutTime", SqlDbType.DateTime).Value = attendence.InOutTime;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@AttendenceID"].Value;
}
}
public bool UpdateAttendence(Attendence attendence)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("COMN_UpdateAttendence", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AttendenceID", SqlDbType.Int).Value = attendence.AttendenceID;
cmd.Parameters.AddWithValue("@UserID", attendence.UserID);
cmd.Parameters.Add("@InOutTime", SqlDbType.DateTime).Value = attendence.InOutTime;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
