public ActionResult Create(FormCollection formCollection) { // try // { ElevatorBusiness ElevatorBusiness = new ElevatorBusiness(new ElevatorDataAccess()); LookupBusiness lookupBusiness = new LookupBusiness(new LookupDataAccess()); ElevatorCoreModel.Elevator elevator = new ElevatorCoreModel.Elevator { CreatedByUserId = 1, // (int)Session["ElevatorId"]; ModifiedByUserId = 2, // (int)Session["ElevatorId"]; ElevatorName = formCollection["ElevatorName"], FloorDuration = Convert.ToInt32(formCollection["FloorDuration"]), MaxWeight = Convert.ToInt32(formCollection["MaxWeight"]), CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now, MainStatusId = lookupBusiness.GetLookupId("MainStatus", formCollection["MainStatus"]), }; ElevatorBusiness.Create(elevator); return(RedirectToAction("Index")); //} //catch //{ // return View(); //} }
/// <summary> /// Returns corresponding elevator object based on elevatorid /// </summary> /// <param name="elevatorId"></param> /// <returns></returns> public ElevatorModel.Elevator GetElevator(int elevatorId) { ElevatorModel.Elevator elevator = null; using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("GetElevator", sqlConnection) { CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("@elevatorId", elevatorId); SqlDataAdapter adapter = new SqlDataAdapter { SelectCommand = command }; DataSet dataSet = new DataSet(); adapter.Fill(dataSet, "Elevators"); if (dataSet.Tables["Elevators"].Rows.Count > 0) { DataRow row = dataSet.Tables["Elevators"].Rows[0]; elevator = new ElevatorModel.Elevator { ElevatorId = Convert.ToInt32(row["ElevatorId"]), ElevatorName = Convert.ToString(row["ElevatorName"]), FloorDuration = Convert.ToInt32(row["FloorDuration"]), MainStatusId = Convert.ToInt32(row["MainStatusId"]), MaxWeight = Convert.ToInt32(row["MaxWeight"]), ModifiedByUserId = Convert.ToInt32(row["ModifiedByUserId"]), ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]), CreatedByUserId = Convert.ToInt32(row["CreatedByUserId"]), CreatedDate = Convert.ToDateTime(row["CreatedDate"]) }; } } return(elevator); }
/// <summary> /// Takes the Elevator object and update it into database /// </summary> /// <param name="elevator"></param> /// <returns></returns> public bool Update(ElevatorModel.Elevator elevator) { bool result = false; using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("UpdateElevator", sqlConnection) { CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("@elevatorName", elevator.ElevatorName); command.Parameters.AddWithValue("@floorDuration", elevator.FloorDuration); command.Parameters.AddWithValue("@maxWeight", elevator.MaxWeight); command.Parameters.AddWithValue("@mainStatusId", elevator.MainStatusId); sqlConnection.Open(); result = command.ExecuteNonQuery() > 0 ? true : false; } return(result); }
// GET: Elevator/Edit/5 public ActionResult Edit(int id) { ElevatorBusiness elevatorBusiness = new ElevatorBusiness(new ElevatorDataAccess()); LookupBusiness lookupBusiness = new LookupBusiness(new LookupDataAccess()); ElevatorCoreModel.Elevator elevator = elevatorBusiness.GetElevator(id); ElevatorModel elevatorModel = new ElevatorModel { ElevatorName = elevator.ElevatorName, CreatedByUserId = elevator.CreatedByUserId, MainStatus = (Enums.MainStatus)Enum.Parse(typeof(Enums.MainStatus), lookupBusiness.GetLookupValue(elevator.MainStatusId)), ModifiedByUserId = elevator.ModifiedByUserId, ModifiedDate = elevator.ModifiedDate, MaxWeight = elevator.MaxWeight, FloorDuration = elevator.FloorDuration, CreatedDate = elevator.CreatedDate, ElevatorId = elevator.ElevatorId }; return(View(elevatorModel)); }
/// <summary> /// Returns elevator list /// </summary> /// <returns></returns> public List <ElevatorModel.Elevator> GetElevators() { List <ElevatorModel.Elevator> elevatorList = new List <ElevatorModel.Elevator>(); using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand("GetElevators", sqlConnection) { CommandType = CommandType.StoredProcedure }; SqlDataAdapter adapter = new SqlDataAdapter { SelectCommand = command }; DataSet dataSet = new DataSet(); adapter.Fill(dataSet, "Elevators"); foreach (DataRow row in dataSet.Tables["Elevators"].Rows) { ElevatorModel.Elevator elevator = new ElevatorModel.Elevator { ElevatorId = Convert.ToInt32(row["ElevatorId"]), ElevatorName = Convert.ToString(row["ElevatorName"]), FloorDuration = Convert.ToInt32(row["FloorDuration"]), MainStatusId = Convert.ToInt32(row["MainStatusId"]), MaxWeight = Convert.ToInt32(row["MaxWeight"]), ModifiedByUserId = Convert.ToInt32(row["ModifiedByUserId"]), ModifiedDate = Convert.ToDateTime(row["ModifiedDate"]), CreatedByUserId = Convert.ToInt32(row["CreatedByUserId"]), CreatedDate = Convert.ToDateTime(row["CreatedDate"]) }; elevatorList.Add(elevator); } } return(elevatorList); }
public ElevatorModel.Elevator GetElevator(int elevatorId) { ElevatorModel.Elevator elevator = elevatorDataAccess.GetElevator(elevatorId); return(elevator); }
public bool Update(ElevatorModel.Elevator elevator) { bool result = elevatorDataAccess.Update(elevator); return(result); }