Exemplo n.º 1
0
        public static List <Common.Models.Forms.FormFieldMatter> ListForMatter(Guid matterId)
        {
            List <Common.Models.Forms.FormFieldMatter> list;
            List <Common.Models.Forms.FormField>       fieldList;

            fieldList = Data.Forms.FormField.List();
            list      = new List <Common.Models.Forms.FormFieldMatter>();

            fieldList.ForEach(x =>
            {
                Common.Models.Forms.FormFieldMatter ffm;

                ffm = Data.Forms.FormFieldMatter.Get(matterId, x.Id.Value);

                if (ffm == null)
                {
                    ffm = new Common.Models.Forms.FormFieldMatter()
                    {
                        FormField = x
                    }
                }
                ;
                else
                {
                    ffm.FormField = x;
                }

                list.Add(ffm);
            });

            return(list);
        }
 public static Common.Models.Forms.FormFieldMatter Edit(
     Transaction t,
     Common.Models.Forms.FormFieldMatter model,
     Common.Models.Account.Users modifier)
 {
     return(Edit(model, modifier, t.Connection, false));
 }
 public static Common.Models.Forms.FormFieldMatter Create(
     Transaction t,
     Common.Models.Forms.FormFieldMatter model,
     Common.Models.Account.Users creator)
 {
     return(Create(model, creator, t.Connection, false));
 }
Exemplo n.º 4
0
        public static List<Common.Models.Forms.FormFieldMatter> ListForMatter(Guid matterId)
        {
            List<Common.Models.Forms.FormFieldMatter> list;
            List<Common.Models.Forms.FormField> fieldList;

            fieldList = Data.Forms.FormField.List();
            list = new List<Common.Models.Forms.FormFieldMatter>();

            fieldList.ForEach(x =>
            {
                Common.Models.Forms.FormFieldMatter ffm;

                ffm = Data.Forms.FormFieldMatter.Get(matterId, x.Id.Value);

                if (ffm == null)
                    ffm = new Common.Models.Forms.FormFieldMatter() 
                    { 
                        FormField = x
                    };
                else
                    ffm.FormField = x;

                list.Add(ffm);
            });

            return list;
        }
Exemplo n.º 5
0
        public static Common.Models.Forms.FormFieldMatter Edit(Common.Models.Forms.FormFieldMatter model,
                                                               Common.Models.Account.Users modifier)
        {
            model.ModifiedBy = modifier;
            model.Modified   = DateTime.UtcNow;
            DBOs.Forms.FormFieldMatter dbo = Mapper.Map <DBOs.Forms.FormFieldMatter>(model);

            using (IDbConnection conn = Database.Instance.GetConnection())
            {
                conn.Execute("UPDATE \"form_field_matter\" SET " +
                             "\"matter_id\"=@MatterId, \"form_field_id\"=@FormFieldId, \"value\"=@Value, \"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId " +
                             "WHERE \"id\"=@Id", dbo);
            }

            return(model);
        }
