/// <summary>
/// Adds a new quality to the database
/// </summary>
/// <param name="NewQuality">Quality DTO to be added</param>
/// <returns>Success as a bool</returns>
public bool AddNewQuality(QualityDTO NewQuality)
{
bool Success;
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand InsertIntoQuality = new SqlCommand
{
CommandText = "InsertIntoQuality",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlParameter QualityNameParameter = new SqlParameter
{
ParameterName = "QualityName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.VarChar,
SqlValue = NewQuality.QualityName
};
InsertIntoQuality.Parameters.Add(QualityNameParameter);
SqlParameter QualityShortNameParameter = new SqlParameter
{
ParameterName = "QualityShortName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.VarChar,
SqlValue = NewQuality.QualityShortName
};
InsertIntoQuality.Parameters.Add(QualityShortNameParameter);
SqlParameter PercentageParamter = new SqlParameter
{
ParameterName = "Percentage",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Decimal,
SqlValue = NewQuality.Percentage
};
InsertIntoQuality.Parameters.Add(PercentageParamter);
try
{
InsertIntoQuality.ExecuteNonQuery();
Success = true;
}
catch
{
Success = false;
}
return(Success);
}
// PUT: api/Quality/5
public IHttpActionResult Put(int id, [FromBody] QualityDTO quality)
{
var res = new Repositories().UpdateQuality(quality);
if (res)
{
return(Ok());
}
return(NotFound());
}
// POST: api/Quality
public IHttpActionResult Post([FromBody] QualityDTO quality)
{
var res = new Repositories().CreateQuality(quality);
if (res)
{
return(Ok());
}
return(InternalServerError());
}
public ActionResult Create(QualityDTO quality)
{
if (quality.ID == 0)
{
ApiService.CreateQuality(quality);
}
else
{
ApiService.UpdateQuality(quality);
}
return(RedirectToAction("Index"));
}
public Quality Get(int QualityID)
{
Quality FoundQuality = new Quality();
QualityDTO QualityDTO = new QualityDTO();
QualityDataController QualityDataController = new QualityDataController();
QualityDTO = QualityDataController.GetQualityByID(QualityID);
FoundQuality.QualityID = QualityDTO.QualityID;
FoundQuality.QualityName = QualityDTO.QualityName;
FoundQuality.QualityShortName = QualityDTO.QualityShortName;
FoundQuality.Percentage = QualityDTO.Percentage;
return(FoundQuality);
}
//create
public bool CreateQuality(QualityDTO quality)
{
try
{
var data = new QualityDao().Create(new Quality()
{
QualityName = quality.QualityName,
QualityVip = quality.QualityVip,
});
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
/// <summary>
/// Gets a quality entry based on the provided ID
/// </summary>
/// <param name="QualityID">The provided quality ID</param>
/// <returns>QualityDTO</returns>
public QualityDTO GetQualityByID(int QualityID)
{
QualityDTO FoundQuality = new QualityDTO();
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand SearchForQualityByID = new SqlCommand
{
CommandText = "GetQualityByID",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlParameter QualityIDParameter = new SqlParameter
{
ParameterName = "QualityID",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
SqlValue = QualityID
};
SearchForQualityByID.Parameters.Add(QualityIDParameter);
SqlDataReader DataReader = SearchForQualityByID.ExecuteReader();
if (DataReader.Read())
{
while (DataReader.HasRows)
{
for (int Index = 0; Index < DataReader.FieldCount; Index++)
{
FoundQuality.QualityID = int.Parse(DataReader["QualityID"].ToString());
FoundQuality.Percentage = decimal.Parse(DataReader["Percentage"].ToString());
FoundQuality.QualityName = DataReader["QualityName"].ToString();
FoundQuality.QualityShortName = DataReader["QualityShortName"].ToString();
}
}
}
DataReader.Close();
StoreConnection.Close();
return(FoundQuality);
}
public bool Post([FromBody] Quality NewQuality)
{
bool Success;
QualityDataController QualityDataController = new QualityDataController();
QualityDTO NewQualityDTO = new QualityDTO
{
QualityName = NewQuality.QualityName,
Percentage = NewQuality.Percentage,
QualityShortName = NewQuality.QualityShortName
};
Success = QualityDataController.AddNewQuality(NewQualityDTO);
return(Success);
}
//Update
public bool UpdateQuality(QualityDTO quality)
{
try
{
new QualityDao().Update(new Quality()
{
ID = quality.ID,
QualityName = quality.QualityName,
QualityVip = quality.QualityVip,
});
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
//Get All quality
public List <QualityDTO> GetAllQuality()
{
var listData = new QualityDao().GetAll();
var list = new List <QualityDTO>();
foreach (var quality in listData)
{
var data = new QualityDTO()
{
ID = quality.ID,
QualityName = quality.QualityName,
QualityVip = quality.QualityVip,
};
list.Add(data);
}
return(list);
}
public bool Update([FromBody] Quality UpdatedQuality)
{
bool Success;
QualityDataController QualityDataController = new QualityDataController();
QualityDTO UpdatingQuality = new QualityDTO
{
QualityID = UpdatedQuality.QualityID,
QualityName = UpdatedQuality.QualityName,
QualityShortName = UpdatedQuality.QualityShortName,
Percentage = UpdatedQuality.Percentage
};
Success = QualityDataController.UpdateQuality(UpdatingQuality);
return(Success);
}
/// <summary>
/// Gets all qualities saved in the database
/// </summary>
/// <returns>List of QualityDTOs</returns>
public List <QualityDTO> GetAllQualities()
{
List <QualityDTO> AllQualities = new List <QualityDTO>();
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand SeacrchForAllQualities = new SqlCommand
{
CommandText = "GetAllQualities",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlDataReader DataReader = SeacrchForAllQualities.ExecuteReader();
if (DataReader.Read())
{
while (DataReader.HasRows)
{
QualityDTO IncomingQuality = new QualityDTO();
for (int Index = 0; Index < DataReader.FieldCount; Index++)
{
IncomingQuality.QualityID = int.Parse(DataReader["QualityID"].ToString());
IncomingQuality.Percentage = decimal.Parse(DataReader["Percentage"].ToString());
IncomingQuality.QualityName = DataReader["QualityName"].ToString();
IncomingQuality.QualityShortName = DataReader["QualityShortName"].ToString();
}
AllQualities.Add(IncomingQuality);
}
}
DataReader.Close();
StoreConnection.Close();
return(AllQualities);
}
/// <summary>
/// Performs an update on the suppled quality
/// </summary>
/// <param name="UpdatedQuality">Quality DTO to update</param>
/// <returns>Success as bool</returns>
public bool UpdateQuality(QualityDTO UpdatedQuality)
{
bool Success;
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand UpdateQuality = new SqlCommand
{
CommandText = "UpdateQuality",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlParameter QualityIDParameter = new SqlParameter
{
ParameterName = "QualityID",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
SqlValue = UpdatedQuality.QualityID
};
UpdateQuality.Parameters.Add(QualityIDParameter);
SqlParameter QualityNameParameter = new SqlParameter
{
ParameterName = "QualityName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.VarChar,
SqlValue = UpdatedQuality.QualityName
};
UpdateQuality.Parameters.Add(QualityNameParameter);
SqlParameter PercentageParameter = new SqlParameter
{
ParameterName = "Percentage",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Decimal,
SqlValue = UpdatedQuality.Percentage
};
UpdateQuality.Parameters.Add(PercentageParameter);
SqlParameter QualityShortNameParameter = new SqlParameter
{
ParameterName = "QualityShortName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.VarChar,
SqlValue = UpdatedQuality.QualityShortName
};
UpdateQuality.Parameters.Add(QualityShortNameParameter);
UpdateQuality.ExecuteNonQuery();
StoreConnection.Close();
Success = true;
return(Success);
}
public bool UpdateQuality(QualityDTO quality)
{
return(new QualityBus().UpdateQuality(quality));
}
public bool CreateQuality(QualityDTO quality)
{
return(new QualityBus().CreateQuality(quality));
}
