public static int SaveEvent(int eventId, string eventName)
{
DBKOMPDataContext db = new DBKOMPDataContext();
PhotoDirectory obj = new PhotoDirectory();
if (eventId == 0)
{
obj.AlbumName = eventName;
obj.FolderName = eventName.Replace(" ", "");
obj.Sequence = (from w in db.PhotoDirectories where w.Type == "E" select w).Count() + 1;
obj.Type = "E";
db.PhotoDirectories.InsertOnSubmit(obj);
Directory.CreateDirectory(HttpContext.Current.Server.MapPath("images/" + eventName.Replace(" ", "")));
}
else
{
PhotoDirectory objUpdated = db.PhotoDirectories.Where(p => (p.Id == eventId)).First();
objUpdated.AlbumName = eventName;
}
db.SubmitChanges();
db.Dispose();
return(obj.Id);
}
public static void SaveNews(MenuItem obj)
{
using (DBKOMPDataContext db = new DBKOMPDataContext())
{
if (obj.Id == 0)
{
db.MenuItems.InsertOnSubmit(obj);
}
else
{
KitchenOnMyPlate.MenuItem objUpdated = db.MenuItems.Where(p => (p.Id == obj.Id)).First();
objUpdated.Header = obj.Header;
objUpdated.Detail = obj.Detail;
objUpdated.Picture = obj.Picture;
objUpdated.MenuId = obj.MenuId;
objUpdated.Price = obj.Price;
objUpdated.Veg = obj.Veg;
objUpdated.NonCustomized = obj.NonCustomized;
objUpdated.IsActive = obj.IsActive;
objUpdated.AvailableDay = obj.AvailableDay;
}
db.SubmitChanges();
db.Dispose();
}
}
public static int SaveTitle(string imageFile, string title, string folderName)
{
DBKOMPDataContext db = new DBKOMPDataContext();
lock (db)
{
System.Diagnostics.Process.GetCurrentProcess();
PeraImage obj = new PeraImage();
PeraImage objUpdated = db.PeraImages.Where(p => (p.Directory == folderName && p.FileName == imageFile)).First();
objUpdated.Detail = title;
db.SubmitChanges();
db.Dispose();
}
return(1);
}
public static void SaveProduct(Menu obj)
{
using (DBKOMPDataContext db = new DBKOMPDataContext())
{
if (obj.Id == 0)
{
db.Menus.InsertOnSubmit(obj);
}
else
{
KitchenOnMyPlate.Menu objUpdated = db.Menus.Where(p => (p.Id == obj.Id)).First();
objUpdated.Header = obj.Header;
objUpdated.Detail = obj.Detail;
objUpdated.IsActive = obj.IsActive;
}
db.SubmitChanges();
db.Dispose();
CacheHelper.Clear("Menu");
}
}