public ActionResult breakStart(User u)
{
User t = e.Users.Find(u.Id);
if (u.Id == t.Id && t.Password == u.Password)
{
Break_Times b = new Break_Times();
b.User = t;
string a = System.DateTime.Now.DayOfWeek.ToString();
b.breakcheck = 1;
b.startTime = DateTime.Now;
b.Day = a;
b.Id = u.Id;
e.Break_Times.Add(b);
e.SaveChanges();
return(RedirectToAction("details", "Home", new { u.Id }));
}
else
{
ViewBag.msg = "wrong id or pass";
}
return(View());
}
public ActionResult breakStop(User u)
{
User t = e.Users.Find(u.Id);
List <Daily_times> d = e.Daily_times.ToList();
Daily_times dd = d.FindLast(x => x.User == t);
e.Entry(dd).State = System.Data.Entity.EntityState.Modified;
dd.check = 1;
e.SaveChanges();
if (u.Id == t.Id && t.Password == u.Password)
{
List <Break_Times> g = e.Break_Times.ToList();
Break_Times b = new Break_Times();
for (int i = g.Count - 1; i >= 0; i--)
{
if (g[i].Id == u.Id)
{
b = g[i];
break;
}
}
// string a = System.DateTime.Now.DayOfWeek.ToString();
b.endTime = DateTime.Now;
//set.breaktimestart = "00";
b.Id = u.Id;
SqlCommand sql = new SqlCommand("BREAKSTOP", connection.getcon());
sql.CommandType = System.Data.CommandType.StoredProcedure;
sql.Parameters.AddWithValue("@id", b.BreakTimeID);
sql.Parameters.AddWithValue("@endtime", b.endTime);
sql.ExecuteNonQuery();
b.breakcheck = 00;
return(RedirectToAction("details", "Home", new { u.Id }));
}
else
{
ViewBag.msg = "wrong id or pass";
}
return(View());
}
public ActionResult employeeLogin(User u)
{
set.breaktimestart = "0";
//SqlCommand sql = new SqlCommand("INSERTTIME", connection.getcon());
//sql.CommandType = System.Data.CommandType.StoredProcedure;
//sql.Parameters.AddWithValue("@fk_id", u.Id);
//sql.Parameters.AddWithValue("@status", "Logged_IN");
//sql.Parameters.AddWithValue("@startTime", d.start_time );
//sql.Parameters.AddWithValue("@day",o );
//sql.ExecuteNonQuery();
List <User> list = e.Users.ToList();
User r = list.Find(p => p.Id == u.Id);
User x = e.Users.Find(r.Id);
//DateTime start = new DateTime(2018, 12, 9, 10, 0, 0); //10 o'clock
//DateTime end = new DateTime(2009, 12, 10, 12, 0, 0); //12 o'clock
//DateTime now = DateTime.Now;
List <Daily_times> list1 = e.Daily_times.ToList();
Daily_times l = list1.Find(m => m.Id == u.Id);
if (l == null)
{
l = new Daily_times();
l.Day = DateTime.Now.Day.ToString();
}
//Daily_time q = e.Daily_times.Find(l.Id);
string o = System.DateTime.Now.DayOfWeek.ToString();
if (l.Day.Trim() == o)
{
e.Entry(l).State = System.Data.Entity.EntityState.Modified;
l.start_time = DateTime.Now;
//e.Daily_times.
//e.Daily_times.Add(l);
e.SaveChanges();
}
if (x.Password == u.Password)
{
set.id = u.Id;
//Session["id"] = x.Id;
if (l.Status == "Logged-IN")
{
ViewBag.msg = "User is Already Logged in";
// Session["id"] = x.Id;
x.check = x.Id;
set.id = x.Id;
set.pass = x.Password;
Session["LoginAttempt"] = null;
RedirectToAction("employeeLogin", "Home");
}
//if (z == "Logged-IN")
//{
// ViewBag.msg = "User is Already Logged in";
// RedirectToAction("employeeLogin", "Home");
//}
else
{
if (l.User == null)
{
Session["id"] = x.Id;
set.id = x.Id;
set.pass = x.Password;
Daily_times d = new Daily_times();
string a = System.DateTime.Now.DayOfWeek.ToString();
DateTime myDate = DateTime.Parse(DateTime.Now.TimeOfDay.ToString("hh\\:mm"));
d.start_time = DateTime.Parse(myDate.TimeOfDay.ToString());
d.Month = DateTime.Now.ToString("MMM");
//d.end_time = DateTime.Now;
d.Day = a;
d.Id = u.Id;
d.Status = "Logged-IN";
Session["LoginAttempt"] = null;
Break_Times b = new Break_Times();
b.breakcheck = 0;
e.Daily_times.Add(d);
e.SaveChanges();
}
}
return(RedirectToAction("details", "Home", new { x.Id }));
}
else
{
ViewBag.msg = "Wrong password";
}
return(View());
}
