public m_cls_Company_D Update(m_cls_Company_D company)
{
//
_db.tbl_Company_D.Update(company);
_db.SaveChanges();
return(company);
}
public void Remove(int id)
{
//
m_cls_Company_D company = _db.tbl_Company_D.FirstOrDefault(c => c.CompanyId == id);
_db.tbl_Company_D.Remove(company);
_db.SaveChanges();
return;
}
public IActionResult Create([Bind("CompanyId,CompanyName,Address,Status")] m_cls_Company_D company)
{
if (ModelState.IsValid)
{
_companydb.Add(company);
return(RedirectToAction(nameof(Index)));
}
return(View(company));
}
public m_cls_Company_D Update(m_cls_Company_D company)
{
//
var sql = "UPDATE tbl_Company_D SET CompanyName = @CompanyName, Address = @Address, [Status] = @Status "
+ "WHERE CompanyId = @CompanyId;";
db.Execute(sql, company);
// parameter and field name are the same,
//so can pass company object as parameter
return(company);
}
public IActionResult Edit(int id, [Bind("CompanyId,CompanyName,Address,Status")] m_cls_Company_D company)
{
if (id != company.CompanyId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
_companydb.Update(company);
return(RedirectToAction(nameof(Index)));
}
return(View(company));
}
public m_cls_Company_D Add(m_cls_Company_D company)
{
//
var sql = "INSERT INTO tbl_Company_D (CompanyName,Address,[Status]) VALUES (@CompanyName,@Address,@Status);"
+ "SELECT CAST(SCOPE_IDENTITY() as int);";
/* var id = db.Query<int>(sql,new{
* @CompanyName = company.CompanyName,
* @Address = company.Address,
* @Status = company.Status
* }).Single(); */
var id = db.Query <int>(sql, new{
company.CompanyName,
company.Address,
company.Status
}).Single();
company.CompanyId = id;
return(company);
}
public m_cls_Company_D Add(m_cls_Company_D company)
{
_db.tbl_Company_D.Add(company);
_db.SaveChanges();
return(company);
}
