コード例 #1
0
ファイル: FaqRepository.cs プロジェクト: ahmedekdawy/LMIS
        public Infrastructure.Data.Entities.FaqVm Post(Infrastructure.Data.Entities.FaqVm vm, string Userid)
        {
            using (var db = new LMISEntities())
            {
                try
                {
                    var id         = vm.FAQID;
                    var checkExist = db.FAQs.Count(c => c.Question == vm.Question && c.FAQLanguage == vm.FAQLanguage && c.FAQID != vm.FAQID && !c.IsDeleted);
                    if (checkExist > 0)
                    {
                        return(null);
                    }
                    if (id > 0) //Update
                    {
                        var tr = db.FAQs
                                 .Where(r => r.FAQID == id)
                                 .ToList().Single();
                        tr.FAQCategoryID = vm.FAQCategoryID;
                        tr.Question      = vm.Question;
                        tr.Answer        = vm.Answer;
                        tr.FAQLanguage   = vm.FAQLanguage;
                        tr.UpdateUserID  = Userid;
                        tr.UpdateDate    = DateTime.UtcNow;
                    }
                    else //Insert
                    {
                        var tr = new FAQ()
                        {
                            Question      = vm.Question,
                            Answer        = vm.Answer,
                            FAQLanguage   = vm.FAQLanguage,
                            FAQCategoryID = vm.FAQCategoryID,
                            PostUserID    = Userid,
                            PostDate      = DateTime.UtcNow
                        };

                        db.FAQs.Add(tr);
                        db.SaveChanges();

                        vm.FAQID = tr.FAQID;
                    }

                    db.SaveChanges();
                }
                catch (Exception ex)
                {
                    ExceptionDispatchInfo.Capture(ex).Throw();
                }


                return(vm);
            }
        }
コード例 #2
0
        public Infrastructure.Data.DTOs.ModelResponse Post(Infrastructure.Data.DTOs.UserInfo user, Infrastructure.Data.Entities.FaqVm vm)
        {
            try
            {
                //Authorization
                if (user == null)
                {
                    return(new ModelResponse(101));
                }


                var ds = Repo.Post(vm, user.UserId);
                //  if(ds==null)
                // { return new ModelResponse(102, ds); }
                return(new ModelResponse(0, ds));
            }
            catch (Exception ex)
            {
                return(new ModelResponse(ex));
            }
        }