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