/// <summary>
/// Adds Computer
/// </summary>
/// <param name="avm">AddComputerViewModel</param>
/// <returns>Rollback Flag 1 or 0</returns>
public int AddComputer(AddComputerViewModel avm)
{
var rollbackFlag = 0;
using (SqlConnection con = new SqlConnection(TableConstant.CONNECTION_STRING))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_AddComputer"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ComputerName", avm.ComputerName);
cmd.Parameters.AddWithValue("@RAM", avm.RAM);
cmd.Parameters.AddWithValue("@Motherboard", avm.Motherboard);
cmd.Parameters.AddWithValue("@GraphicsCard", avm.GraphicsCard);
cmd.Parameters.AddWithValue("@Processor", avm.Processor);
cmd.Parameters.AddWithValue("@HardDisk", avm.HardDisk);
cmd.Parameters.AddWithValue("@Department", avm.Department);
cmd.Parameters.AddWithValue("@Status", avm.Status);
cmd.Parameters.AddWithValue("@UserId", avm.UserId);
cmd.Parameters.AddWithValue("@Username", avm.Username);
var returnParameter = cmd.Parameters.Add("@RollBackFlag", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
rollbackFlag = (int)returnParameter.Value;
}
}
return(rollbackFlag);
}
public ReturnResult <Computer> Add(AddComputerViewModel computer)
{
ComputerDAL computerDAL = new ComputerDAL();
var result = computerDAL.Add(computer);
return(result);
}
public ReturnResult <Computer> Add(AddComputerViewModel computer)
{
DbProvider dbProvider = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
StoredProcedureConfigs <Computer> storedProcedureConfigs = new StoredProcedureConfigs <Computer>();
dbProvider.SetQuery(storedProcedureConfigs._INSERT_SINGLE_STORED_PROCEDURE, CommandType.StoredProcedure)
.SetParameter("Name", SqlDbType.NVarChar, computer.Name, ParameterDirection.Input)
.SetParameter("ComputerRoomId", SqlDbType.Int, computer.ComputerRoomId, ParameterDirection.Input)
.SetParameter("StorageDeviceId", SqlDbType.Int, computer.StorageDeviceId, ParameterDirection.Input)
.SetParameter("StorageCapacityId", SqlDbType.Int, computer.StorageCapacityId, ParameterDirection.Input)
.SetParameter("CpuId", SqlDbType.Int, computer.CpuId, ParameterDirection.Input)
.SetParameter("RamId", SqlDbType.Int, computer.RamId, ParameterDirection.Input)
.SetParameter("SpeedId", SqlDbType.Int, computer.SpeedId, ParameterDirection.Input)
.SetParameter("MonitorId", SqlDbType.Int, computer.MonitorId, ParameterDirection.Input)
.SetParameter("MonitorSizeId", SqlDbType.Int, computer.MonitorSizeId, ParameterDirection.Input)
.SetParameter("MouseId", SqlDbType.Int, computer.MouseId, ParameterDirection.Input)
.SetParameter("KeyboardId", SqlDbType.Int, computer.KeyboardId, ParameterDirection.Input)
.SetParameter("OpticalDisc", SqlDbType.Int, computer.OpticalDiscId, ParameterDirection.Input)
.SetParameter("Status", SqlDbType.Int, computer.Status, ParameterDirection.Input)
.SetParameter("CreatedBy", SqlDbType.NVarChar, computer.CreatedBy, ParameterDirection.Input)
.SetParameter("ERROR_CODE", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ERROR_MESSAGE", SqlDbType.NVarChar, DBNull.Value, 400, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
dbProvider.GetOutValue("ERROR_CODE", out outCode)
.GetOutValue("ERROR_MESSAGE", out outMessage);
return(new ReturnResult <Computer>()
{
ErrorCode = outCode,
ErrorMessage = outMessage,
});
}
public IActionResult Add(AddComputerViewModel computer)
{
ComputerBusiness computerBusiness = new ComputerBusiness();
var result = computerBusiness.Add(computer);
return(Ok(result));
}
public async Task <ActionResult> Add(AddComputerViewModel computer)
{
computer.CreatedBy = _userSessionHelper.GetUserSession().UserName;
string apiUrl = _appUrlHelper.GetApiUrl(ApiUrlPath.COMPUTER_ADD);
var result = await HttpUtilities.PostAsyncApi <ReturnResult <Computer> >(apiUrl, JsonConvert.SerializeObject(computer));
return(Json(result));
}
// GET: Computers/Create
public ActionResult Create()
{
var viewModel = new AddComputerViewModel()
{
EmployeeOptions = GetEmployeeOptions()
};
return(View(viewModel));
}
public ActionResult AddComputers(AddComputerViewModel viewModel)
{
if (!String.IsNullOrEmpty(viewModel.ComputerIP))
{
var newComputer = new Computer
{
Banned = false,
IpAddress = viewModel.ComputerIP
};
_BanStorage.CreateComputer(newComputer);
}
return(View(viewModel));
}
public ActionResult Create(AddComputerViewModel computer)
{
try
{
// TODO: Add insert logic here
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO Computer (Make, Model, PurchaseDate, DecomissionDate)
OUTPUT INSERTED.Id
VALUES (@make, @model, @purchaseDate, @decomissionDate)
";
cmd.Parameters.Add(new SqlParameter("@make", computer.Make));
cmd.Parameters.Add(new SqlParameter("@model", computer.Model));
cmd.Parameters.Add(new SqlParameter("@purchaseDate", computer.PurchaseDate));
cmd.Parameters.Add(new SqlParameter("@decomissionDate", DBNull.Value));
var id = (int)cmd.ExecuteScalar();
computer.ComputerId = id;
//this should only run if the user has selected an employee value is zero
if (computer.EmployeeId != null)
{
cmd.CommandText = @"UPDATE Employee
SET ComputerId = @computerComputerId
WHERE Id = @computerEmployeeId";
cmd.Parameters.Add(new SqlParameter("@computerComputerId", computer.ComputerId));
cmd.Parameters.Add(new SqlParameter("@computerEmployeeId", computer.EmployeeId));
cmd.ExecuteNonQuery();
}
return(RedirectToAction(nameof(Index)));
}
}
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult AddComputers(AddComputerViewModel viewModel)
{
viewModel.State = Models.ViewModelState.Edit;
if (ModelState.IsValid)
{
if (this.BanStorage.GetComputer(viewModel.ComputerIP) == null)
{
if (!string.IsNullOrEmpty(viewModel.ComputerIP))
{
var newComputer = new Computer
{
Banned = false,
IpAddress = viewModel.ComputerIP
};
this.BanStorage.CreateComputer(newComputer);
}
}
viewModel.State = Models.ViewModelState.View;
}
return(RedirectToAction("EditComputers"));
}
