예제 #1
0
        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;
        }
예제 #2
0
 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;
 }
예제 #3
0
        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;
        }