/// <summary>
/// Inserting new rows into database
/// </summary>
/// <param name="rows"></param>
protected void InsertRows(IEnumerable <Car> rows)
{
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
try
{
foreach (var item in rows)
{
CarsTable carsTable = new CarsTable();
carsTable.Factory = item.Factory;
carsTable.Model = item.Model;
carsTable.Warranty = item.Warranty;
carsTable.ModelYear = DateTime.Now;
db.CarsTables.Add(carsTable);
}
db.SaveChanges();
StatusLabel.Text = "Import success!";
}
catch (Exception ex)
{
StatusLabel.Text = "Problem with import: " + ex.Message;
}
}
}
/// <summary>
/// Feeding grid with db rows
/// </summary>
/// <returns></returns>
public IQueryable <CarsTable> carsGrid_GetData()
{
SampleDatabaseEntities db = new SampleDatabaseEntities();
var allRows = db.CarsTables.Select(x => x);
return(allRows);
}
public IQueryable <CarsTable> carsGrid_GetData([QueryString] string factory)
{
SampleDatabaseEntities db = new SampleDatabaseEntities();
var allRows = db.CarsTables.Select(x => x).Where(x => x.Factory == factory);
//checking if button clicked to avoid message on page load
if (allRows.Count() == 0 && ClientQueryString.Count() > 0)
{
LabelNoRecords.Text = "<br />No records found";
}
return(allRows);
}
public void addCar_InsertItem()
{
var item = new CarsTable();
TryUpdateModel(item);
if (ModelState.IsValid)
{
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
db.CarsTables.Add(item);
db.SaveChanges();
}
}
}
/// <summary>
/// Deleting item
/// </summary>
/// <param name="Id"></param>
public void carsGrid_DeleteItem(int Id)
{
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
var item = new CarsTable {
Id = Id
};
db.Entry(item).State = EntityState.Deleted;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Delete issue: item id {0} not found in database.", Id));
}
}
}
/// <summary>
/// Update item
/// </summary>
/// <param name="Id"></param>
public void carsGrid_UpdateItem(int Id)
{
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
CarsTable item = null;
item = db.CarsTables.Find(Id);
if (item == null)
{
ModelState.AddModelError("",
String.Format("Update issue: item id {0} not found in database.", Id));
return;
}
TryUpdateModel(item);
if (ModelState.IsValid)
{
db.SaveChanges();
}
}
}
/// <summary>
/// Gathering db content into list of objects
/// </summary>
protected void GetRows()
{
List <Car> rows = new List <Car>();
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
try
{
foreach (var item in db.CarsTables)
{
rows.Add(new Car(item.Factory, item.Model, (int)item.Warranty, (DateTime)item.ModelYear));
}
}
catch (Exception ex)
{
StatusLabel.Text = "Problem with db export: " + ex.Message;
}
Serialize(rows);
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <CarsTable> allRows = new List <CarsTable>();
//gathering records
using (SampleDatabaseEntities db = new SampleDatabaseEntities())
{
allRows = db.CarsTables.Select(x => x).ToList();
}
//feeding WebGrid
WebGrid webGrid = new WebGrid(allRows, canPage: true, defaultSort: "Id", canSort: true, rowsPerPage: 5);
dbRowsControl.Text = webGrid.GetHtml(
columns: webGrid.Columns(
webGrid.Column("Id", "ID"),
webGrid.Column("Factory", "Company"),
webGrid.Column("Model", "Model"),
webGrid.Column("Warranty", "Warranty (years)"),
webGrid.Column("ModelYear", "Model Year", format: (item) => item.ModelYear.ToString("MM/yyyy"))
)
).ToString();
}