I need to set the MoneyEarned to 0 and I do not want to change the firstname and lastname that is already stored in the DB, this is my function can you anyone advise me please to rewrite the update function please.
public void UpdateMoneyEarned(User user)
{
using (var db = new TeachableEntities())
{
user.MoneyEarned = 0;
var q = db.Users;
db.submitchanges();
public void UpdateMoneyEarned(User user)
{
using (var db = new TeachableEntities())
{
User q = (from u in db.Users
where u.UserID == user.UserID
select u).FirstOrDefault();
q.MoneyEarned = 0
db.submitchanges();
}
}
Please 'Mark as Answer' if my post helped you
--------------------------------------------------
Muhammad Amin
محمد امين
Error 1 'Teachable.Models.Data.TeachableEntities' does not contain a definition for 'submitchanges' and no extension method 'submitchanges' accepting a first argument of type 'Teachable.Models.Data.TeachableEntities' could be found (are you missing
a using directive or an assembly reference?) C:\Teachable\Solution\Teachable\teachable.web\Models\ViewModels\ResourceListingVM.cs 534 21 Teachable.Web
sorry you have to use SaveChanges instead. and use Single() instead of FirstorDefault
public void UpdateMoneyEarned(User user)
{
using (TeachableEntities db = new TeachableEntities())
{
User q = (from u in db.Users
where u.UserID == user.UserID
select u).Single();
q.MoneyEarned = 0
db.SaveChanges();
}
}
Please 'Mark as Answer' if my post helped you
--------------------------------------------------
Muhammad Amin
محمد امين
CSharper11
Member
51 Points
36 Posts
Update
Mar 25, 2012 07:05 PM|LINK
This is my User Table
FirstName
LastName
MoneyEarned
I need to set the MoneyEarned to 0 and I do not want to change the firstname and lastname that is already stored in the DB, this is my function can you anyone advise me please to rewrite the update function please.
public void UpdateMoneyEarned(User user)
{
using (var db = new TeachableEntities())
{
user.MoneyEarned = 0;
var q = db.Users;
db.submitchanges();
}
}
mameenkhn
Contributor
2026 Points
391 Posts
Re: Update
Mar 25, 2012 07:48 PM|LINK
use something like below
public void UpdateMoneyEarned(User user) { using (var db = new TeachableEntities()) { User q = (from u in db.Users where u.UserID == user.UserID select u).FirstOrDefault(); q.MoneyEarned = 0 db.submitchanges(); } }--------------------------------------------------
Muhammad Amin
محمد امين
CSharper11
Member
51 Points
36 Posts
Re: Update
Mar 26, 2012 09:16 AM|LINK
Error 1 'Teachable.Models.Data.TeachableEntities' does not contain a definition for 'submitchanges' and no extension method 'submitchanges' accepting a first argument of type 'Teachable.Models.Data.TeachableEntities' could be found (are you missing a using directive or an assembly reference?) C:\Teachable\Solution\Teachable\teachable.web\Models\ViewModels\ResourceListingVM.cs 534 21 Teachable.Web
I get an error here.
mameenkhn
Contributor
2026 Points
391 Posts
Re: Update
Mar 26, 2012 09:39 AM|LINK
sorry you have to use SaveChanges instead. and use Single() instead of FirstorDefault
public void UpdateMoneyEarned(User user) { using (TeachableEntities db = new TeachableEntities()) { User q = (from u in db.Users where u.UserID == user.UserID select u).Single(); q.MoneyEarned = 0 db.SaveChanges(); } }--------------------------------------------------
Muhammad Amin
محمد امين