public int InsertCustomItem(EliasModel customItem, IFormFile Image)
{
int result = 0;
using (SqlConnection con = new SqlConnection(this.connectionString)) {
using (SqlCommand cmd = new SqlCommand("Elias.InsertCustomItem"))
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = customItem.Name;
cmd.Parameters.Add("@TypeId", SqlDbType.Int).Value = customItem.TypeId;
if (customItem.Image != null)
{
MemoryStream memoryStream = new MemoryStream();
customItem.Image.CopyTo(memoryStream);
cmd.Parameters.Add("@Image", SqlDbType.Image).Value = memoryStream.ToArray();
}
cmd.Parameters.Add("@ParentId", SqlDbType.Int).Value = customItem.ParentId;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
if (reader.HasRows)
{
result = Convert.ToInt32(reader.GetValue(0));
}
}
}
con.Close();
}
}
return(result);
}
public IActionResult Edit(int customItemId, int parentId)
{
EliasModel customItem = this._uow.GetCustomItem(customItemId);
if (parentId != 0)
{
customItem.ParentId = parentId;
}
ViewData["CustomItemTypes"] = this._uow.GetCustomItemTypes();
return(View(customItem));
}
public IActionResult Edit(EliasModel customItem, IFormFile image)
{
if (customItem != null && customItem.Name.Length > 0)
{
if (customItem.Id == 0 && image.FileName.Length > 0)
{
this._uow.InsertCustomItem(customItem, image);
}
else
{
this._uow.UpdateCustomItem(customItem);
}
return(RedirectToAction("List"));
}
return(View(customItem));
}
public EliasModel GetCustomItem(int customItemId)
{
EliasModel result = new EliasModel();
using (SqlConnection con = new SqlConnection(this.connectionString))
{
using (SqlCommand cmd = new SqlCommand("Elias.GetCustomItem"))
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CustomItemId", SqlDbType.Int).Value = customItemId;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader()) {
while (reader.Read())
{
if (reader.HasRows)
{
result.Id = reader.GetInt32(0);
result.Name = reader.GetString(1);
result.TypeId = reader.GetInt32(2);
result.Type = reader.GetString(3);
if (!reader.IsDBNull(4))
{
result.ImageArray = (byte[])reader.GetValue(4);
}
if (!reader.IsDBNull(5))
{
result.ParentId = reader.GetInt32(5);
}
result.IsDeleted = reader.GetBoolean(6);
}
}
}
con.Close();
}
}
return(result);
}
public void UpdateCustomItem(EliasModel customItem)
{
using (SqlConnection con = new SqlConnection(this.connectionString)) {
using (SqlCommand cmd = new SqlCommand("Elias.UpdateCustomItem"))
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CustomItemId", SqlDbType.Int).Value = customItem.Id;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = customItem.Name;
cmd.Parameters.Add("@TypeId", SqlDbType.Int).Value = customItem.TypeId;
if (customItem.Image != null)
{
MemoryStream memoryStream = new MemoryStream();
customItem.Image.CopyTo(memoryStream);
cmd.Parameters.Add("@Image", SqlDbType.Image).Value = memoryStream.ToArray();
}
cmd.Parameters.Add("@ParentId", SqlDbType.Int).Value = customItem.ParentId; //.HasValue ? customItem.ParentId.Value : DBNull.Value;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
