/// <summary>
/// Creates the specified instance.
/// </summary>
/// <param name="instance">The instance.</param>
/// <returns></returns>
public void Create(Category instance)
{
Mapper.CreateMap<Category, Categories>();
var category = Mapper.Map<Categories>(instance);
db.Categories.Add(category);
db.SaveChanges();
}
/// <summary>
/// Creates the specified instance.
/// </summary>
/// <param name="instance">The instance.</param>
/// <returns></returns>
public void Create(Category instance)
{
string sqlStatement = "INSERT [dbo].[Categories]([CategoryName],[Description])";
sqlStatement += "VALUES(@CategoryName,@Description);";
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
using (SqlCommand command = new SqlCommand(sqlStatement, conn))
{
command.Parameters.Add(new SqlParameter("CategoryName", instance.CategoryName));
command.Parameters.Add(new SqlParameter("Description", instance.Description));
command.CommandType = CommandType.Text;
command.CommandTimeout = 180;
if (conn.State != ConnectionState.Open) conn.Open();
try
{
command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
public ActionResult Edit(Category instance)
{
if (ModelState.IsValid)
{
this._repository.Update(instance);
return RedirectToAction("Index");
}
return View(instance);
}
/// <summary>
/// Creates the specified instance.
/// </summary>
/// <param name="instance">The instance.</param>
public void Create(Category instance)
{
string sqlStatement = "INSERT [dbo].[Categories]([CategoryName],[Description])";
sqlStatement += "VALUES(@CategoryName,@Description);";
DbCommand comm = Db.GetSqlStringCommand(sqlStatement);
comm.Parameters.Add(new SqlParameter("CategoryName", instance.CategoryName));
comm.Parameters.Add(new SqlParameter("Description", instance.Description));
Db.ExecuteNonQuery(comm);
}
/// <summary>
/// Gets the categories.
/// </summary>
/// <returns></returns>
public List<Category> GetCategories()
{
List<Category> result = new List<Category>();
var categories = this.db.Categories.OrderByDescending(x => x.CategoryID);
foreach (var item in categories)
{
var category = new Category()
{
CategoryID = item.CategoryID,
CategoryName = item.CategoryName,
Description = item.Description
};
result.Add(category);
}
return result;
}
/// <summary>
/// Gets the categories.
/// </summary>
/// <returns></returns>
public List<Category> GetCategories()
{
List<Category> categories = new List<Category>();
string sqlStatement = "select * from Categories order by CategoryID Desc";
using (DbCommand comm = Db.GetSqlStringCommand(sqlStatement))
using (IDataReader reader = this.Db.ExecuteReader(comm))
{
while (reader.Read())
{
Category item = new Category();
item.CategoryID = int.Parse(reader["CategoryID"].ToString());
item.CategoryName = reader["CategoryName"].ToString();
item.Description = reader["Description"].ToString();
categories.Add(item);
}
}
return categories;
}
/// <summary>
/// Gets the one.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public Category GetOne(int id)
{
string sqlStatement = "select * from Categories where CategoryID = @CategoryID";
Category item = new Category();
using (DbCommand comm = Db.GetSqlStringCommand(sqlStatement))
{
comm.Parameters.Add(new SqlParameter("CategoryID", id));
using (IDataReader reader = this.Db.ExecuteReader(comm))
{
if (reader.Read())
{
item.CategoryID = int.Parse(reader["CategoryID"].ToString());
item.CategoryName = reader["CategoryName"].ToString();
item.Description = reader["Description"].ToString();
}
}
}
return item;
}
/// <summary>
/// Updates the specified instance.
/// </summary>
/// <param name="instance">The instance.</param>
/// <returns></returns>
public void Update(Category instance)
{
string sqlStatement = "UPDATE [dbo].[Categories] ";
sqlStatement += "SET ";
sqlStatement += "[CategoryName] = @CategoryName, ";
sqlStatement += "[Description] = @Description ";
sqlStatement += "WHERE [dbo].[Categories].[CategoryID] = @CategoryID;";
DbCommand comm = Db.GetSqlStringCommand(sqlStatement);
comm.Parameters.Add(new SqlParameter("CategoryName", instance.CategoryName));
comm.Parameters.Add(new SqlParameter("Description", instance.Description));
comm.Parameters.Add(new SqlParameter("CategoryID", instance.CategoryID));
Db.ExecuteNonQuery(comm);
}
/// <summary>
/// Gets the categories.
/// </summary>
/// <returns></returns>
public List<Category> GetCategories()
{
List<Category> categories = new List<Category>();
string sqlStatement = "select * from Categories order by CategoryID desc";
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
using (SqlCommand command = new SqlCommand(sqlStatement, conn))
{
command.CommandType = CommandType.Text;
command.CommandTimeout = 180;
if (conn.State != ConnectionState.Open) conn.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Category item = new Category();
item.CategoryID = int.Parse(reader["CategoryID"].ToString());
item.CategoryName = reader["CategoryName"].ToString();
item.Description = reader["Description"].ToString();
categories.Add(item);
}
}
}
return categories;
}
/// <summary>
/// Updates the specified instance.
/// </summary>
/// <param name="instance">The instance.</param>
public void Update(Category instance)
{
string sqlStatement = "UPDATE [dbo].[Categories] ";
sqlStatement += "SET ";
sqlStatement += "[CategoryName] = @CategoryName, ";
sqlStatement += "[Description] = @Description ";
sqlStatement += "WHERE [dbo].[Categories].[CategoryID] = @CategoryID;";
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
using (SqlCommand command = new SqlCommand(sqlStatement, conn))
{
command.Parameters.Add(new SqlParameter("CategoryName", instance.CategoryName));
command.Parameters.Add(new SqlParameter("Description", instance.Description));
command.Parameters.Add(new SqlParameter("CategoryID", instance.CategoryID));
command.CommandType = CommandType.Text;
command.CommandTimeout = 180;
if (conn.State != ConnectionState.Open) conn.Open();
try
{
command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// Gets the one.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public Category GetOne(int id)
{
string sqlStatement = "select * from Categories where CategoryID = @CategoryID";
Category item = new Category();
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
using (SqlCommand comm = new SqlCommand(sqlStatement, conn))
{
comm.Parameters.Add(new SqlParameter("CategoryID", id));
comm.CommandType = CommandType.Text;
comm.CommandTimeout = 180;
if (conn.State != ConnectionState.Open) conn.Open();
using (IDataReader reader = comm.ExecuteReader())
{
if (reader.Read())
{
item.CategoryID = int.Parse(reader["CategoryID"].ToString());
item.CategoryName = reader["CategoryName"].ToString();
item.Description = reader["Description"].ToString();
}
}
}
return item;
}
/// <summary>
/// Gets the one.
/// </summary>
/// <param name="id">The id.</param>
/// <returns></returns>
public Category GetOne(int id)
{
var item = this.db.Categories.FirstOrDefault(x => x.CategoryID == id);
if (item == null)
{
return null;
}
else
{
var category = new Category()
{
CategoryID = item.CategoryID,
CategoryName = item.CategoryName,
Description = item.Description
};
return category;
}
}
