예제 #1
0
        internal static GiftListGroupEntity GiftListGroup(GiftListGroup ent)
        {
            GiftListGroupEntity data = new GiftListGroupEntity();

            data.giftListGroupId = ent.Id;
            data.giftListFK = ent.GiftListFK;
            data.groupFK = ent.GroupFK;
            data.updateTimestamp = ent.UpdateTimestamp;
            data.updatePersonFK = ent.UpdatePersonFK;

            return data;
        }
예제 #2
0
        internal static GiftListGroup GiftListGroup(GiftListGroupEntity data)
        {
            GiftListGroup ent = new GiftListGroup();

            ent.Id = data.giftListGroupId;
            ent.GiftListFK = data.giftListFK;
            ent.GroupFK = data.groupFK;
            ent.UpdateTimestamp = data.updateTimestamp;
            ent.UpdatePersonFK = data.updatePersonFK;

            return ent;
        }
예제 #3
0
        public IList<GiftListGroupEntity> GetAllGiftListGroups(IConnection conn)
        {
            List<GiftListGroupEntity> giftListGrouplist = new List<GiftListGroupEntity>();
            string sql = "SELECT giftListGroupId, giftListFK, groupFK, updateTimestamp, updatePersonFK FROM DBO.GIFTLIST;";

            var rdr = conn.ExecuteReader(sql);
            while (rdr.Read())
            {
                var giftListGroup = new GiftListGroupEntity()
                {
                    giftListGroupId = rdr.IsDBNull(rdr.GetOrdinal("giftListGroupId")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListGroupId")),
                    giftListFK = rdr.IsDBNull(rdr.GetOrdinal("giftListFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListFK")),
                    groupFK = rdr.IsDBNull(rdr.GetOrdinal("groupFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("groupFK")),
                    updateTimestamp = rdr.IsDBNull(rdr.GetOrdinal("updateTimestamp")) ? new DateTime() : rdr.GetDateTime(rdr.GetOrdinal("updateTimestamp")),
                    updatePersonFK = rdr.IsDBNull(rdr.GetOrdinal("updatePersonFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("updatePersonFK"))
                };
                giftListGrouplist.Add(giftListGroup);
            }

            return giftListGrouplist;
        }
예제 #4
0
        private void CheckGiftListGroupForRequiredValues(GiftListGroupEntity glg, RepositoryUtils.RepositoryAction action)
        {
            List<string> missingFields = new List<string>();

            //if (String.IsNullOrWhiteSpace(p.userName)) missingFields.Add("User Name");
            //if (String.IsNullOrWhiteSpace(p.emailAddress)) missingFields.Add("Email Address");
            //if (String.IsNullOrWhiteSpace(p.firstName)) missingFields.Add("First Name");
            //if (String.IsNullOrWhiteSpace(p.lastName)) missingFields.Add("Last Name");
            //if (String.IsNullOrWhiteSpace(p.passwordHash)) missingFields.Add("Password");

            if (missingFields.Count > 0)
            {
                throw new Exception(String.Format("Cannot {0} Link: Missing Fields {1}", action.ToString(), String.Join(", ", missingFields.ToArray())));
            }
        }
예제 #5
0
        public void Update(int id, GiftListGroupEntity giftListGroup, IConnection conn)
        {
            CheckGiftListGroupForRequiredValues(giftListGroup, RepositoryUtils.RepositoryAction.Update);

            var giftListGroupToUpdate = GetGiftListGroupById(giftListGroup.giftListGroupId);
            if (giftListGroupToUpdate == null)
            {
                throw new Exception("Gift List does not exist in database");
            }

            string sql = @"UPDATE person SET [giftListFK]=@giftListFK,
                                                    [groupFK]=@groupFK,
                                                    [updateTimestamp]=getdate(),
                                                    [updatePersonFK]=@updatePersonFK
                                                    WHERE giftListGroupId=@giftListGroupId";
            List<SqlParameter> prms = new List<SqlParameter>();

            var param1 = new SqlParameter
            {
                ParameterName = "@giftListFK",
                Value = giftListGroup.giftListFK
            };
            prms.Add(param1);

            var param2 = new SqlParameter
            {
                ParameterName = "@groupFK",
                Value = giftListGroup.groupFK
            };
            prms.Add(param2);

            var param3 = new SqlParameter
            {
                ParameterName = "@updatePersonFK",
                Value = giftListGroup.updatePersonFK
            };
            prms.Add(param3);

            var param4 = new SqlParameter
            {
                ParameterName = "@giftListGroupId",
                Value = giftListGroup.giftListGroupId
            };
            prms.Add(param4);

            var number = conn.ExecuteNonQuery(sql,prms);

            if (number != 1)
            {
                throw new Exception($"No Gift Lsits were updated with Id: {id}");
            }
        }
예제 #6
0
 public void Update(int id, GiftListGroupEntity giftListGroup)
 {
     using (Connection conn = new Connection())
     {
         Update(id, giftListGroup, conn);
     }
 }
예제 #7
0
        public long Insert(GiftListGroupEntity giftListGroup, IConnection conn)
        {
            CheckGiftListGroupForRequiredValues(giftListGroup, RepositoryUtils.RepositoryAction.Insert);
            using (Connection _conn = new Connection())
            {
                var giftListGroupExists = GetGiftListGroup(giftListGroup.giftListFK, giftListGroup.groupFK);
                if (giftListGroupExists != null)
                {
                    throw new Exception($"Gift List Group {giftListGroup.giftListFK} {giftListGroup.groupFK} already exists in database!");
                }

                string sql =
                    @"INSERT INTO[dbo].[giftListGroup] (giftListFK, groupFK, updateTimestamp, updatePersonFK)
                    VALUES(@giftListFK, @groupFK, getdate(), @updatePersonFK );SELECT CAST(scope_identity() AS int)";
                List<SqlParameter> prms = new List<SqlParameter>();

                var param1 = new SqlParameter
                {
                    ParameterName = "@giftListFK",
                    Value = giftListGroup.giftListFK
                };
                prms.Add(param1);

                var param2 = new SqlParameter
                {
                    ParameterName = "@groupFK",
                    Value = giftListGroup.groupFK
                };
                prms.Add(param2);

                var param3 = new SqlParameter
                {
                    ParameterName = "@updatePersonFK",
                    Value = giftListGroup.updatePersonFK
                };
                prms.Add(param3);

                try
                {
                    return int.Parse(_conn.ExecuteScalar(sql,prms).ToString());
                }
                catch (Exception)
                {
                    throw new Exception($"Entity {giftListGroup.giftListFK} {giftListGroup.groupFK} not inserted in database!");
                }

            }
        }
예제 #8
0
 public long Insert(GiftListGroupEntity giftListGroup)
 {
     using (Connection conn = new Connection())
     {
         return Insert(giftListGroup, conn);
     }
 }
예제 #9
0
        public GiftListGroupEntity GetGiftListGroupById(int id, IConnection conn)
        {
            List<GiftListGroupEntity> giftListGrouplist = new List<GiftListGroupEntity>();

            string sql = "SELECT giftListGroupId, giftListFK, groupFK, updateTimestamp, updatePersonFK FROM DBO.GIFTLIST WHERE giftListGroupId = @id;";
            List<SqlParameter> prms = new List<SqlParameter>();

            var paramId = new SqlParameter
            {
                ParameterName = "@id",
                Value = id
            };
            prms.Add(paramId);

            var rdr = conn.ExecuteReader(sql,prms);
            while (rdr.Read())
            {
                var giftListGroup = new GiftListGroupEntity()
                {
                    giftListGroupId = rdr.IsDBNull(rdr.GetOrdinal("giftListGroupId")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListGroupId")),
                    giftListFK = rdr.IsDBNull(rdr.GetOrdinal("giftListFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListFK")),
                    groupFK = rdr.IsDBNull(rdr.GetOrdinal("groupFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("groupFK")),
                    updateTimestamp = rdr.IsDBNull(rdr.GetOrdinal("updateTimestamp")) ? new DateTime() : rdr.GetDateTime(rdr.GetOrdinal("updateTimestamp")),
                    updatePersonFK = rdr.IsDBNull(rdr.GetOrdinal("updatePersonFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("updatePersonFK"))
                };
                giftListGrouplist.Add(giftListGroup);
            }

            return giftListGrouplist.FirstOrDefault();
        }
예제 #10
0
        public IList<GiftListGroupEntity> GetAllGiftListGroups(int group, IConnection conn)
        {
            List<GiftListGroupEntity> giftListGrouplist = new List<GiftListGroupEntity>();

            string sql = "SELECT giftListGroupId, giftListFK, groupFK, updateTimestamp, updatePersonFK FROM DBO.GIFTLIST WHERE groupFK = @groupFK;";
            List<SqlParameter> prms = new List<SqlParameter>();

            var paramQuery = new SqlParameter
            {
                ParameterName = "@groupFK",
                Value = group
            };
            prms.Add(paramQuery);

            var rdr = conn.ExecuteReader(sql,prms);
            while (rdr.Read())
            {
                var giftListGroup = new GiftListGroupEntity()
                {
                    giftListGroupId = rdr.IsDBNull(rdr.GetOrdinal("giftListGroupId")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListGroupId")),
                    giftListFK = rdr.IsDBNull(rdr.GetOrdinal("giftListFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("giftListFK")),
                    groupFK = rdr.IsDBNull(rdr.GetOrdinal("groupFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("groupFK")),
                    updateTimestamp = rdr.IsDBNull(rdr.GetOrdinal("updateTimestamp")) ? new DateTime() : rdr.GetDateTime(rdr.GetOrdinal("updateTimestamp")),
                    updatePersonFK = rdr.IsDBNull(rdr.GetOrdinal("updatePersonFK")) ? -1 : rdr.GetInt32(rdr.GetOrdinal("updatePersonFK"))
                };
                giftListGrouplist.Add(giftListGroup);
            }

            return giftListGrouplist;
        }