Exemplo n.º 6
0
        public static Common.Models.Forms.FormFieldMatter Create(Common.Models.Forms.FormFieldMatter model,
                                                                 Common.Models.Account.Users creator)
        {
            if (!model.Id.HasValue)
            {
                model.Id = Guid.NewGuid();
            }
            model.Created   = model.Modified = DateTime.UtcNow;
            model.CreatedBy = model.ModifiedBy = creator;
            DBOs.Forms.FormFieldMatter dbo = Mapper.Map <DBOs.Forms.FormFieldMatter>(model);

            using (IDbConnection conn = Database.Instance.GetConnection())
            {
                conn.Execute("INSERT INTO \"form_field_matter\" (\"id\", \"matter_id\", \"form_field_id\", \"value\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " +
                             "VALUES (@Id, @MatterId, @FormFieldId, @Value, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)",
                             dbo);
            }

            return(model);
        }
        public static Common.Models.Forms.FormFieldMatter Edit(
            Common.Models.Forms.FormFieldMatter model,
            Common.Models.Account.Users modifier,
            IDbConnection conn   = null,
            bool closeConnection = true)
        {
            model.ModifiedBy = modifier;
            model.Modified   = DateTime.UtcNow;
            DBOs.Forms.FormFieldMatter dbo = Mapper.Map <DBOs.Forms.FormFieldMatter>(model);

            conn = DataHelper.OpenIfNeeded(conn);

            conn.Execute("UPDATE \"form_field_matter\" SET " +
                         "\"matter_id\"=@MatterId, \"form_field_id\"=@FormFieldId, \"value\"=@Value, \"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId " +
                         "WHERE \"id\"=@Id", dbo);

            DataHelper.Close(conn, closeConnection);

            return(model);
        }
        public static List <Common.Models.Forms.FormFieldMatter> ListForMatter(
            Guid matterId,
            IDbConnection conn   = null,
            bool closeConnection = true)
        {
            List <Common.Models.Forms.FormFieldMatter> list;
            List <Common.Models.Forms.FormField>       fieldList;

            fieldList = Data.Forms.FormField.List(conn, false);
            list      = new List <Common.Models.Forms.FormFieldMatter>();

            fieldList.ForEach(x =>
            {
                Common.Models.Forms.FormFieldMatter ffm;

                ffm = Data.Forms.FormFieldMatter.Get(matterId, x.Id.Value, conn, false);

                if (ffm == null)
                {
                    ffm = new Common.Models.Forms.FormFieldMatter()
                    {
                        FormField = x
                    }
                }
                ;
                else
                {
                    ffm.FormField = x;
                }

                list.Add(ffm);
            });

            DataHelper.Close(conn, closeConnection);

            return(list);
        }
        public static Common.Models.Forms.FormFieldMatter Create(
            Common.Models.Forms.FormFieldMatter model,
            Common.Models.Account.Users creator,
            IDbConnection conn   = null,
            bool closeConnection = true)
        {
            if (!model.Id.HasValue)
            {
                model.Id = Guid.NewGuid();
            }
            model.Created   = model.Modified = DateTime.UtcNow;
            model.CreatedBy = model.ModifiedBy = creator;
            DBOs.Forms.FormFieldMatter dbo = Mapper.Map <DBOs.Forms.FormFieldMatter>(model);

            conn = DataHelper.OpenIfNeeded(conn);

            conn.Execute("INSERT INTO \"form_field_matter\" (\"id\", \"matter_id\", \"form_field_id\", \"value\", \"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") " +
                         "VALUES (@Id, @MatterId, @FormFieldId, @Value, @UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)",
                         dbo);

            DataHelper.Close(conn, closeConnection);

            return(model);
        }
        public static List<Common.Models.Forms.FormFieldMatter> ListForMatter(
            Guid matterId,
            IDbConnection conn = null, 
            bool closeConnection = true)
        {
            List<Common.Models.Forms.FormFieldMatter> list;
            List<Common.Models.Forms.FormField> fieldList;

            fieldList = Data.Forms.FormField.List(conn, false);
            list = new List<Common.Models.Forms.FormFieldMatter>();

            fieldList.ForEach(x =>
            {
                Common.Models.Forms.FormFieldMatter ffm;

                ffm = Data.Forms.FormFieldMatter.Get(matterId, x.Id.Value, conn, false);

                if (ffm == null)
                    ffm = new Common.Models.Forms.FormFieldMatter() 
                    { 
                        FormField = x
                    };
                else
                    ffm.FormField = x;

                list.Add(ffm);
            });

            DataHelper.Close(conn, closeConnection);

            return list;
        }
        public ActionResult FormFields(Guid id, IEnumerable<ViewModels.Forms.FormFieldMatterViewModel> viewModel)
        {
            Common.Models.Matters.Matter matter;
            Common.Models.Account.Users currentUser;

            using (Data.Transaction trans = Data.Transaction.Create(true))
            {
                try
                {
                    currentUser = Data.Account.Users.Get(trans, User.Identity.Name);
                    matter = Data.Matters.Matter.Get(trans, id);

                    viewModel.Each(x =>
                    {
                        Common.Models.Forms.FormFieldMatter model =
                            Data.Forms.FormFieldMatter.Get(trans, matter.Id.Value, x.FormField.Id.Value);

                        if (model != null)
                        {
                            //model = Data.Forms.FormFieldMatter.Get(x.Id.Value);
                            // Edit
                            if (model.Value != x.Value)
                            {
                                model.Value = x.Value;
                                model = Data.Forms.FormFieldMatter.Edit(trans, model, currentUser);
                            }
                        }
                        else
                        {
                            // Create
                            model = new Common.Models.Forms.FormFieldMatter();
                            model.FormField = new Common.Models.Forms.FormField();
                            model.FormField.Id = x.FormField.Id;
                            model.Matter = matter;
                            model.Value = x.Value;
                            model = Data.Forms.FormFieldMatter.Create(trans, model, currentUser);
                        }

                    });

                    trans.Commit();

                    return RedirectToAction("Details", new { Id = id });
                }
                catch
                {
                    trans.Rollback();
                    return FormFields(id);
                }
            }
        }
Exemplo n.º 12
0
        public ActionResult FormFields(Guid id, IEnumerable<ViewModels.Forms.FormFieldMatterViewModel> viewModel)
        {
            Common.Models.Matters.Matter matter;
            Common.Models.Account.Users currentUser;

            currentUser = Data.Account.Users.Get(User.Identity.Name);
            matter = Data.Matters.Matter.Get(id);

            viewModel.Each(x =>
            {
                Common.Models.Forms.FormFieldMatter model = Data.Forms.FormFieldMatter.Get(matter.Id.Value, x.FormField.Id.Value);

                if (model != null)
                {
                    //model = Data.Forms.FormFieldMatter.Get(x.Id.Value);
                    // Edit
                    if (model.Value != x.Value)
                    {
                        model.Value = x.Value;
                        model = Data.Forms.FormFieldMatter.Edit(model, currentUser);
                    }
                }
                else
                {
                    // Create
                    model = new Common.Models.Forms.FormFieldMatter();
                    model.FormField = new Common.Models.Forms.FormField();
                    model.FormField.Id = x.FormField.Id;
                    model.Matter = matter;
                    model.Value = x.Value;
                    model = Data.Forms.FormFieldMatter.Create(model, currentUser);
                }

            });

            return RedirectToAction("Details", new { Id = id });
        }