Beispiel #1
0
        public ClSresponsefmailymember InsertFamilyMembers(FamilyClientRequest model)
        {
            ClSresponsefmailymember ServiceTypesList = new ClSresponsefmailymember();

            using (IDbConnection con = new SqlConnection(ConnectionString))
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                DynamicParameters parameters = new DynamicParameters();
                parameters.Add("@FMFirstName", model.FirstName);
                parameters.Add("@FMLastName", model.LastName);
                parameters.Add("@FMEmail", model.Email);
                if (model.DateOfBirth == System.DateTime.MinValue)
                {
                    parameters.Add("@FMBirthDate", null);
                }
                else
                {
                    parameters.Add("@FMBirthDate", model.DateOfBirth);
                }

                parameters.Add("@FMPhone", model.PhoneNumber);
                parameters.Add("@ACEClientId", model.ACEClientId);
                parameters.Add("@CustomerId", model.CustomerId);
                parameters.Add("@UserId", model.UserId);
                ServiceTypesList = con.Query <ClSresponsefmailymember>("CreateFamilyMembers", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault();
            }
            return(ServiceTypesList);
        }
Beispiel #2
0
 public ClSresponsefmailymember InsertFamilyMembers(FamilyClientRequest model)
 {
     return(_aceRepository.InsertFamilyMembers(model));
 }