public bool Delete(PinboardModel pb) //method for delet
{
base.DataAccess();
base.Connect();
string Query = "delete from Pinboard where PostId={0}";
Query = string.Format(Query, pb.PostId);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
public bool Update(PinboardModel pb) //method for update
{
base.DataAccess();
base.Connect();
string Query = "update Pinboard set PostId=N'{0}',Title=N'{1}',Date=N'{2}',Ingredients=N'{3}',Recipe=N'{4}' where Id={5}";
Query = string.Format(Query, pb.PostId, pb.Title, pb.Date, pb.Ingredients, pb.Recipe);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
public bool Insert(PinboardModel pb) //method for adding item
{
base.DataAccess();
base.Connect();
string Query = "insert into Pinboard (UserId,PostId,Title,Date,Ingredients,Recipe) values (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N{5)";
Query = string.Format(Query, pb.UserId, pb.PostId, pb.Title, pb.Date, pb.Ingredients, pb.Recipe);
bool res = base.DoCommand(Query);
base.DisConnect();
return(res);
}
