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);
}
}
