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(); } } }