public int insertDispensary(Dispensary ds, int userid) { ds.UserId = userid; ds.Is18 = false; ds.Is21 = false; ds.IsCreditCards = false; ds.IsHandicap = false; ds.IsLounge = false; ds.IsPictures = false; ds.IsSecurityGuard = false; ds.IsVideos = false; try { db.Dispensaries.Add(ds); db.SaveChanges(); var data = db.Dispensaries.OrderByDescending(a => a.DispensaryId).FirstOrDefault(a => a.DispensaryName == ds.DispensaryName && a.UserId==userid ); return data.DispensaryId; } catch { return 0; } }
public string UpadteDispensary(Dispensary ds, int id) { var data = db.Dispensaries.FirstOrDefault(a => a.DispensaryId == id); try { if (data != null) { data.DispensaryName = ds.DispensaryName; data.PhoneNo = ds.PhoneNo; data.Website = ds.Website; data.Email = ds.Email; if (ds.AvatarName != null) { data.AvatarName = ds.AvatarName; data.AvatarPath = ds.AvatarPath; } data.Facebook = ds.Facebook; data.Instagram = ds.Instagram; data.Twitter = ds.Twitter; data.IntroBody = ds.IntroBody; data.Body = ds.Body; data.City = ds.City; data.Country = ds.Country; data.Zipcode = ds.Zipcode; data.State = ds.State; data.Street = ds.Street; data.RegionId = 1; data.TimeZoneId = 1; data.Is18 = ds.Is18; data.Is21 = ds.Is21; data.IsCreditCards = ds.IsCreditCards; data.IsHandicap = ds.IsHandicap; data.IsLounge = ds.IsLounge; data.IsPictures = ds.IsPictures; data.IsSecurityGuard = ds.IsSecurityGuard; data.IsVideos = ds.IsVideos; data.SunDayClose = ds.SunDayClose; data.SunDayOpen = ds.SunDayOpen; data.MonDayClose = ds.MonDayClose; data.MonDayOpen = ds.MonDayOpen; data.TuesDayClose = ds.TuesDayClose; data.TuesDayOpen = ds.TuesDayOpen; data.WednesDayClose = ds.WednesDayClose; data.WednesDayOpen = ds.WednesDayOpen; data.ThursDayClose = ds.ThursDayClose; data.ThursDayOpen = ds.ThursDayOpen; data.FriDayClose = ds.FriDayClose; data.FriDayOpen = ds.FriDayOpen; data.SaturDayClose = ds.SaturDayClose; data.SaturDayOpen = ds.SaturDayOpen; } db.SaveChanges(); return "true"; } catch { return "false"; } }