/// <summary> /// Deletes a record from the Staff table by its primary key. /// </summary> public bool Staff_Delete(Staff.BLDAL.DTO.Staff StaffLine) { bool status = false; try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "usp_Staff_Delete"; sqlCmd.Connection = this._sqlConn; sqlCmd.Parameters.AddWithValue("@StaffID", StaffLine.StaffID); if (this._sqlConn.State == ConnectionState.Closed) { this._sqlConn.Open(); } int numberOfRecordsAffected = sqlCmd.ExecuteNonQuery(); if (numberOfRecordsAffected > 0) { status = true; } this._sqlConn.Close(); } catch (Exception ex) { if (ConfigurationManager.AppSettings["RethrowErrors"] == "true") { throw ex; } status = false; } return(status); }
public static List <DTO.Staff> Staff_Search_SelectList(Staff.BLDAL.DTO.Staff _StaffLine) { List <Staff.BLDAL.DTO.Staff> StaffList = new List <Staff.BLDAL.DTO.Staff>(); try { StaffDAL IO = new StaffDAL(); SqlDataReader myReader = IO.Staff_Search_SelectList(_StaffLine); while (myReader.Read()) { Staff.BLDAL.DTO.Staff StaffLine = new Staff.BLDAL.DTO.Staff(); if (myReader["StaffID"] != DBNull.Value) { StaffLine.StaffID = (int)myReader["StaffID"]; } if (myReader["LastName"] != DBNull.Value) { StaffLine.LastName = (string)myReader["CompanyName"]; } if (myReader["MiddleName"] != DBNull.Value) { StaffLine.MiddleName = (string)myReader["Address"]; } if (myReader["FirstName"] != DBNull.Value) { StaffLine.FirstName = (string)myReader["FirstName"]; } if (myReader["Gender"] != DBNull.Value) { StaffLine.Gender = (string)myReader["Gender"]; } if (myReader["Position"] != DBNull.Value) { StaffLine.Position = (string)myReader["Position"]; } if (myReader["HiredDate"] != DBNull.Value) { StaffLine.HiredDate = (string)myReader["HiredDate"]; } if (myReader["Salary"] != DBNull.Value) { StaffLine.Salary = (string)myReader["Salary"]; } StaffList.Add(StaffLine); } myReader.Close(); } catch (Exception ex) { if (ConfigurationManager.AppSettings["RethrowErrors"] == "true") { throw ex; } return(new List <Staff.BLDAL.DTO.Staff>()); } return(StaffList); }
public ActionResult Create(Staff.BLDAL.DTO.Staff model) { if (ModelState.IsValid) { if (StaffBLL.Staff_Insert(model)) { return(RedirectToAction("Index")); } else { return(View(model)); } } return(View(model)); }
/// <summary> /// Selects a record from the Staff table by its primary key. /// </summary> public SqlDataReader Staff_Select(Staff.BLDAL.DTO.Staff StaffLine) { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "usp_Staff_Select"; sqlCmd.Connection = this._sqlConn; sqlCmd.Parameters.AddWithValue("@StaffID", StaffLine.StaffID); if (this._sqlConn.State == ConnectionState.Closed) { this._sqlConn.Open(); } SqlDataReader rd = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection); return(rd); }
/// <summary> /// Saves a record to the Staff table. /// </summary> public bool Staff_Update(Staff.BLDAL.DTO.Staff StaffLine) { bool status = false; try { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.CommandText = "usp_Staff_Update"; sqlCmd.Connection = this._sqlConn; sqlCmd.Parameters.AddWithValue("@LastName", ((StaffLine.LastName != null) ? (object)StaffLine.LastName : DBNull.Value)); sqlCmd.Parameters.AddWithValue("@MiddleName", StaffLine.MiddleName); sqlCmd.Parameters.AddWithValue("@FirstName", ((StaffLine.FirstName != null) ? (object)StaffLine.FirstName : DBNull.Value)); sqlCmd.Parameters.AddWithValue("@Gender", ((StaffLine.Gender != null) ? (object)StaffLine.Gender : DBNull.Value)); sqlCmd.Parameters.AddWithValue("@Position", ((StaffLine.Position != null) ? (object)StaffLine.Position : DBNull.Value)); sqlCmd.Parameters.AddWithValue("@HiredDate", ((StaffLine.HiredDate != null) ? (object)StaffLine.HiredDate : DBNull.Value)); sqlCmd.Parameters.AddWithValue("@Salary", ((StaffLine.Salary != null) ? (object)StaffLine.Salary : DBNull.Value)); if (this._sqlConn.State == ConnectionState.Closed) { this._sqlConn.Open(); } int numberOfRecordsAffected = sqlCmd.ExecuteNonQuery(); if (numberOfRecordsAffected > 0) { status = true; } this._sqlConn.Close(); } catch (Exception ex) { if (ConfigurationManager.AppSettings["RethrowErrors"] == "true") { throw ex; } status = false; } return(status); }
/// <summary> /// Deletes a record from the Staff table by its primary key. /// </summary> public static bool Staff_Delete(Staff.BLDAL.DTO.Staff _StaffLine) { StaffDAL IO = new StaffDAL(); return(IO.Staff_Delete(_StaffLine)); }
/// <summary> /// Saves a record to the Staff table. /// </summary> public static bool Staff_Insert(Staff.BLDAL.DTO.Staff _StaffLine) { StaffDAL IO = new StaffDAL(); return(IO.Staff_Insert(_StaffLine)); }