public IHttpActionResult DeleteProspect(int ProspectID) { try { var head = Request.Headers; string token = "", ApplicationContext = ""; int StaffID = 0; bool IsTrainer; if (head.Contains("token")) { token = head.GetValues("token").First(); ApplicationContext = head.GetValues("X-ApplicationContext").First(); StaffID = int.Parse(head.GetValues("X-LoggedInUserId").First()); IsTrainer = bool.Parse(head.GetValues("X-IsTrainer").First()); } bool IsValidToken = TokenValidation.TokenValid(token); if (IsValidToken == true) { Prospect returnvalue = new Prospect(); returnvalue = SavePropsects.DeleteProspect(ProspectID, StaffID, ApplicationContext); return Ok(returnvalue); } else { return Unauthorized(); } } catch (Exception ex) { return InternalServerError(ex); } }
public static Prospect UpdateExistingprospect(Prospect value, int ProspectID, int StaffID, string ApplicationContext) { Prospect returnvalue = new Prospect(); Exceptionerror = ""; try { using (ProspectEntityModel context = new ProspectEntityModel()) { var result = context.AlignProspects.Where(row => row.UserID == ProspectID).ToList(); if (result.Count > 0) { foreach (var obj in result) { obj.FName = value.FName; obj.LName = value.LName; obj.Address1 = value.Address1; obj.Address2 = value.Address2; obj.City = value.City; obj.State = value.State; obj.Country = value.Country; obj.ZipCode = value.ZipCode; obj.Phone1 = value.Phone1; obj.Phone2 = value.Phone2; obj.EmailID = value.Email; obj.Sex = value.Sex; obj.DOB = value.DOB.ToShortDateString(); obj.CreatedByUser = StaffID; obj.GymID = Convert.ToInt16(value.GymId); obj.TimeStampModified = DateTime.Now.ToString(); obj.ModifiedByUserId = StaffID; obj.ModifiedContext = ApplicationContext; obj.TrainerId = StaffID; obj.UserType = 1; if (value.ProfileId > 0) { obj.ProfileID = value.ProfileId; obj.ConvertedByUser = StaffID; } obj.EmailOptOut = value.EmailOptOut; context.SaveChanges(); returnvalue.ProspectId = obj.UserID; } returnvalue = ProspectDetail.ProspectDetailByProspectID(ProspectID); } } } catch(Exception ex) { Exceptionerror = ex.Message; } return returnvalue; }
public static Prospect Savenewprospect(Prospect value, int StaffID, string ApplicationContext) { Prospect returnvalue = new Prospect(); Exceptionerror = ""; try { using (ProspectEntityModel context = new ProspectEntityModel()) { AlignProspect obj = new AlignProspect(); obj.FName = value.FName; obj.LName = value.LName; obj.Address1 = value.Address1; obj.Address2 = value.Address2; obj.City = value.City; obj.State = value.State; obj.Country = value.Country; obj.ZipCode = value.ZipCode; obj.Phone1 = value.Phone1; obj.Phone2 = value.Phone2; obj.EmailID = value.Email; obj.Sex = value.Sex; obj.DOB = value.DOB.ToShortDateString(); obj.CreatedByUser = StaffID; obj.GymID = Convert.ToInt16(value.GymId); obj.TimeStampCreated = DateTime.Now.ToString(); obj.TimeStampModified = DateTime.Now.ToString(); obj.ModifiedByUserId = StaffID; obj.ModifiedContext = ApplicationContext; obj.CreationNote = ApplicationContext; obj.TrainerId = StaffID; obj.UserType = 1; obj.EmailOptOut = value.EmailOptOut; context.AlignProspects.Add(obj); context.SaveChanges(); returnvalue = ProspectDetail.ProspectDetailByProspectID(obj.UserID); } } catch(Exception ex) { Exceptionerror = ex.Message; } return returnvalue; }
public static Prospect DeleteProspect(int ProspectID, int StaffID, string ApplicationContext) { Prospect returnvalue = new Prospect(); using (ProspectEntityModel context = new ProspectEntityModel()) { var result = context.AlignProspects.Where(row => row.UserID == ProspectID).ToList(); if (result.Count > 0) { foreach (var obj in result) { obj.TimeStampModified = DateTime.Now.ToString(); obj.ModifiedByUserId = StaffID; obj.ModifiedContext = ApplicationContext; obj.IsDeleted = true; context.SaveChanges(); } returnvalue = ProspectDetail.ProspectDetailByProspectID(ProspectID); } } return returnvalue; }
public IHttpActionResult ProspectByProspectID(int ProspectID) { try { var head = Request.Headers; string token = "", ApplicationContext = ""; int LoggedInUserID = 0; bool IsTrainer = false; if (head.Contains("token")) { token = head.GetValues("token").First(); LoggedInUserID = int.Parse(head.GetValues("X-LoggedInUserId").First()); IsTrainer = bool.Parse(head.GetValues("X-IsTrainer").First()); ApplicationContext = head.GetValues("X-ApplicationContext").First(); } bool IsValidToken = TokenValidation.TokenValid(token); if (IsValidToken == true) { Prospect returnvalue = new Prospect(); returnvalue = ProspectDetail.ProspectDetailByProspectID(ProspectID); if (returnvalue.ProspectId > 0) { return Ok(returnvalue); } else { return NotFound(); } } else { return Unauthorized(); } } catch (Exception ex) { return InternalServerError(ex); } }
public static List<Prospect> ProspectMemberDetail(int GymID, int StaffID, bool IsTrainer,string Sort) { List<Prospect> returnvalue = new List<Prospect>(); using (ProspectEntityModel context = new ProspectEntityModel()) { var result = (from pros in context.AlignProspects where ((pros.ProfileID == null && GymID != 0 && pros.GymID == GymID) || (pros.ProfileID == null && GymID == 0)) select new { UserID =pros.UserID, FName = pros.FName.Trim(), LName = pros.LName.Trim(), Address1 = pros.Address1.Trim(), Address2 = pros.Address2.Trim(), City = pros.City.Trim(), State = pros.State.Trim(), Country = pros.Country.Trim(), ZipCode = pros.ZipCode.Trim(), Phone1 = pros.Phone1, Phone2 = pros.Phone2, EmailID = pros.EmailID, Sex = pros.Sex, DOB = pros.DOB, Heightft = pros.Heightft, Heightin = pros.Heightin, Weight = pros.Weight, TimeStampCreated = pros.TimeStampCreated, TimeStampModified = pros.TimeStampModified, ProfileId = pros.ProfileID, TrainerID = pros.TrainerId, GymId = pros.GymID, CreatedByUser = pros.CreatedByUser ?? 0, ModifiedByUserId = pros.ModifiedByUserId ?? 0, ModifiedContext = pros.ModifiedContext ?? "", CreationNote = pros.CreationNote ?? "", ConvertedByUser = pros.ConvertedByUser??0, MemberBeforeProspect=pros.MemberBeforeProspect, IsDeleted = pros.IsDeleted, EmailOptOut = pros.EmailOptOut??false }).ToList(); //if(GymID!=0) //{ // result = result.Where(row => row.GymID == GymID).ToList(); //} if (Sort.Contains("-firstlast")) { result = result.OrderByDescending(row => row.FName).ThenByDescending(row => row.LName).ToList(); } else if (Sort.Contains("-lastfirst")) { result = result.OrderByDescending(row => row.LName).ThenByDescending(row => row.FName).ToList(); } else if (Sort.Contains("firstlast")) { result = result.OrderBy(row => row.FName).ThenBy(row => row.LName).ToList(); } else if (Sort.Contains("lastfirst")) { result = result.OrderBy(row => row.LName).ThenBy(row => row.FName).ToList(); } else if (Sort.Contains("-recent")) { result = result.OrderBy(row => Convert.ToDateTime(row.TimeStampModified).Date).ToList(); } else if (Sort.Contains("recent")) { result = result.OrderByDescending(row => Convert.ToDateTime(row.TimeStampModified).Date).ToList(); } if (StaffID > 0) { result = result.Where(row => row.ConvertedByUser == StaffID || row.ModifiedByUserId == StaffID).ToList(); } if (result.Count() > 0) { foreach (var i in result) { Prospect obj = new Prospect(); obj.ProspectId = i.UserID; obj.ProfileId = i.ProfileId ?? 0; obj.GymId = int.Parse(i.GymId.ToString()); obj.FName = i.FName; obj.LName = i.LName; obj.Address1 = i.Address1 ?? ""; obj.Address2 = i.Address2 ?? ""; obj.City = i.City ?? ""; obj.State = i.State ?? ""; obj.Country = i.Country ?? ""; obj.ZipCode = i.ZipCode ?? ""; obj.Phone1 = i.Phone1 ?? ""; obj.Phone2 = i.Phone2 ?? ""; obj.Email = i.EmailID ?? ""; obj.Sex = i.Sex ?? ""; if(i.DOB!=null) { obj.DOB = Convert.ToDateTime(i.DOB); } obj.MemberBeforeProspect = i.MemberBeforeProspect; obj.CreatedByUserId = i.CreatedByUser; obj.CreatedContext = i.CreationNote; obj.ModifiedByUserId = i.ModifiedByUserId; obj.ModifiedContext = i.ModifiedContext ?? ""; obj.ConvertedByUserId = i.ConvertedByUser; if (i.TimeStampCreated != null) { obj.TimeStampCreated = Convert.ToDateTime(i.TimeStampCreated); } if (i.TimeStampModified != null) { obj.TimeStampModified = Convert.ToDateTime(i.TimeStampModified); } obj.IsDeleted = i.IsDeleted ?? false; obj.EmailOptOut = i.EmailOptOut; returnvalue.Add(obj); } } } return returnvalue; }
public static Prospect ProspectDetailByProspectID(int ProspectID) { Prospect returnvalue = new Prospect(); ProspectEntityModel context = new ProspectEntityModel(); var result = context.AlignProspects.Where(row => row.UserID == ProspectID).ToList(); if (result.Count() > 0) { foreach (var i in result) { returnvalue.ProspectId = i.UserID; returnvalue.ProfileId = i.ProfileID ?? 0; returnvalue.GymId = int.Parse(i.GymID.ToString()); returnvalue.FName = i.FName; returnvalue.LName = i.LName; returnvalue.Address1 = i.Address1 ?? ""; returnvalue.Address2 = i.Address2 ?? ""; returnvalue.City = i.City ?? ""; returnvalue.State = i.State ?? ""; returnvalue.Country = i.Country ?? ""; returnvalue.ZipCode = i.ZipCode ?? ""; returnvalue.Phone1 = i.Phone1 ?? ""; returnvalue.Phone2 = i.Phone2 ?? ""; returnvalue.Email = i.EmailID ?? ""; returnvalue.Sex = i.Sex ?? ""; if (i.DOB != null) { returnvalue.DOB = Convert.ToDateTime(i.DOB); } returnvalue.MemberBeforeProspect = i.MemberBeforeProspect; returnvalue.CreatedByUserId = i.CreatedByUser.Value; returnvalue.CreatedContext = i.CreationNote; returnvalue.ModifiedByUserId = i.ModifiedByUserId ??0; returnvalue.ModifiedContext = i.ModifiedContext ??""; returnvalue.ConvertedByUserId = i.ConvertedByUser ?? 0; if (i.TimeStampCreated != null) { returnvalue.TimeStampCreated = Convert.ToDateTime(i.TimeStampCreated); } if(i.TimeStampModified!=null) { returnvalue.TimeStampModified = Convert.ToDateTime(i.TimeStampModified); } returnvalue.IsDeleted = i.IsDeleted ?? false; returnvalue.EmailOptOut = i.EmailOptOut ?? false; } } return returnvalue; }