public ResponseModel SaveclubEvent(ClubModel model) { ResponseModel _respnse = new ResponseModel(); ShomaRMEntities db = new ShomaRMEntities(); if (db.tbl_Club.Where(a => a.ClubTitle.ToLower() == model.ClubTitle.ToLower()).ToList().Count() == 0) { var ClubCreate = new tbl_Club() { Id = model.Id, ClubTitle = model.ClubTitle, ActivityId = model.ActivityId, StartDate = model.StartDate, Venue = model.Venue, DayId = model.DayId, Time = model.Time, Contact = model.Contact, Email = model.Email, PhoneNumber = model.PhoneNumber, PhoneCheck = model.PhoneCheck, EmailCheck = model.EmailCheck, LevelId = model.LevelId, SpecialInstruction = model.SpecialInstruction, Description = model.Description, BriefDescription = model.BriefDescription, TermsAndCondition = model.TermsAndCondition, TenantID = model.TenantID, UserId = model.UserId, IsDeleted = false, Active = true, CreatedDate = DateTime.UtcNow, LastUpdatedDate = DateTime.UtcNow }; db.tbl_Club.Add(ClubCreate); db.SaveChanges(); var CreateClubMap = new tbl_ClubMapping() { Id = 0, ClubId = ClubCreate.Id, UserId = model.UserId }; db.tbl_ClubMapping.Add(CreateClubMap); db.SaveChanges(); _respnse.Status = true; _respnse.msg = "Saved Successfully.."; } else { _respnse.Status = false; _respnse.msg = "You Already Registered For This Event"; } db.Dispose(); return(_respnse); }
public bool RemoveMappingByClubIdandUserId(long ClubId, long UserId) { ShomaRMEntities db = new ShomaRMEntities(); try { var Data = db.tbl_ClubMapping.Where(a => a.ClubId == ClubId && a.UserId == UserId).FirstOrDefault(); if (Data != null) { if (db.tbl_Club.Where(a => a.UserId == UserId && a.Id == ClubId).Count() > 0) { int Value = db.Database.ExecuteSqlCommand("delete from tbl_ClubMapping where ClubId = " + ClubId + " and UserId=" + UserId + ""); int CLubValue = db.Database.ExecuteSqlCommand("delete from tbl_Club where Id = " + ClubId + " and UserId=" + UserId + ""); } else { db.tbl_ClubMapping.Remove(Data); db.SaveChanges(); } } else { var CreateClubMap = new tbl_ClubMapping() { Id = 0, ClubId = ClubId, UserId = UserId }; db.tbl_ClubMapping.Add(CreateClubMap); db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }