public void Delete(string id)
{
using (IObjectDb db = new ObjectDb("User_DeleteUser"))
{
var param = new
{
UserName = id
};
db.ExecuteNonQuery(param);
}
}
public void Delete(string id)
{
using (IObjectDb db = new ObjectDb("Movie_DeleteMovie"))
{
var param = new
{
Id = id
};
db.ExecuteNonQuery(param);
}
}
public object Get(string id)
{
using (IObjectDb db = new ObjectDb("User_GetUser"))
{
var param = new
{
UserName = id
};
List<ClientUser> users = (List<ClientUser>)db.Query<ClientUser>(param);
return users.FirstOrDefault();
}
}
public object Get(string id)
{
using (IObjectDb db = new ObjectDb("Movie_GetMovie"))
{
var param = new
{
Id = id
};
List<Movie> movies = (List<Movie>)db.Query<Movie>(param);
return movies.FirstOrDefault();
}
}
public void Update(object obj)
{
using (IObjectDb db = new ObjectDb("User_UpdateUser"))
{
ClientUser user = (ClientUser)obj;
var param = new
{
UserName = user.UserName,
Password = user.Password,
Role = user.Role,
Email = user.Email,
};
db.ExecuteNonQuery(param);
}
}
public void Create(object obj)
{
using (IObjectDb db = new ObjectDb("User_CreateUser"))
{
ClientUser user = (ClientUser)obj;
user.RegDate = System.DateTime.Now;
var param = new
{
UserName = user.UserName,
Password = user.Password,
Role = user.Role,
Email = user.Email,
RegDate = user.RegDate
};
db.ExecuteNonQuery(param);
}
}
