private void BtnDailyLog_Click(object sender, RoutedEventArgs e)
{
try
{
EmployeeRoster er = new EmployeeRoster();
er.EmployeeID = int.Parse(txtEId.Text);
RosterValidations roster = new RosterValidations();
DataTable dt = roster.CheckRoster_BLL(er);
if (dt != null)
{
dgRoster.Visibility = Visibility.Hidden;
dgLog.Visibility = Visibility.Visible;
MessageBox.Show("Daily Log Found");
dgRoster.ItemsSource = dt.DefaultView;
}
else
{
MessageBox.Show("Enter valid Employee ID");
}
}
catch (EmployeeRosterException er)
{
MessageBox.Show(er.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Btn_AddRoster_Click(object sender, RoutedEventArgs e)
{
try
{
EmployeeRoster er = new EmployeeRoster();
er.EmployeeID = int.Parse(txt_EmpID.Text.ToString());
er.RosterID = (RosterEnum)int.Parse(txt_RosterID.Text);
er.FromDate = DateTime.Parse(dt_FromDate.Text);
er.ToDate = DateTime.Parse(dt_ToDate.Text);
er.InTime = DateTime.Parse(txt_InHour.Text + ":" + txt_InMins.Text);
er.OutTime = DateTime.Parse(txt_OutHour.Text + ":" + txt_OutMins.Text);
RosterValidations rv = new RosterValidations();
DataTable displayRoster = rv.AddRoaster_BLL(er);
if (displayRoster != null)
{
MessageBox.Show("Roster Details are added");
dgEmployee.ItemsSource = displayRoster.DefaultView;
}
else
{
throw new EmployeeRosterException("Entered details are not correct");
}
}
catch (EmployeeRosterException ex)
{
MessageBox.Show(ex.Message);
}
}
public IHttpActionResult PutEmployeeRoster(int id, EmployeeRoster employeeRoster)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != employeeRoster.RosterID)
{
return BadRequest();
}
db.Entry(employeeRoster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeRosterExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
public IHttpActionResult AddRoster(string userName, string password,EmployeeRoster employeeRoster)
{
try
{
var employee = db.Employees.FirstOrDefault(e => e.Email == userName && e.Password == password);
if(employee == null)
{
return Content(HttpStatusCode.NotFound, "Invalid Username or Password");
}
EmployeeRoster er = new EmployeeRoster();
er.employeeId = employee.EmployeeID;
er.FromDate = employeeRoster.FromDate;
er.ToDate = employeeRoster.ToDate;
er.InTime = employeeRoster.InTime;
er.OutTime = employeeRoster.OutTime;
db.EmployeeRosters.Add(er);
db.SaveChanges();
return Content(HttpStatusCode.OK, "Roster Saved Successfully");
}
catch (Exception)
{
return Content(HttpStatusCode.InternalServerError, "Sql Server not connected");
}
}
public ActionResult DeleteConfirmed(int id)
{
EmployeeRoster employeeRoster = db.EmployeeRosters.Find(id);
db.EmployeeRosters.Remove(employeeRoster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult GetEmployeeRoster(int id)
{
EmployeeRoster employeeRoster = db.EmployeeRosters.Find(id);
if (employeeRoster == null)
{
return NotFound();
}
return Ok(employeeRoster);
}
public void TestMethod1()
{
EmployeeRoster employeeRoster = new EmployeeRoster();
employeeRoster.Add("David Jones", 50000);
employeeRoster.Add("Harris", 75000);
int expectedSalary = 75000;
int actualSalary = employeeRoster["Harris"];
Assert.AreEqual(expectedSalary, actualSalary);
}
public ActionResult Edit([Bind(Include = "RosterID,FromDate,ToDate,InTime,OutTime,EmployeeID")] EmployeeRoster employeeRoster)
{
if (ModelState.IsValid)
{
db.Entry(employeeRoster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "EmployeeName", employeeRoster.EmployeeID);
return(View(employeeRoster));
}
public DataTable CheckRoster_BLL(EmployeeRoster roster)
{
try
{
RoasterOperations pd = new RoasterOperations();
return(pd.CheckRoster_DAL(roster));
}
catch (EmployeeRosterException)
{
throw;
}
}
public IHttpActionResult PostEmployeeRoster(EmployeeRoster employeeRoster)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
db.EmployeeRosters.Add(employeeRoster);
db.SaveChanges();
return CreatedAtRoute("DefaultApi", new { id = employeeRoster.RosterID }, employeeRoster);
}
public IHttpActionResult DeleteEmployeeRoster(int id)
{
EmployeeRoster employeeRoster = db.EmployeeRosters.Find(id);
if (employeeRoster == null)
{
return NotFound();
}
db.EmployeeRosters.Remove(employeeRoster);
db.SaveChanges();
return Ok(employeeRoster);
}
// GET: EmployeeRosters/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeRoster employeeRoster = db.EmployeeRosters.Find(id);
if (employeeRoster == null)
{
return(HttpNotFound());
}
return(View(employeeRoster));
}
public DataTable AddRoaster_DAL(EmployeeRoster pboj)
{
DataTable rid = null;
try
{
cmd = new SqlCommand();
cmd.CommandText = "Group4.udp_InsertEmployeeRoster";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RosterID", pboj.RosterID);
cmd.Parameters.AddWithValue("@EmployeeID", pboj.EmployeeID);
cmd.Parameters.AddWithValue("@FromDate", pboj.FromDate);
cmd.Parameters.AddWithValue("@ToDate", pboj.ToDate);
cmd.Parameters.AddWithValue("@InTime", pboj.InTime);
cmd.Parameters.AddWithValue("@OutTime", pboj.OutTime);
con.Open();
displaycmd = new SqlCommand("Group4.udp_DisplayEmployeeRoster", con);
int noOfRowsAffected = cmd.ExecuteNonQuery();
//pid = int.Parse(cmd.Parameters["@RosterID"].Value.ToString());
SqlDataReader dr = displaycmd.ExecuteReader();
if (noOfRowsAffected != 0)
{
rid = new DataTable();
rid.Load(dr);
return(rid);
}
else
{
return(rid);
}
}
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
// GET: EmployeeRosters/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeRoster employeeRoster = db.EmployeeRosters.Find(id);
if (employeeRoster == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "EmployeeName", employeeRoster.EmployeeID);
return(View(employeeRoster));
}
private bool ValiadateRoster(EmployeeRoster newRoster)
{
bool isValidRoster = true;
StringBuilder sbClientError = new StringBuilder();
if (newRoster.EmployeeID.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("Employee ID cannot be empty!!:)" + Environment.NewLine);
}
if (!(Regex.IsMatch(newRoster.EmployeeID.ToString(), @"[0-9]{3,3}")))
{
isValidRoster = false;
sbClientError.Append("Emplpoyee ID can have only 4 digits" + Environment.NewLine);
}
if (newRoster.RosterID.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("Roster ID cannot be blank!!:)" + Environment.NewLine);
}
if (newRoster.InTime.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("In Time cannot be empty!!:)" + Environment.NewLine);
}
if (newRoster.OutTime.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("Out Time cannot be empty!!:)" + Environment.NewLine);
}
if (newRoster.ToDate.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("To Date cannot be blank!!:)" + Environment.NewLine);
}
if (newRoster.FromDate.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("From Date cannot be blank!!:)" + Environment.NewLine);
}
if (!isValidRoster)
{
throw new EmployeeRosterException(sbClientError.ToString());
}
return(isValidRoster);
}
public DataTable AddRoaster_BLL(EmployeeRoster robj)
{
DataTable addRoster = null;
try
{
RoasterOperations pd = new RoasterOperations();
if (ValiadateRoster(robj))
{
addRoster = pd.AddRoaster_DAL(robj);
return(addRoster);
}
}
catch (EmployeeRosterException)
{
throw;
}
return(addRoster);
}
/// <summary>
/// /////////
/// </summary>
/// <param name="roster"></param>
/// <returns></returns>
///
public DataTable CheckRosterDailyLog_DAL(EmployeeRoster roster)
{
DataTable dt = null;
try
{
cmd = new SqlCommand();
cmd.CommandText = "Group4.udp_SearchEmployeeRosterDailyLog";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmployeeID", roster.EmployeeID);
cmd.Parameters.AddWithValue("@FromDate", DateTime.Now.ToShortDateString());
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dt = new DataTable();
dt.Load(dr);
}
}
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(dt);
}
private bool ValiadateRoster(EmployeeRoster newRoster)
{
bool isValidRoster = true;
StringBuilder sbClientError = new StringBuilder();
if (newRoster.EmployeeID.Equals(string.Empty))//validation for blank LoginID
{
isValidRoster = false;
sbClientError.Append("Employee ID cannot be empty!!:)" + Environment.NewLine);
}
//validation for blank Password
if (newRoster.RosterID.Equals(string.Empty))
{
isValidRoster = false;
sbClientError.Append("Roster ID cannot be blank!!:)" + Environment.NewLine);
}
if (!isValidRoster)
{
throw new TaxiExceptions(sbClientError.ToString());
}
return(isValidRoster);
}
