public string AddOrUpdateAVIP(VIP newVIP) { string err = AddOrUpdatePersonDetails(newVIP.FullName, newVIP.DateOfBirth, newVIP.Gender, newVIP.ContactNumber, newVIP.CivilianID, newVIP.Address); if (err != "") { return(err); } int personalDetailsID = GetPersonalDetailsID(newVIP.CivilianID); Table <DAL.VIP> vipTable = GetVipTable(); var matchedVIP = (from vip in vipTable where vip.personalDetailsID == personalDetailsID select vip).FirstOrDefault(); if (matchedVIP == null) { DAL.VIP newData = new DAL.VIP(); try { newData.vipID = newVIP.VipID; newData.personalDetailsID = personalDetailsID; newData.occupationCode = GetOccupationCode(newVIP.Occupation); newData.registerDate = DateTime.Now.Date; newData.endDate = DateTime.Now.AddDays(ParameterManager.GetVIPMembershipIncreasementDaysNumber()).Date; newData.vipStatusCode = 1; vipTable.InsertOnSubmit(newData); vipTable.Context.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } else if (matchedVIP != null) { try { matchedVIP.personalDetailsID = personalDetailsID; matchedVIP.occupationCode = GetOccupationCode(newVIP.Occupation); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } return(""); }
internal string IncreaseVipMembership(string vipID) { Table <DAL.VIP> vipTable = GetVipTable(); var res = (from vip in vipTable where vip.vipID == vipID select vip).FirstOrDefault(); if (res != null) { try { res.endDate = res.endDate.Value.Date.AddDays(ParameterManager.GetVIPMembershipIncreasementDaysNumber()); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } return(""); }