protected void btnUpdate_Click(object sender, EventArgs e)
{
shift toUpdate = new shift();
toUpdate.ShiftID = _shiftID;
toUpdate.ShiftName = txtShiftName.Text;
toUpdate.From = Convert.ToDateTime(txtShartTime.Text);
toUpdate.To = Convert.ToDateTime(txtEndTime.Text);
toUpdate.DayName = txtShiftDay.Text;
string newrecord = "ID:" + _shiftID + " From time:" + txtShartTime.Text + " to time:"
+ txtEndTime.Text + " Day name:" + txtShiftDay.Text + " Employee Name" + _selectedUserName;
Log toAppend = new Log();
toAppend.UserName = _selectedUserName;
toAppend.ManagerID = SessionManager.GetCurrentUser().EmployeId;
toAppend.OldRecord = _oldRecord;
toAppend.Type = "Update";
toAppend.NewRecord = newrecord;
ShiftUpdateFacade.UpdateShifts(toUpdate, toAppend);
bindGrid();
pnlgrid.Visible = true;
pnlEdit.Visible = false;
}
public static void InsertShifts(List <shift> toInsert)
{
for (int i = 0; i < toInsert.Count; i++)
{
shift toAdd = toInsert[i];
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ShiftName", SqlDbType.VarChar, 223),
new SqlParameter("@startTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime),
new SqlParameter("@DayOfWeek", SqlDbType.VarChar, 23),
new SqlParameter("@night", SqlDbType.Bit),
new SqlParameter("@userName", SqlDbType.VarChar, 20)
//@userName
};
parms[0].Value = toAdd.ShiftName;
parms[1].Value = toAdd.From;
parms[2].Value = toAdd.To;
parms[3].Value = toAdd.DayName;
parms[4].Value = toAdd.Night;
parms[5].Value = toAdd.UserName;
try
{
SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["interpreterLocator"].ConnectionString, CommandType.StoredProcedure, "Shift_Insert", parms);
}
catch
{
throw;
}
}
}
public static List <shift> getAllShift()
{
List <shift> toReturn = new List <shift>();
try
{
using (SqlDataReader rdr = SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["interpreterLocator"].ConnectionString, CommandType.StoredProcedure, "Shift_Get_All"))
{
while (rdr.Read())
{
shift toAdd = new shift();
toAdd.ShiftID = rdr.GetInt32(0);
toAdd.ShiftName = rdr.GetString(1);
toAdd.From = rdr.GetDateTime(2);
toAdd.To = rdr.GetDateTime(3);
toAdd.DayName = rdr.GetString(4);
toAdd.Night = rdr.GetBoolean(5);
toAdd.FirstName = rdr.GetString(6);
toAdd.LastName = rdr.GetString(7);
toReturn.Add(toAdd);
}
}
}
catch
{
throw;
}
return(toReturn);
}
public static void UpdateShiftById(shift toUpdate)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ShiftID", SqlDbType.VarChar, 223),
new SqlParameter("@ShiftName", SqlDbType.VarChar, 223),
new SqlParameter("@startTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime),
new SqlParameter("@DayOfWeek", SqlDbType.VarChar, 23),
//@userName
};
parms[0].Value = toUpdate.ShiftID;
parms[1].Value = toUpdate.ShiftName;
parms[2].Value = toUpdate.From;
parms[3].Value = toUpdate.To;
parms[4].Value = toUpdate.DayName;
try
{
SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["interpreterLocator"].ConnectionString, CommandType.StoredProcedure, "Shift_update_byShiftID", parms);
}
catch
{
throw;
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (fileUpload.HasFile)
{
if (Path.GetExtension(fileUpload.FileName) == ".xlsx")
{
ExcelPackage package = new ExcelPackage(fileUpload.FileContent);
DataTable dt = package.ToDataTable();
List <shift> toInsert = new List <shift>();
foreach (DataRow row in dt.Rows)
{
shift toAdd = new shift();
toAdd.ShiftName = row["ShiftName"].ToString();
toAdd.From = Convert.ToDateTime(row["Start_time"]);
toAdd.To = Convert.ToDateTime(row["End_time"]);
toAdd.DayName = row["DayOfWeek"].ToString();
toAdd.UserName = row["username"].ToString();
toInsert.Add(toAdd);
}
ShiftController.InsertShifts(toInsert);
bindGrid();
}
}
}
public ActionResult DeleteConfirmed(int?id, DateTime?date)
{
shift shift = db.shifts.Find(id, date);
db.shifts.Remove(shift);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "blood_camp_id,shift_date,shift_manager_username,start_hour,finish_hour,city,governorate")] shift shift)
{
if (ModelState.IsValid)
{
db.Entry(shift).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.blood_camp_id = new SelectList(db.blood_camp, "blood_camp_id", "driver_name", shift.blood_camp_id);
ViewBag.shift_manager_username = new SelectList(db.shift_manager, "username", "name", shift.shift_manager_username);
return(View(shift));
}
public ActionResult Add(shift newShift)
{
if (ModelState.IsValid)
{
shiftBL.Add(newShift);
return(RedirectToAction("Index"));
}
else
{
TempData["ErrorMessage"] = "All the Fields are Required!";
return(RedirectToAction("Add"));
}
}
// GET: Shift/Delete/5
public ActionResult Delete(int?id, DateTime?date)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
shift shift = db.shifts.Find(id, date);
if (shift == null)
{
return(HttpNotFound());
}
return(View(shift));
}
// GET: Shift/Edit/5
public ActionResult Edit(int?id, DateTime?date)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
shift shift = db.shifts.Find(id, date);
if (shift == null)
{
return(HttpNotFound());
}
ViewBag.blood_camp_id = new SelectList(db.blood_camp, "blood_camp_id", "driver_name", shift.blood_camp_id);
ViewBag.shift_manager_username = new SelectList(db.shift_manager, "username", "name", shift.shift_manager_username);
return(View(shift));
}
public void AddShift()
{
shift s = new shift();
AddShift addWindow = new AddShift();
s.end_time = DateTime.Now;
s.start_time = DateTime.Now;
// Sets the window's context and gives it the types available, that aren't deleted
addWindow.DataContext = new { shift = s, employees = dataHandler.GetEntities().employee.ToList().FindAll(type => { return !type.deleted; }) };
addWindow.ShowDialog();
try
{
dataHandler.AddOrUpdate(s);
}
catch (Exception e)
{
System.Windows.MessageBox.Show("Error: " + e.Message);
}
NotifyOfPropertyChange("Shifts");
}
public void Modify(shift s)
{
AddShift addWindow = new AddShift();
// Sets the window's context and gives it the types available, that aren't deleted
addWindow.DataContext = new { shift = s, employees = dataHandler.GetEntities().employee.ToList().FindAll(type => { return !type.deleted; }) };
if (addWindow.ShowDialog() == true)
{
try
{
dataHandler.AddOrUpdate(s);
}
catch (Exception e)
{
System.Windows.MessageBox.Show("Error: " + e.Message);
}
}
else
{
((System.Data.Entity.Infrastructure.IObjectContextAdapter)dataHandler.GetEntities()).ObjectContext.Refresh(System.Data.Entity.Core.Objects.RefreshMode.StoreWins, s);
}
NotifyOfPropertyChange("Shifts");
}
public static List <shift> getShiftbyID(int empID)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@employeeID", SqlDbType.VarChar, 223)
};
parms[0].Value = empID;
List <shift> toReturn = new List <shift>();
try
{
using (SqlDataReader rdr = SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["interpreterLocator"].ConnectionString, CommandType.StoredProcedure, "Shift_Get_by_ID", parms))
{
while (rdr.Read())
{
shift toAdd = new shift();
toAdd.ShiftID = rdr.GetInt32(0);
toAdd.ShiftName = rdr.GetString(1);
toAdd.From = rdr.GetDateTime(2);
toAdd.To = rdr.GetDateTime(3);
toAdd.DayName = rdr.GetString(4);
toAdd.Night = rdr.GetBoolean(5);
toAdd.FirstName = rdr.GetString(6);
toAdd.LastName = rdr.GetString(7);
toReturn.Add(toAdd);
}
}
}
catch
{
throw;
}
return(toReturn);
}
protected void Button1_Click(object sender, EventArgs e)
{
webtimeclockEntities db = new webtimeclockEntities();
String userID = Session["UserID"].ToString().Split(' ')[0];
//Check if userid is already in active users
//if so, is clocked in
Boolean clockedIn = (from aUser in db.activeusers
where aUser.UserID == userID
select aUser).Count() == 1;
DateTime ClockTime = DateTime.Now;
if (!clockedIn)
{
String comments = Comments.Text;
Session["ClockedIn"] = "in " + ClockTime.ToString();
Clock.Text = "Clock out";
ClockedinTime.Text = "You clocked in at " + ClockTime.ToShortTimeString();
activeuser s = new activeuser
{
UserID = userID,
Time = ClockTime,
Comments = comments
};
db.activeusers.Add(s);
db.SaveChanges();
}
else if (clockedIn)
{
Clock.Text = "Clock in";
DateTime inTime = (from aUser in db.activeusers
where aUser.UserID == userID
select aUser).Single().Time;
DateTime outTime = DateTime.Now;
TimeSpan difference = outTime - inTime;
TimeSpan roundedDifference = TimeSpan.FromMinutes(15 * Math.Ceiling((difference.TotalMinutes - 7) / 15));
ClockedinTime.Text = "You worked " + difference.ToString();
Session["ClockedIn"] = "out " + ClockTime.ToString();
//Add worked shift to the database
shift s = new shift()
{
UserID = userID,
Date = DateTime.Now,
TimeIn = inTime,
TimeOut = outTime,
TimeWorked = difference,
RoundedTimeWorked = roundedDifference,
Comments = Comments.Text
};
db.shifts.Add(s);
db.SaveChanges();
//Remove user as active user
var user = (from aUser in db.activeusers
where aUser.UserID == userID
select aUser).Single();
db.activeusers.Remove(user);
db.SaveChanges();
}
}
public override void SAVEbtn_Click(object sender, EventArgs e)
{
if (shiftnameTxt.Text == "")
{
Shiftnameerrorlabel.Visible = true;
}
else
{
Shiftnameerrorlabel.Visible = false;
}
if (NumofshiftDD.SelectedIndex == -1)
{
Numofshifterrorlabel.Visible = true;
}
else
{
Numofshifterrorlabel.Visible = false;
}
if (endTimeTxt.Text == "")
{
endTimeErrorLabel.Visible = true;
}
else
{
endTimeErrorLabel.Visible = false;
}
if (startTimeTxt.Text == "")
{
startTimeErrorLabel.Visible = true;
}
else
{
startTimeErrorLabel.Visible = false;
}
if (Numofshifterrorlabel.Visible || Shiftnameerrorlabel.Visible || startTimeErrorLabel.Visible || endTimeErrorLabel.Visible)
{
MainClass.ShowMSG("Fields with * are required ", "Required", "Error");
}
else
{
if (edit == 0)// for save data entered by user
{
try {
shift S = new shift();
if (NumofshiftDD.SelectedIndex == 0)
{
S.sh_no_of_shift = 1; /*one*/
}
else if (NumofshiftDD.SelectedIndex == 1)
{
S.sh_no_of_shift = 2; /*two*/
}
else
{
S.sh_no_of_shift = 3;/*Three*/
}
obj.sh_insertshifts(shiftnameTxt.Text, S.sh_no_of_shift, startTimeTxt.Text, endTimeTxt.Text);
obj.SubmitChanges();
MainClass.ShowMSG(shiftnameTxt.Text + " shift added successfully", "Success...", "Success");
MainClass.disable_reset(panel6);
loadData();
}
catch (Exception ex) { MainClass.ShowMSG(ex.Message, "Error", "Error"); }
}
else if (edit == 1)// for Update perious data entered by user
{
try {
byte Numofshift;
if (NumofshiftDD.SelectedIndex == 0)
{
Numofshift = 1; /*one*/
}
else if (NumofshiftDD.SelectedIndex == 1)
{
Numofshift = 2; /*two*/
}
else
{
Numofshift = 3;
}
obj.st_updateRoles(shiftnameTxt.Text, Numofshift, shiftsID);
obj.SubmitChanges();
MainClass.ShowMSG(shiftnameTxt.Text + " shift updated successfully", "Update...", "Success");
MainClass.disable_reset(panel6);
loadData();
}
catch (Exception ex) { MainClass.ShowMSG(ex.Message, "Error", "Error"); }
}
}
SAVEbtn.Text = "SAVE";
}
public void Delete(shift s)
{
dataHandler.RemoveData(s);
NotifyOfPropertyChange("Shifts");
}
static shift shiftLeft(short b, int times)
{
shift s = new shift();
short shft = (short)(b << times);
s.carried = (shft > 255);
s.bytes = (short)shft;
s.lsb = (byte)shft;
s.neg = IsBitSet(s.lsb, 7); // is the most significant bit set?
if (s.carried)
{
s.carrybyte = (byte)(shft >> 8 & 0xFF); // shift to find the data that we've stripped
}
else
{
s.carrybyte = null;
}
return s;
}
static shift shiftRight(short b, int times)
{
shift s = new shift();
int shft = b >> times;
s.bytes = (short)shft;
s.lsb = (byte)shft;
s.neg = false;
s.carried = IsBitSet(b, 0);
s.carrybyte = null;
return s;
}
//shift in the extra byte
static byte ShiftRightCarry(shift s)
{
byte b = 0;
if (s.carried)
{
b = (byte)(s.bytes >> 1);
}
else
{
b = (byte)(s.lsb >> 1);
}
return b;
}
public static void UpdateShifts(shift toUpdate, Log toAppend)
{
ShiftController.UpdateShift(toUpdate);
LogController.LogInsert(toAppend);
}
public static void UpdateShift(shift toUpdate)
{
ShiftDB.UpdateShiftById(toUpdate);
}
// copied from ../../../internal/obj/util.go:/TYPE_SHIFT
private static @string String(this shift v)
{
@string op = "<<>>->@>"[((v >> (int)(5L)) & 3L) << (int)(1L)..];
public override void saveBtn_Click(object sender, EventArgs e)
{
if (shiftNameTxt.Text == "")
{
shiftErrorLabel.Visible = true;
}
else
{
shiftErrorLabel.Visible = false;
}
if (shiftDD.SelectedIndex == -1)
{
shiftDDerrorLabel.Visible = true;
}
else
{
shiftDDerrorLabel.Visible = false;
}
if (shiftDDerrorLabel.Visible || shiftDDerrorLabel.Visible)
{
MainClass.ShowMSG("Fields with * are mandatory.", "Error...", "Error");
}
else
{
TimeSpan startTime = new TimeSpan(startPicker.Value.Hour, startPicker.Value.Minute, startPicker.Value.Second);
TimeSpan endTime = new TimeSpan(endPicker.Value.Hour, endPicker.Value.Minute, endPicker.Value.Second);
//startTime.ToString();
//endTime.ToString();
//TimeSpan st = Convert.ToInt16(startPicker.Value.Hour.ToString());
//TimeSpan et = endPicker.Value.TimeOfDay;
//TimeSpan st = this.startPicker.Value.TimeOfDay;
//TimeSpan et = this.endPicker.Value.TimeOfDay;
//int st = Convert.ToInt16(startPicker.Value.ToString());
//int et = Convert.ToInt16(endPicker.Value.ToString());
//DateTime start = DateTime.Parse(startPicker.Text).Date;
//DateTime end = DateTime.Parse(endPicker.Text).Date;
//DateTime dt = startPicker.Value;
//TimeSpan st = new TimeSpan(dt.Hour, dt.Minute, dt.Second);
//DateTime en = endPicker.Value;
//TimeSpan et = new TimeSpan(en.Hour, en.Minute, en.Second);
//TimeSpan st = dt.TimeOfDay;
//int t = Convert.ToInt16(startPicker.Value.Hour.ToString());
//int y = Convert.ToInt16(endPicker.Value.Hour.ToString());
//TimeSpan ts1 = TimeSpan.Parse(startPicker.Text);
//TimeSpan ts2 = TimeSpan.Parse(endPicker.Text);
//TimeSpan ts = startPicker.Value.TimeOfDay;
//TimeSpan es = endPicker.Value.TimeOfDay;
if (edit == 0) // code for SAVE operation
{
try
{
shift s = new shift();
obj.st_insertShifts(shiftNameTxt.Text, Convert.ToByte(shiftDD.SelectedItem.ToString()), startTime, endTime);
obj.SubmitChanges();
MainClass.ShowMSG(shiftNameTxt.Text + " added successfully.", "Success...", "Success");
MainClass.disable_reset(panel6);
loadData();
}
catch (Exception ex)
{
MainClass.ShowMSG(ex.Message, "Error", "Error");
}
}
else
{
obj.st_updateShifts(shiftNameTxt.Text, Convert.ToByte(shiftDD.SelectedItem.ToString()), startTime, endTime, shiftID);
MainClass.ShowMSG(shiftNameTxt.Text + " updated successfully.", "Success...", "Success");
MainClass.disable_reset(panel6);
loadData();
}
}
}
