public static string Insert(int PostID, string Image, string CreatedBy, DateTime CreatedDate)
{
using (var dbe = new inventorymanagementEntities())
{
PostPublicImage ui = new PostPublicImage();
ui.PostID = PostID;
ui.Image = Image;
ui.CreatedDate = CreatedDate;
ui.CreatedBy = CreatedBy;
dbe.PostPublicImages.Add(ui);
int kq = dbe.SaveChanges();
return(kq.ToString());
}
}
public static PostPublicImage GetByID(int ID)
{
using (var dbe = new inventorymanagementEntities())
{
PostPublicImage ai = dbe.PostPublicImages.Where(a => a.ID == ID).SingleOrDefault();
if (ai != null)
{
return(ai);
}
else
{
return(null);
}
}
}
public static string Update(int ID, string Image, string ModifiedBy, DateTime ModifiedDate)
{
using (var dbe = new inventorymanagementEntities())
{
PostPublicImage ui = dbe.PostPublicImages.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.Image = Image;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
