コード例 #1
0
        public JBISpecificResponse GetSpecificJBI(int idJBI)
        {
            JBISpecificResponse response = new JBISpecificResponse();

            try
            {
                JBI one = _context.JBIs.Where((x) => x.Moneln == idJBI).FirstOrDefault();

                if (one != null)
                {
                    response.JBI   = ConvertJBI(one);
                    response.rc    = 0;
                    response.title = "Get one JBI success";
                }
                else
                {
                    response.rc    = 1;
                    response.title = "Id is not found";
                }
            }
            catch (Exception ex)
            {
                var message = ex.Message;
                response.desc = ex.Message;
            }

            return(response);
        }
コード例 #2
0
        public CrmResponse AddNewJbi(ENTITIES.JBI jbi)
        {
            CrmResponse response = new CrmResponse();

            try
            {
                JBI            newJbi = new JBI();
                Type           myType = newJbi.GetType();
                PropertyInfo[] props  = myType.GetProperties();
                foreach (PropertyInfo prop in props)
                {
                    object jbiValue = jbi.GetType().GetProperty(prop.Name).GetValue(jbi);
                    newJbi.GetType().GetProperty(prop.Name).SetValue(newJbi, jbiValue);
                }
                _context.JBIs.Add(newJbi);
                _context.SaveChanges();
                jbi.Moneln = _context.JBIs.Max().Moneln;
            }
            catch (Exception ex)
            {
                var message = ex.Message;
                response.desc = ex.Message;
            }

            return(response);
        }
コード例 #3
0
        public CrmResponse DeleteJBI(int idJBI)
        {
            CrmResponse response = new CrmResponse();

            try
            {
                JBI one = _context.JBIs.Where((x) => x.Moneln == idJBI).FirstOrDefault();
                if (one != null)
                {
                    _context.JBIs.Remove(one);
                    _context.SaveChanges();
                    response.rc    = 0;
                    response.title = "Delete one JBI success";
                }
                else
                {
                    response.rc    = 1;
                    response.title = "Id is not found";
                }
            }
            catch (Exception ex)
            {
                var message = ex.Message;
                response.desc = ex.Message;
            }

            return(response);
        }
コード例 #4
0
        public ActivitiesListResponse GetActivitiesList(ActivityFilters filters)
        {
            ActivitiesListResponse response = new ActivitiesListResponse();

            try
            {
                List <Activity> activitiesList = _context.Activities.ToList();
                if (filters.company != 0 || filters.fromDate != "" || filters.toDate != "")
                {
                    if (filters.company != 0)
                    {
                        activitiesList = activitiesList.Where((x) => x.Company == filters.company).ToList();
                    }
                    if (filters.fromDate != "")
                    {
                        activitiesList = activitiesList.Where((x) => x.InsertDate >= Convert.ToDateTime(filters.fromDate)).ToList();
                    }
                    if (filters.toDate != "")
                    {
                        activitiesList = activitiesList.Where((x) => x.InsertDate <= Convert.ToDateTime(filters.toDate)).ToList();
                    }
                }
                foreach (Activity item in activitiesList)
                {
                    ENTITIES.Activity newActivity = new ENTITIES.Activity();
                    Copy(ref newActivity, item);

                    List <ENTITIES.JBI> activitiesJBI = new List <ENTITIES.JBI>();

                    List <ActivityJBI> JBIlist = _context.ActivityJBIs.Where(x => x.ActivityId == item.ActivityId).ToList();
                    foreach (ActivityJBI jbi in JBIlist)
                    {
                        JBI          onePerson = _context.JBIs.Where(x => x.Moneln == jbi.JBIId).FirstOrDefault();
                        ENTITIES.JBI oneJBI    = new ENTITIES.JBI();
                        Copy(ref oneJBI, onePerson);
                        activitiesJBI.Add(oneJBI);
                    }

                    List <ENTITIES.TextBox> activitiesTextBoxes = new List <ENTITIES.TextBox>();
                    List <TextBox>          textBoxes           = _context.TextBoxes.Where(x => x.ActivityId == item.ActivityId).ToList();
                    foreach (TextBox textBox in textBoxes)
                    {
                        ENTITIES.TextBox oneTextBox = new ENTITIES.TextBox();
                        Copy(ref oneTextBox, textBox);
                        oneTextBox.BoxId = textBox.TextBoxId;
                        activitiesTextBoxes.Add(oneTextBox);
                    }
                    newActivity.JBIlist     = activitiesJBI.ToArray();
                    newActivity.TextBoxList = activitiesTextBoxes.ToArray();
                    response.Activities.Add(newActivity);
                }
            }
            catch (Exception ex)
            {
                response.desc = ex.Message;
                response.rc   = -1;
            }
            return(response);
        }
コード例 #5
0
 private ENTITIES.JBI ConvertJBI(JBI item)
 {
     ENTITIES.JBI response = new ENTITIES.JBI();
     response.Moneln    = item.Moneln;
     response.FirstName = item.FirstName;
     response.LastName  = item.LastName;
     response.Phone     = item.Phone;
     response.Facebook  = item.Facebook;
     response.Linkedin  = item.Linkedin;
     response.Email     = item.Email;
     return(response);
 }
コード例 #6
0
        public CrmResponse UpdateJBI(ENTITIES.JBI jbi)
        {
            CrmResponse response = new CrmResponse();

            try
            {
                JBI updatedRow = _context.JBIs.Where((x) => x.Moneln == jbi.Moneln).FirstOrDefault();
                if (updatedRow != null)
                {
                    Type           myType = updatedRow.GetType();
                    PropertyInfo[] props  = myType.GetProperties();
                    foreach (PropertyInfo prop in props)
                    {
                        //object oneKey = prop.Name;
                        //object onevalue = prop.GetValue(updatedRow, new object[] { });

                        object jbiValue = jbi.GetType().GetProperty(prop.Name).GetValue(jbi);
                        updatedRow.GetType().GetProperty(prop.Name).SetValue(updatedRow, jbiValue);
                    }

                    _context.SaveChanges();
                }
                else
                {
                    response.rc    = 1;
                    response.title = "Id is not found";
                }
            }
            catch (Exception ex)
            {
                var message = ex.Message;
                response.desc = ex.Message;
            }

            return(response);
        }