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); }
public ClSresponsefmailymember InsertFamilyMembers(FamilyClientRequest model) { return(_aceRepository.InsertFamilyMembers(model)); }